login form and main form

[msasan1367]

how can I create login form that it opens on main form and if login successfully it closes and shows main form and if login unsuccessfully alert. thanks

[June7]

Login form is a common topic. Search forum or google. Here is one to start https://www.accessforums.net/program...ord-32218.html

[sherryb41]

Here is one you can modify. Denis Wright was so kind to share it with me.

[sherryb41]

I might not be any hlep to you, but if you are good at figuring things out this may help. Good luck.

I forgot to include his instructions for the database above:

You will need to do the following:

1. Unzip the Password items database
2. Open a database that you want to use the password system on, and import everything from Password items (tblAssociate, frmPassword, Gearbox, and the 2 code modules)
3. Edit tblAssociate to enter your user name and other details.
4. Launch frmPassword, enter your name and password and hit OK. The Switchboard should launch.

That shows how to get to the Switchboard via a login. Now, for EVERY form where you want the read-write-edit permissions to be varied, you need to copy the code that is in the Form_Open event of Gearbox and paste that into the code module for each form. That code is

Private Sub Form_Open(Cancel As Integer)
Select Case gintLevel
Case 1 'read-only
Me.AllowEdits = False
Me.AllowAdditions = False
Me.AllowDeletions = False
Case 2 'edit existing records
Me.AllowEdits = True
Me.AllowAdditions = False
Me.AllowDeletions = False
Case 3 'create, add new, delete
Me.AllowEdits = True
Me.AllowAdditions = True
Me.AllowDeletions = True
End Select
End Sub

If you haven’t done this before, here are the steps:

1. Open the form in Design view
2. In the Properties go to Events, and find the On Open event.
3. Double-click the blank line so you see [Event procedure], then click the … at the end of the line. You should then see

Private Sub Form_Open(Cancel As Integer)

End Sub

Replace that with the code above, close and save the form
Now when that form is opened from the switchboard the users should have the editing privileges defined by their level (see comments in the code).

[burrina]

There is one here on the forum FYI. I uploaded it myself a while back.

[msasan1367]

find:

https://www.accessforums.net/access/open-form-another-form-32673.html#post166114