Opening a form as read only

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

i am new to access and i have setup a database for my business. However i
was wondering if there is a way to open a form as read-only.

thanks

steve
 
Steve,

Open the form in design view, select the form object (Edit > Select
Form), display the properties window (View > Properties) if not already
visible, select tab Data and set the following three properties to No:
Allow Edits
Allow Deletions
Allow Additions

HTH,
Nikos
 
Steve said:
i am new to access and i have setup a database for my business. However i
was wondering if there is a way to open a form as read-only.
Click to expand...


Open the form's property sheet, click the data tab and you will see
a number of properties that can be set to accomplish this.

The easiest way is to set the recordset type to snapshot.
 
Steve said:
thanks for the assistance. much appreciated

steve
Click to expand...
What the heck. One more method
DoCmd.OpenForm "FormName", acNormal, , , acFormReadOnly
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Database Opening as Read Only 1
Access 2007 opens read only 0
Access Command to run access, open to specific form and specific record 1
Access How Current page of a form Read Only 2
Error message prevents form creation 2
Read-only problem 5
Read-Only permissions make database read-only to others 3

Back
Top