By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,462 Members | 2,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,462 IT Pros & Developers. It's quick & easy.

Date Parameter

Presto731
P: 53
I have a paremeter query that asks for a date. Is there way to have a calendar pop up instead of the parameter dialog box?
Jul 17 '07 #1
Share this Question
Share on Google+
5 Replies


puppydogbuddy
Expert 100+
P: 1,923
I have a paremeter query that asks for a date. Is there way to have a calendar pop up instead of the parameter dialog box?
Yes, see this link for a calendar that is developed using an Access form. A native access form is preferable to an activeX calendar for the reasons stated in the link. The link also has step by step instructions for setting up the calendar form in your application.

http://allenbrowne.com/ser-51.html
Jul 17 '07 #2

Presto731
P: 53
Awesome, Thanks for the help!


Yes, see this link for a calendar that is developed using an Access form. A native access form is preferable to an activeX calendar for the reasons stated in the link. The link also has step by step instructions for setting up the calendar form in your application.

http://allenbrowne.com/ser-51.html
Jul 17 '07 #3

P: 2
I have a parameter query that asks for Start Date and End Date before running. I'd like this calendar to pop up so the user does not have to manually enter the dates.

How do I point the query at the calendar form? I know I have to build an expression in the criteria, but I've no clue how to use the "Between..And.." phrase to direct it to the calendar. Also, do I need to make any changes to the properties of the Calendar?

I'm using the calendar from the link above. Any help is appreciated.

Thanks,
PT
Aug 9 '07 #4

puppydogbuddy
Expert 100+
P: 1,923
I have a parameter query that asks for Start Date and End Date before running. I'd like this calendar to pop up so the user does not have to manually enter the dates.

How do I point the query at the calendar form? I know I have to build an expression in the criteria, but I've no clue how to use the "Between..And.." phrase to direct it to the calendar. Also, do I need to make any changes to the properties of the Calendar?

I'm using the calendar from the link above. Any help is appreciated.

Thanks,
PT
Complete instructions for the calendar are contained in the link. The calendar comes with several options to choose from (like first day of the week) so you will have to set the property sheet for the options you want to change.

The calendar is opened by a command button that is tied to a particular text box (txtStartDate, txtEndDate). You would have 2 buttons, one for each textbox. So the date selected is read from/written back to the applicable textbox control on your form.

Your query would look something like this:
Expand|Select|Wrap|Line Numbers
  1. Select * From Your Table 
  2. Where [your datefield] Between Forms!YourForm!txtStartDate And Forms!YourForm!txtEndDate
Aug 9 '07 #5

P: 2
Got it! Works great now.

I didnt understand that it needed to pull from the text boxes.

Thank you!
Aug 9 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.