VBA code to automatically load relevant switchboard based upon the user
Results 1 to 3 of 3

Thread: VBA code to automatically load relevant switchboard based upon the user
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2007
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA code to automatically load relevant switchboard based upon the user

    Dear all,

    I'm using MS Access 2010. I've created a file wherein I've created a form for a user login with password. I've created different switchboards for different users. I also have a users table against which I've mapped switchboard IDs. Now I want to write a macro so that once the user enters his user id followed by password, the file should automatically load the switchboard relevant to the user.

    Thus I will be able to define different levels of users having different types of rights to work within the database.

    However, I am not able to properly write code for the same. Presently, it only loads the default switchboard irrespective of the user. Can someone help me? I can email the file to you for complete reference.

    Any help will be highly appreciated!

    Thanks & Regards,
    Nachiket Pendharkar

  2. #2
    Board Regular GinaWhipp's Avatar
    Join Date
    Sep 2009
    Location
    Ohio
    Posts
    124
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA code to automatically load relevant switchboard based upon the user

    Perhaps this will help...
    Log-On Form

  3. #3
    Board Regular
    Join Date
    Jan 2007
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA code to automatically load relevant switchboard based upon the user

    Thanks GinaWhipp for your kind reply! Will explore this solution and will revert, in case there are issues... Thanks once more!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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