Jumat, 08 Juli 2011

RE: [MS_AccessPros] Multiple controls based on a single query

Brad,
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