Password Protecting a form

R

Ron

Can someone help me with this. I want to create a login form that pops up
when you try to enter a form I want to protect, I created the form, but do
not know how to get it to pop up when I try to enter the form I want to
protect. The form i want protected is called Maintenance Switchboard. This
form also has other buttons that opens other forms. Can anyone help me with
this.

Thanks,
Ron
 
I

Ian B

Hi Ron,

Look Up InputBox Function in the Visual Basic of a form

There is an example of enteing a number. You could change it to show a
password
then do a if statament to check if valid. if not throw them out.

Hope this helps
 
E

Ed Robichaud

You can have a login form for the app that stores 1 record in a local table
for user ID & password. Set the Enabled property of the command button that
calls your Mx form depending on the value of that record.

Another method, perhaps simpler, is just to have a different front end app
(with less menus & forms) for restricted users. It can be linked to the
same back end data tables, but this "crippled" version can have a
combination of non-visible, disabled, read-only, etc controls/forms.
-Ed
 
Top