Thanks Crystal. That worked fine, but how do I get the date picker on the form? The textbox control on the form is unbound. When I click the command button to run the query, just a plain text box appears w/no date picker.
Thanks,
John
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi John,
>
> it would be best to use a form to collect your parameter. then you can have the date picker as well as control things
>
>
> 1. make a blank form, Name --> f_MainMenu
> 2. make a control to collect the date, Name --> Date1
> 3. make a command button with Click [Event Procedure] --> DoCmd.OpenQuery "MyQueryName"
>
>
> then, in your query, use this for your criteria:
>
> forms!_MainMenu!Date1
>
> I have a date range on my menu form. You may decide to add a second date as well, which is the reason for the "1" on the end of Date1
>
> for a menu form:
> RecordSelectors --> No
> NavigationButtons --> No
> DividingLines --> No
> Warm Regards,
> Crystal
>
> Microsoft MVP
> remote programming and training
>
> Access Basics by Crystal
> http://www.AccessMVP.com/strive4peace
> Free 100-page book that covers essentials in Access
>
> *
> (: have an awesome day :)
> *
>
>
>
>
> ________________________________
> From: yshopper
>
> Is there any way to have a date picker open up when a Parameter query is run? I would like to eliminate any mistakes when entering the date.
>
> Thanks,
> John
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar