Call fOSUserName()

[IanT]

I have successfully been using fOSUserName() code to identify the network user of the database. We have just had a pc repaired, using this pc to use the database, the code for fOSUserName() will not work! In fact access does not seem to use the call to get the code. Is there a setting somewhere which would corse this, on the othe network pc's all is fine.

 

[ColinEssex]

Try using

Environ("Username")

Its much easier

Col

 

[IanT]

Thanks..........

Thats not really the issue. It appears that when access is used on this specific machine the vba code is not always recognised, as though a setting has been changed on this machine!!

 

[Bat17]

It could be a reference problem, but that normaly shows up as functions not working or compile errors.
in any module check Tools>References... and see if any come up marked as missing

Peter