By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,448 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Opening a form as read only

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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 wrote:
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

Nov 13 '05 #2

P: n/a
rkc
Steve wrote:
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.

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.
Nov 13 '05 #3

P: n/a
thats exactly what i was after thankyou very much!

steve
"Nikos Yannacopoulos" <ny*******************@in.gr> wrote in message
news:OY****************@TK2MSFTNGP09.phx.gbl...
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 wrote:
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


Nov 13 '05 #4

P: n/a
thanks for the assistance. much appreciated

steve
"rkc" <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in message
news:6n*****************@twister.nyroc.rr.com...
Steve wrote:
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.

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.

Nov 13 '05 #5

P: n/a
Steve wrote:
thanks for the assistance. much appreciated

steve
"rkc" <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in message
news:6n*****************@twister.nyroc.rr.com...
Steve wrote:
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.

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.


What the heck. One more method
DoCmd.OpenForm "FormName", acNormal, , , acFormReadOnly
Nov 13 '05 #6

P: n/a

"Steve" <no@no.com> wrote in message
news:42**********************@news.optusnet.com.au ...
thats exactly what i was after thankyou very much!

steve
"Nikos Yannacopoulos" <ny*******************@in.gr> wrote in message
news:OY****************@TK2MSFTNGP09.phx.gbl...
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 wrote:
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


Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.