nachiketdp
Board Regular
- Joined
- Jan 31, 2007
- Messages
- 53
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
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