Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Disabling record additions in query results
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Disabling record additions in query results
Resolved · Low Priority · Version 2003
Reply
Disabling record additions in query results
HiI am trying to find a way that will disable the ability to add a new record in the results of a query.
I have managed to show the results of the query in a form and have disabled additions in there but wondered if i could also do a similar thing in the tabular view of the query results.
I am allowing the user to choose which way they view the results (in a table or in forms)
Thanks
Camilla
For upcoming training course dates see: Pricing & availability
RE: Disabling record additions in query results
Hi CamilaThanks for your question
The short answer is that there is no easy way to prevent the editing and updating of a query. It is however, unnecessay as data should always be viewed through forms and never directly in tables or queries.
To get the "feel" of looking at the data in the table, create a second form to your existing one and set its default view to "Datasheet". Thus you form will look as if you are viewing it in the original table.
Regards
Stephen
|
 |
|
» Forum post: Table queries |
How can i make a table query?
