Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opening two forms at the same time (Access 97 SR-2)

    I have a password security system that others in the office helped develop that is in VBA. The log-in form contains a user name and password with an option group that opens different forms for data entry. It works great. The password is checked and only allows users that are assigned certain records access to those records.

    What I would like to do is to have the log-in form open every time a user opens any form and set the permissions for access to their records. I added the log-in form to the OnActivate event on a test form. Both forms opened but the log-in form is behind the data entry form and is not visible.

    What I would like to do is get rid of the option group on the log-in form, have the log-in form to open first when a particular data entry form is called, get filled in, and then open the data entry form with the proper permissions. Can this be done? TIA.

  2. #2
    Star Lounger
    Join Date
    Sep 2001
    Location
    SC, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening two forms at the same time (Access 97 SR-2)

    You can have the log-in form open as a pop-up, which will cause it to remain on top until the user logs in and clicks okay. I have another idea you might want to try: Why not get rid of the option group, but only have the user log-in once? When they log-in and click okay, pass some value from the log-in form to a menu form. The menu form can contain command buttons to your various forms. Code behind the buttons will open the appropriate form using the log-in value to determine which records the user may view. Let the menu form remain open, so that whenever a form is closed, the user again sees the menu and can choose another form or close the database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •