Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Searching for data by user account

Status
Not open for further replies.

ScubaStevo

Programmer
May 4, 2002
132
AU
Hi

Is there a way to search for data by the user logged in? That is, to search for all records that the particular user has entered without having a series of queries for each user?

Thanks

Steve
 
yes, there is a field where the user enters their name for each record
 
In the query use Currentuser() as the criteria in the name column.
 
actually the users enter their initials rather than than their name, and they sign in with their name so does that mean this wont work?
 
Sign in to what?
Access?
If users get the Access login/password prompt then currentuser reports whatever they logged in as.
 
But if they are recording initials then yes, it won't work.
You will need a lookup table to convert from username to initials.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top