ms access training - Protecting a form

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

Resolved · Low Priority · Version Standard

Protecting a form

Jill has attended:
Access Intermediate course

by - delegate Jill [1 post] (2007 Feb 2 Fri, 11:14) Reply

Can I lock a form so others at work who use it can not change things and cause errors?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Bayswater	0	FULL
2003	2008 Sep 3 Wed	Southwark	1	book now	£235	£240
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	8	book now	£110	£224
Full Schedule: See all 55 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Protecting a form

by - trainer Richard platinum contributer [785 posts] (2007 Feb 2 Fri, 11:22) Reply

Yes Jill you can.

Go to the design view of the form you want to lock.
On the very top left corner, you will see a square - double click on it.
This sdhows the properties on the entire form.
Go to the data tab, and set the ALLOW fields to "no" (ie. ALLOWADD, ALLOWEDIT etc.).
Test the form as you go along to create the result you are looking for.

If users are using a switchboard to open the form, you can set the properties to be read only, via the controls on the switchboard manager. Ask if you want to know more.
Richard

· How Reorganising Your Data Can Take Your Business to the Next Level
· Get More Out of MS Access Courses
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Microsoft Access Training Opens Doors
· Reasons to Consider Microsoft Access Training

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips