On print

[Guest]

When printing a particular form, I have the following formula in a text box:
=Format(Date(),"dddd"", ""mmm d yyyy")
This prints on the form the current date.
I would like to include somehow the name of the person who printed the form.

Excel can show the name of the person in track changes even though the
person hasn't used a password to get into the spreadsheet. Presumably it gets
the information from the network login. My database doesn't require a
password either, so I was wondering if this is possible to achieve in Access.

tia

 

[Guest]

Try this:
http://www.mvps.org/access/api/api0008.htm

 

[Guest]

Schasteen,
At the rist of appearing thick, I can't get this to work! Where do I place
this module so the users name is displayed?

Thanks

 

[Guest]

Copy the code to a new module, then make a textbox on you report and set the
control source to =fOSUserName()

 

[Guest]

Done that before, but I got the 'name?' error displayed.
Will persevere though.

Thanks

 

[Guest]

I know you will get a 'name' error if you do not have "=" before the function
name in the control source.

 

[Guest]

I've got this as the control source for the text box: =fOSUserName() but I
still get the name? error

Any ideas????

 

[Guest]

Where is the function saved at? Make sure it is in a module ans not in the
code behind a form. Not sure if I explained myself well.

 

[Guest]

I created a new module as per your instructions and called it 'fOSUserName()'
I then copied and pasted the code
The control source of the text box is '=fOSUserName()'
Do I need to alter any of the code for it to recognise our network?

Off home now. Thanks.

Regards,

Jock Waddington

 

[Guest]

Change the name of the module. Having the module name and function name the
same is probably causing the conflict.

 

[Guest]

I'll give that a whirl when I get in tomorrow.
Thanks again,

Jock

 

[Guest]

Got there eventually!!
Thanks very much for your help on this. Works a treat
Cheers Schasteen.