473,322 Members | 1,755 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Access 2K - Read-Only Forms

Have a f-end/b-end database, with three forms that are dual-purpose...

If the user clicks one button on the Main Menu, then the form opens
allowing edits; if the user clicks another button on the Main Menu,
the form (should!) open Read-Only - only it doesn't...

Of the forms that should behave in this way, two of the three operate
fine - preventing changes to any of the controls - the other one just
doesn't want to be locked down. Here's what I've tried:

1. Changing "AllowEdits" via VB, both from Form_Open and Form_Current
2. Changing "AllowEdits" in form design

Both of these methods had the same result - the third form could still
be edited.

Having looked through the discussion threads, the only thing I haven't
tried is locking all the controls on the form - but this seems a bit
excessive.

Any thoughts would be appreciated (to stop me losing my mind!)

Cheers,

PTurn
Nov 13 '05 #1
2 1193
For your 3rd form, you have some code that is dirtying the record, probably
in Form_Current.

Wisely, Microsoft allows you to continue your edit and save the change if
the form is dirty, even if AllowEdits is set to No, so you are not stuck in
the situation where you cannot complete the entry.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"pturn" <pt***@talk21.com> wrote in message
news:85**************************@posting.google.c om...
Have a f-end/b-end database, with three forms that are dual-purpose...

If the user clicks one button on the Main Menu, then the form opens
allowing edits; if the user clicks another button on the Main Menu,
the form (should!) open Read-Only - only it doesn't...

Of the forms that should behave in this way, two of the three operate
fine - preventing changes to any of the controls - the other one just
doesn't want to be locked down. Here's what I've tried:

1. Changing "AllowEdits" via VB, both from Form_Open and Form_Current
2. Changing "AllowEdits" in form design

Both of these methods had the same result - the third form could still
be edited.

Having looked through the discussion threads, the only thing I haven't
tried is locking all the controls on the form - but this seems a bit
excessive.

Any thoughts would be appreciated (to stop me losing my mind!)

Cheers,

PTurn

Nov 13 '05 #2

Allen,

Many thanks for that... It turned out that I was modifying some hidden
controls, and even though they were unbound it was still causing the
AllowEdits failure.

You've saved my day from being totally wasted!

PTurn
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: David ROBERT | last post by:
Hello, I need to read data from a MS Access database. The program (reader) is installed on a linux box and is written in python langage. The database is MS Access 2002 installed on a Win XP box...
2
by: Daniel | last post by:
I use an Access database to basically take data exports, import them, manipulate the data, and then turn them into exportable reports. I do this using numerous macros, and queries to get the data...
4
by: Dalan | last post by:
After reading and experiencing the phenomenon of installing MS Office 2000 on a system that already has MS Office 97, or for that matter just Access 97 Runtime, I saw the ugliness that ensues. If...
7
by: Mike Dwyer | last post by:
I need a VB 6 app to automate a microsoft access MDB application. Specifically, it needs to open a form in Access and read information keyed into that form. I know this is "old school" but I'm...
3
by: frekster | last post by:
All. I have a folder/files that I have added asp.net to have read/write/etc. privlidges via the properties of the folder/files and security tab. However, when I run my asp.net page, I still get...
1
by: Paul M | last post by:
Hello, I want to to be able to read line by line the contents (ie the html) inside some Data Access Pages I have in a Microsoft Access database. There doesnt seem to be a call I can use in the...
1
by: d.albano | last post by:
Hi to all, this is my first post in this group. I need to directly access to a disk but i'm getting some problem to let to filestream to work. I use createfile to acquire PhysicalDrive0...
16
by: JoeW | last post by:
I'm utilizing a database that I created within MS Access within a program I've created in VB.NET. I am using the VB front end to navigate the information, but want to be able to print a report,...
2
by: job | last post by:
In a sharepoint setup using smartpart to load our user controls using enterprise blocks (data) we are getting some strange errors (logged to the event log). We dont get the error all the time. When...
1
by: Ryan Ritten | last post by:
Hey all, At the company I work for our team of ASP.NET developers have requested that the aspnet_wp account (the account that IIS runs under) needs to have full read access to the entire server...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.