My supervisor today tasked me with a request that the access DB I am working on have a dropdown box with a user selection (maybe with password maybe without). Once the user "Logs in" it will store this information somewhere then when the user fills in a new form it will put their username/name into a field so he can see who filled out the form. This should be fairly simple but I don't know how to do it or even the official term for it. The supervisor doesn't want it where they are required to choose their username/name when they start to fill out the form (because that would be easy!!!). I believe from what I have been able to gather that this is called "user tracking" but I am not sure if it is or not. My background is computer support/graphic design not access or VBA programming so I can make a pretty database but with some of the more advanced stuff like this I am at a loss.
So to be specific: I am looking for a way that when the end user starts the database it requires them to choose their name, and when they start to fill out a new form it stores that name somewhere in the table and will display on the form.
Sorry to post in General I didn't know where this should go.
I am working in Access 2010 in a non-web database that I have been told will be ported over to SQL at completion.
So to be specific: I am looking for a way that when the end user starts the database it requires them to choose their name, and when they start to fill out a new form it stores that name somewhere in the table and will display on the form.
Sorry to post in General I didn't know where this should go.
I am working in Access 2010 in a non-web database that I have been told will be ported over to SQL at completion.