Username

[binksmatthew]

is there any way that i am able to get the username from combo box on the login form that i created to a text box on the switch board that appears after the user has logged in.

 

[boblarson]

Assign it to a Public variable, declared in the general declarations section of a STANDARD (not FORM) module. Then it can be accessed directly by any form at any time.

One thing to note, if you are going to have multiple users using the database at the same time, you need to split the database and give each user a copy of the front end. Otherwise, when they log in then someone else logs in the first users stuff will be replaced with the new one.

 

[binksmatthew]

cheers for the reply but could you explain how this is done please as i am fairly new to Access. thanks

 

[boblarson]

I already showed you how to create the variable in:
http://www.access-programmers.co.uk/forums/showthread.php?t=124122
(with pictures)

But to access it from your other form, in the load event of the switchboard put

Me.YourTextBoxNameHere = strLogin

 

[binksmatthew]

in your coding does 'strLogin' stand for the name of the column in which the employees Username is stored in the table. also should the form name be included in the module.

 

[boblarson]

No, strLogin is the name of the variable we created in the referenced post (the post you posted earlier as to how to create the variable)
http://www.access-programmers.co.uk/forums/showthread.php?t=124122

I was assuming that you had already, in the login form's close event put
strLogin = Me.YourLoginFormUserNameTextBoxHere