Why not just set the form FrmViewDataSheetEntry to invisible?
Your queries could still use the values even if the form is hidden.
Duane Hookom
MS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: bradgriffis@yahoo.com
Date: Fri, 8 Jul 2011 18:35:09 +0000
Subject: Re: [MS_AccessPros] Multiple controls based on a single query
Thanks for quick reply! This is my first post and I think this forum will be very helpful in working through some snags in my database.
I know what you mean by wanting to avoid paramater prompts. My paramater queries are based on forms to make a better user interface. To understand the issue better, pull up my database and on the main menu click the "Add Time Records" button. Enter Username = Griffis and Password = staff1. This will get you into the main data entry form. On that form click the "View Datasheet" button. Notice that you need to enter a username and password again. That is what I want to avoid. I want the time records to appear in datasheet view immediately based on the query that was initially used to login.
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> If I understand correctly, you are using parameter prompt type queries. IMO, these are never appropriate user interface. I would replace them with references to controls on a form. You could hide the form if you don't want users to see it. Check this link http://www.tek-tips.com/faqs.cfm?fid=6763.
>
> Duane Hookom
> MS Access MVP
>
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: bradgriffis@...
> 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]
>
[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