|
Subject:
|
User Name
|
|
Posted By:
|
justinc.
|
Post Date:
|
8/8/2008 12:43:49 PM
|
I'm trying to get the user name to automatically pop into a field called Rep Name and I have the field as required. What I am trying to do is get the network user name that they login to windows with to automatically pop in this field. I have multiple users and i need it to be saved for a report that i generate. Any help with this would be very helpful thanks 
JustinC
|
|
Reply By:
|
adamcarboni
|
Reply Date:
|
8/11/2008 11:08:03 AM
|
To get the username you use the Environ function
for example
Me.RepName = Environ("USERNAME")
there's other information you can get too like computername, etc.
|
|
Reply By:
|
justinc.
|
Reply Date:
|
8/11/2008 4:41:41 PM
|
ok i just got that to work. but now its not saving the Rep Name. i need this to identify the Rep that took this information for a report.
JustinC
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
8/13/2008 7:43:20 AM
|
What do you mean that "it is not saving the rep name?"
mmcdonal
Look it up at: http://wrox.books24x7.com
|
|
Reply By:
|
justinc.
|
Reply Date:
|
8/14/2008 9:38:14 AM
|
when i go to run the report it does not show the rep's name in the rep field of the report its blank, however it does show the rep name in the rep name in the form. Any help with this???? thanks again to all who have helped.
JustinC
|
|
Reply By:
|
SerranoG
|
Reply Date:
|
8/22/2008 6:58:26 AM
|
Make sure the rep control in the report is bound to the same field from the same table/query that the form is.
Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
|
|
Reply By:
|
justinc.
|
Reply Date:
|
9/5/2008 4:55:38 PM
|
ok i now have all of that taken care of, now i'm having another a problem. someone has taken all of the tool bars off of the database from the startup menu. now i cant get to the different views or menus. i have tried the short cut keys and they don not work so that option must be disabled as well. Please HELP!!  any help with this would be great.
JustinC
|
