A Question from a Newbie:

[cephalon]

Hi All:

I'm somewhat new to Access, and I'm trying to build a little database for my office. I have most of it set up, and one of the pieces of the app is a parameter query that asks for a person's initials to display the processes they are overseeing. What I would like to be able to do is set up individual shortcuts on a per-user basis that each feed the parameter query a different set of initials.

Is there a way to do this? Or perhaps a cleaner way to implement this type of thing?

 

[Laurentech]

Set up user-level security and the user's will have to log in. You'll then be able to use application.currentuser to see who is logged in.

Larry