Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / November 2007

Tip: Looking for answers? Try searching our database.

Parameter dates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chi - 13 Nov 2007 19:02 GMT
Hi,

I use Between [Date1] And [Date2] in my query. It works fine. The users will
enter the dates in the message boxes. Is there a way to insert the calendar
on these message boxes so they can click on the calendar instead of entering?
Form? or Report?

Please help.
Thanks
Chi
Klatuu - 13 Nov 2007 19:25 GMT
Not the way you are doing it.
You would have to create two controls on a form.  The controls can be
calendar controls.  Then your query should reference the controls on the form:

Between [Forms]![MyForm]![Date1] And [Forms]![MyForm]![Date2]

Signature

Dave Hargis, Microsoft Access MVP

> Hi,
>
[quoted text clipped - 6 lines]
> Thanks
> Chi
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.