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
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