Limit Query to Current User Name

[Mark]

I'm trying to build a query that will report production stats for system
users, but I'd like to limit the results to the current user. The username
is a field in the data, so I can query on it. But, is there a way to include
the current username is the query conditions without the user having to enter
it? I want for them to only see their own stats, not their team mates. I'm
sure it can be done; anybody know how?
Thanks in advance!
Mark

 

[Douglas J. Steele]

Assuming you're doing this inside of Access, take a look at
http://www.mvps.org/access/api/api0008.htm at "The Access Web". If you're
doing this from outside of Access, you're out of luck, as you cannot use VBA
functions in queries executing outside of Access.

 

[Mark]

Yep, I'm querying from Access. I copied that code into a new module. I've
never created or used a module. How do I call it in my query?

 

[Douglas J. Steele]

Your query would be something like

SELECT Field1, Field2, Field3
FROM MyTable
WHERE UserID = fOSUserName()

Incidentally, if you're not used to code, make sure you didn't name the
module fOSUserName: modules cannot have the same name as functions or subs
contained within them.

 

[Mark]

Thank You!!! That worked. Thanks for clarifying about the module name. I
had indeed given it the same name as the function. Thanks for your help. I
appreciate it BIG Time.