Have a specific form open based on user/ Is this possible?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our inventory db is currently secured and permissions applied based on the
specific user. However, my manager likes the current framework for admin
level users and doesn't want to change it. He did ask me if I could set it up
so when a standard user opens it, they only get one form within this db and
that is a data entry form. Is it possible to associate specific forms to open
by specific user or group?

Thank you to all in advance, your knowledge is greatly appreciated!
 
Yes, you can have a startup code that checks to see either who the current
user is (CurrentUser function), or checks to see if the current user is a
member of some group (code in the security FAQ)
http://support.microsoft.com/?id=207793

Then open the appropriate form. You could use an autoexec macro to run the
code or do this in the open event of a startup form.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering a form based on a filter on an open form 2
Open form to specific record 2
Open Specific Record 1
Password associated with a particular form - Acess 2007 1
Is it possible to have a button provide a users with more than 1 choice in access? 0
apply form filter on open form 1
Open a form while hiding Access DB interface. 1
Show Users Logged On 8

Back
Top