I have a query and in the criteria field want to add a date and time, where the user can select from a form calendar. I know I can create a form where the user can select both the date and time using the Microsoft date and time picker control 6, but how do i:

1. Have the format in say 15/12/2005 16:00:00 (I've tried playing around with the custom format on the date and time picker under properties but not sure if its a bug or me!)

2. Pass the date and time into the query criteria

thanks for any help!

Hiya,

   In order to change the Date/Time format, you need to change it on your system. Access (all apps) use the system time format, so perhaps this is effecting your ability to change this parameter.

If you are using a form field to hold the Date and Time (I don't know if it is one field or two) then in the query design, in the criteria for the date (and time) field(s), put this code:

[Forms]![YourFormName].[DateFieldName]

When the query is run, it will look for the criteria the user has selected on your form.

You may want to put a check on the button that calls the query or the report to see if the field is populated, otherwise the user will get an error.

HTH

mmcdonal

Hi Thanks very much for your help. As I can't change the system time date format, I've used the calendaer control 9, and a second Text box with time validation format.

I've set-up a third text box that is bounded and combines the two selections, the first one being the date from the calendar selected and the second one being the Time Input

=[ActiveXCtl0] & " " & [Time_Input]

How do I update the third text box so that if the user selects a different date from the calendar this is what is displayed? I've tried various options but not managed to figure this out??

The query runs fine as you suggested..

thx !