I want to add a pop up calendar to an access 2013 query

Greetings:
I have a query that is currently asking the user for a start and end date.
Is there an easy way to tie this to a point and click calendar?
Thanks!
Dennis
DGWhittakerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
use a form with two unbound textboxes StartDate, EndDate

set the format property of the textboxes to short date

revised the criteria of the query to refer to the form and textboxes
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
As a complete aside :) :

IMO you really should not allow users to directly access a query. Queries should be used as a datasource for a Form/Report, for data manipulation, etc etc - but they really shouldn't be used as a UIX convention.

Instead, create a Form, and the use the Query as a Recordsource for the form. Setting the form as a Datasheet view will give you the same basic look-and-feel, and will make it harder for your users to muck around in your query. You can also easily filter a form when opening using the WHERE argument of the OpenReport method.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.