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

JustinC

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.

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

What do you mean that "it is not saving the rep name?"


mmcdonal

Look it up at: http://wrox.books24x7.com

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

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

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