W
WC Lo
I have a form with a query. Usually when the form is close or change of record, the query will update the database. is it possible to build a read-only query? thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Nikos Yannacopoulos
No, you cannot have a "read-only" query, but you can have a "read-only"
form. Open the form in design view, select the form and change the following
properties (on the Data tab):
Allow Edits
Allow Additions
Allow Deletions
from Yes to No.
HTH,
Nikos
read-only query? thanks
form. Open the form in design view, select the form and change the following
properties (on the Data tab):
Allow Edits
Allow Additions
Allow Deletions
from Yes to No.
HTH,
Nikos
record, the query will update the database. is it possible to build aWC Lo said:I have a form with a query. Usually when the form is close or change of
read-only query? thanks
B
Brendan Reynolds
In query design view, change the Recordset Type property of the query to
Snapshot.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
read-only query? thanks
Snapshot.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
record, the query will update the database. is it possible to build aWC Lo said:I have a form with a query. Usually when the form is close or change of
read-only query? thanks
R
Rick Brandt
Nikos Yannacopoulos said:No, you cannot have a "read-only" query, [snip]
Actually you can in several ways. Setting the RecordSet type to Snapshot
is the easiest way, but there are several others.