User Name in Textbox

[Chalkie42]

I am adding some finishing touches to my database. I want a 'Welcome' form shown as the database is opened and a greeting like "Welcome *****".
My problem is this: by using =environ("Username") I get the right result except that my network logs everyone in as a staff number, ie 45812457.

I don't want "Welcome 45212587", I'd rather have "Welcome Steve". Is there a way I can set the user staff numbers against names in a table and have the textbox display the name?

I would be grateful for any help you can give.

Thanks, Steve

 

[pbaldy]

Sure; you could use DLookup to get the name associated with the login number. Good reference on the syntax:

http://www.mvps.org/access/general/gen0018.htm

 

[oxicottin]

Chalkie, I use this welcome screen and it sound like its exactly what your looking for....

 

[Chalkie42]

Thanks Guys,

I'll try the Dsum on Monday morning.

Oxicottin, thanks, great looking welcome form (which I'll use) but I still need to 'translate' the system name into the users 'real' name.

Chalkie.