Front End Setup for Different users

[rts]

I have a database set up for our Construction projects. I modeled it so each project would start with its own database for time constraint reasons. I would like to have a back end and front end so that my boss can look at all projects from one back end db and the project managers will only see the forms/reports relevant to their project. I know I can use the project # as the primary key, but how would I go about making the front end databases only show information relevant to a certain project? I don't want them to have to enter their project number each time, I want it to automatically filter once they have entered their project information one time at job start-up. Do I have to go into each form at set up filters? Any advice on the best way to approach this is greatly appreciated. Thanks!

[June7]

Yes, each query/form/report must have filter parameter. The parameter can be a reference to a global variable that holds the project number or a textbox on a form that is always open (a main menu maybe). Set the variable or textbox when user logs in.

[RuralGuy]

You could use the Volume Label of the hard disk to determine which machine you were running on without asking the user any questions: http://access.mvps.org/access/general/gen0030.htm
...or use an API to get the local machine name on the network: http://access.mvps.org/access/api/api0009.htm

[June7]

I use VBA.Environ("USERNAME") - yes, exactly as shown - in VBA code to get the network id of user and API is not needed. Access doesn't recognize the Environ function so must be in VBA.

[rts]

Great! Thanks so much, I know my approach now!