Access Macro to check the Environ("UserName")

[pavin]

Hi All,

I have a requirement where I need to use the Access Macro to check for the username who opened the database. I know how to use it in VBA module, but was trying the same in Macro wizard and it isn't working. Request for help. Thank you.

I used

if Environ("UserName") = "xxxx" then


Note, I need it only in the Macro and not in VBA module. Thank you

 

[Joe4]

I used

if Environ("UserName") = "xxxx" then

Exactly where/how did you use this?

I would recommend creating a simply VBA Function to return the Username. You can then use that Function in your Macros.
See: How to get logged-in user's name in Access vba? - Stack Overflow
especially the second reply (by Josh Jordan)

 

[HiTechCoach]

I tried Environ() in a Macro in 2010 and it did not like it.

I was able to do this:

1) in the startup run this line of VBA code:

TempVars.Add "UserName", Environ("UserName")


2) In the macro you can use:

If TempVars]![Username] = "xxx" Then