Username in query??

[WinDancer]

Trying to capture the user name in an append query-

using RB: Environ("UserName") in a query row errs out

Help, Please?

Thanks,
Dave

 

[boblarson]

For that you'll probably need a wrapper function.

Create this in a standard module:

Function RetUser()
   RetUser = Environ("username")
End Function

and then call RetUser() instead.

 

[WinDancer]

Bob, as soon as you posted I realized tat I have a module already- just copied that into the current project and it worked fine.
Thanks,
Dave