No entering data!

  • Thread starter Thread starter Jorge
  • Start date Start date
J

Jorge

Good day!

I have been trying to create an Access DB with help from all here.
I appreciate it.

Question:
I have 2 tables created with data that is looked to for information.
How do you place a table so that additional data cannot be entered?
I tried to put a validation rule in, but it tells me "validation rules have
changed --- too complex"... ?
Is this not the proper way?

Thank-You
Jor
 
You can't "lock" a table. What you do is not enter directly into the table.
Instead use Forms to enter the data. In the form, you can control what can
and can't be entered. If you don't want the user to see the table, right
click the table, choose Properties, and check the Hidden box. You can view
the table if you need to by going to Tools|Options|View tab and checking the
Hidden box.
 
Not sure if I asked this correctly?

I do not wish the user to click the "add new record button" on the list at
the bottom of the form.
Even if select whether its enabled or locked it still shows at the bottom.
This table is to have only 14 entries and they should not be changed unless
a mgr changes them..

Is this better?

Thank - u
 
Jorge said:
Not sure if I asked this correctly?

I do not wish the user to click the "add new record button" on the list at
the bottom of the form.
Even if select whether its enabled or locked it still shows at the bottom.
This table is to have only 14 entries and they should not be changed unless
a mgr changes them..

Is this better?
Click to expand...

The form has a property on the Data tab of the property sheet named
AllowAdditions.
 
The Allow Additions option is for the form (or subform) not for the subform
control that holds the subform. The first time you click on a subform in
design view, you actually get the subform control on the main form. If you
click a second time, you'll get the subform. Make sure you click the box in
the upper left corner where the rulers come together to get the form's
properties, not the properties of a section or control on the form.

The property can also be set through code. If you have a way that you
determine who a manager is when they are using the database you could check
this value and in the subforms Open event set Me.AllowAdditions=False or
True accordingly.
 
Back
Top