input mask changed, how do I update the forms

R

rigby

i have created a table from an existing spreadsheet in excell. so i have a
table full of data already, now i have to change the table to suit my design.
its a long process as i'm fairly new to access. i created forms linked to the
table but then had to go back and change the input mask in a few fields in
the table, but i need to now update the forms so that they will perform the
same functions i entered into the input mask, but they wont. how do i go
about avoiding having to re-create the forms from scratch again? please help.
 
W

Wayne Morgan

Changing the Input Mask in the table field won't update the Input Mask in
the controls on forms. To do that, open the form in design view, click on
the control you want to update, click the Properties dialog button on the
toolbar to open the Properties dialog (if it isn't already open) and set the
new input mask for the control. The Input Mask is on the Data tab of the
Properties dialog. Save the changes and close the form.
 
R

rigby

Thank you Wayne. That worked just right. my other problem which you may be
able to help me with is that i was trying the security settings for the first
time and once i was done, i found it wouldnt let me save any changes i wanted
to make to the forms. it kept telling me i needed permission from the
administrator. surely i am the administrator? how can i go about undo-ing
ALL the security settings and just keeping it as it was before?
 
W

Wayne Morgan

In the default workgroup, there is one user, Admin, and two groups, Admins
and Users. The Admin user has full permissions on everything, the Admins
Group has no permissions, and the Users group has full permissions on
everything.

The easiest way to remove the security may be to just create a new file that
has no security set and import the items from the current file.
 
Top