Hello, I am creating a simple time tracking database for my department at work. To get to the main data entry form I created a simple password system where the user enters a userid and password into a form. The password form then runs a paramater query that pulls up only the records for a particular user based on the userid and password. Once the user is into the main data entry form they can add or edit records in form view, or click a "View Datasheet" button to view their records in datasheet view. As it is now, the user clicks the View Datasheet button and needs to enter their userid and password a second time to run another query. How can I base the View Datasheet button on the same parameter query that was created when the user logged in, so that when the button is clicked the datasheet appears immediately?
I put a zipped copy of my database in a folder named "PTS Time Tool" in the "Assistance Needed" folder. The file is named "TimeTool_1" I use Access 2007 and my experience level is intermediate.
Thanks,
Brad
Jumat, 08 Juli 2011
[MS_AccessPros] Multiple controls based on a single query
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar