query by date (but i want to do it with clickable calendar)?

B

_Bigred

Hello All,

(Access 2000)


I have a query that queries by date range (Prompts for "start" date and
"end" date) then returns the results that fall between those dates.

Is there a way to setup that query so that the user actually gets a pop-up
calendar of some sort, to select their "start" and "end" dates from when
prompted by the query?

Thanks,
_Bigred
 
M

Michel Walsh

Hi,


Have a form that displays two calendar controls and a button "run the
query". Once the user will click that last button, the query would have to
read the FORMS!FormName!CalendarControlName to get its input starting and
ending date.



Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate prompts in crosstab query and subsequent report 1
Query User Defined date range 2
Create a Query that Prompts for Date and Time 4
MS Project 2016 - all tasks not showing in Calendar View 0
date confusion 2
Date Range - Between Start and End 7
Query to return latest dates 5
How to filter on calculated dates 3

Top