Disabling record additions in query results

The UK's most regular instructor-led training courses.
Training information: microsoft access 2002 training · Microsoft.access.courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

2 posts

ReplyMon 11 Jan 2010, 13:46Delegate Camilla said...

Camilla has attended:
Access Introduction course

Disabling record additions in query results

Hi

I 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

Version	Date	Location	Places available	Book	Next place rate (£)
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Wed 24 Mar 2010	Bloomsbury	5		£240	£245
2003	Tue 6 Apr 2010	Southwark	9		£203	£208
2007	Thu 13 May 2010	Bloomsbury	7		£188	£193
2003	Tue 18 May 2010	Bloomsbury	9		£182	£187
2003	Fri 2 Jul 2010	Bloomsbury	7		£85	£90
2003	Thu 19 Aug 2010	Southwark	10		£75	£80
Full Schedule: See all 10 Access Advanced course dates. Bookings currently available until 14th December 2010.

755 posts

ReplyMon 11 Jan 2010, 14:55Trainer Stephen said...

RE: Disabling record additions in query results

Hi Camila

Thanks 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

· Microsoft Access Tighten your Security Controls
· Why a Microsoft Access Course Could Change the Way You Do Business
· Why go on a Microsoft Access Training Course?
· Get More Out of MS Access Courses
· Want To Get Started With Macros In Microsoft Access?

Please browse our web site to find out more about
microsoft access 2002 training and other Microsoft training courses.

Access tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips