Ability to create user login and identify the users when exporting

[sk88]

Is it possible to create/ assign username and passwords to each users to enter the database and fill out the forms each time and have the query keep track / record which user filled the form and notify us when we do the export ?



Thanks in advance

[June7]

Query would not track anything. Tables hold data. Queries manipulate data. What you want would require VBA code. You can either assign usernames and passwords or get the user's network login ID (assuming database is on a network server).

[sk88]

Query would not track anything. Tables hold data. Queries manipulate data. What you want would require VBA code. You can either assign usernames and passwords or get the user's network login ID (assuming database is on a network server).

Thanks June.

So what I have created right now is a table that holds username and passwords.

Then I have created a form which will ask for USER LOGIN and PASSWORD.
The users will then be able to fill forms and save it.

now, how do I know which user filled the forms ? How do I link their names to the form they are filling so that when I export to excel files, I will have their names beside each form?

Did I make sense?

[June7]

Not quite sure how the export will capture the username. Might have to actually be a field in the table where the username is saved.

I presume these users will be repeat users? You will need to use VBA code to verify the login/password combination as saved to the table. Again, if these users have already logged into a network, could use code to get the username from the network login, then users don't even have to do a 'login'. Use VBA.Environ("USERNAME") in VBA code. Access does not recognize the Environ function so use VBA code to populate textbox on form.

Regardless, will probably need to use VBA code to save username to the record or at least to a textbox on the form user is completing.

[sk88]

Not quite sure how the export will capture the username. Might have to actually be a field in the table where the username is saved.

I presume these users will be repeat users? You will need to use VBA code to verify the login/password combination as saved to the table. Again, if these users have already logged into a network, could use code to get the username from the network login, then users don't even have to do a 'login'. Use VBA.Environ("USERNAME") in VBA code. Access does not recognize the Environ function so use VBA code to populate textbox on form.

Regardless, will probably need to use VBA code to save username to the record or at least to a textbox on the form user is completing.

Thanks, June.

The users will be repeat users. I was thinking of using VBA code to save username to the record (i.e. to the tables) after user login.
But how do I go about doing that? Do you by chance know the code?

So basically what I have right now is when the user open the database, a login screen will appear and will ask for user login and password.
once completed, it will take the users to the main menu where the user can click to either ADD NEW INFORMATION or EXPORT.

Under ADD NEW INFORMATION - it is a form where the user have to complete and save and this is where I would like to create the VBA Code to have ACCESS save the username to the record.

So that in the end, I would know which user filled what information.


Hope you or some one can help me with me.

Sorry, I am still learning Access so VBA codes are fairly new to me.