Duane Hookom
MS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: bradgriffis@yahoo.com
Date: Fri, 8 Jul 2011 17:58:04 +0000
Subject: [MS_AccessPros] Multiple controls based on a single query
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
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Tidak ada komentar:
Posting Komentar