Disabling record additions in query results | Access forum

Resolved · Low Priority · Version 2003

Mon 11 Jan 2010, 13:46 Delegate 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

Mon 11 Jan 2010, 14:55 Trainer 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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips