How to use Access 07 DatePicker in Query Criteria

[bharlow]

I have a query that allows the users to pick a date range using the criteria Between [Enter begining Date] and [Enter Ending Date].

Is there a way to replace the box under Enter Beginning Date and Enter Ending Date with the built in DatePicker in Access 2007?

Thanks for any advice!!

 

[pbaldy]

Not that I know of. Most of us would use a form with 2 textboxes for user input, and have the query point to them for the criteria.

 

[HiTechCoach]

I agree with Paul.

I would use a form to collect the criteria. I prefer this method because I can provide a better UI for the user.

Attached is an example of some ways to use forms to collect the criteria.

Hope this helps ...

 

[bharlow]

I'll give that a try.

Thanks for your help!!

 

[RamanathanN]

Hi Friends,

I am creating a room booking system in Access 2007. Bookingdate is the primary key and indexed. How do I use the Datepicker to retrieve any bookings already been booked. For Example when a date is selected from the Datepicker if there is any booking the it should load automatically. Could someone help me please how to do this?

Thank you

Nathan.