Need username to print on each page in Access2007 (like header)

[oatie]

I'm a teacher and will be teaching Access this year. In Word & Excel I have
my students put their name in the header/footer sections so I can tell who's
papers are who's? I cannot find a way to do this in Access and need to see
if there is a easy way to add something in the top or bottom that I can
distinguish each students papers. When I go to print preview it
automatically has the database Table name and date at the top and the Page #
at the bottom. How can I add something else to these areas?? THANKS

 

[Neil]

Assuming your students log in to Windows with unique user names you could use
a routine such as the one at:

http://www.nwarwick.co.uk/OfficeVBAFindUserName.html

to retrieve the user name and assign it to a variable, and then inser tthe
contents of the variable into a footer or header of your choice.

HTH

Neil