Can I use a Parameter on a Date/Time Field?

[Paul H]

I have a query I need to run based on a date time field. I want the parameters to be entered via a text boxes on a form, i.e. >= frm_Myform!txt_Begin_DateTime and <= frm_Myform!txt_End_DateTime
My question is, how do I get the time portion of this entered into my form and use it in the query. I have tried several different ways without success.

Any ideas?

[pbaldy]

This is one way:

    strCriteria = "ActionDateTime Between #" & DateValue(Me.txtFromDate) + TimeValue(Nz(Me.txtFromTime, "0:00")) _
                & "# And #" & DateValue(Me.txtToDate) + TimeValue(Nz(Me.txtToTime, "23:59")) & "#"

Which is building a wherecondition for this technique:

BaldyWeb wherecondition

I'm also using the Nz() function to allow the user to leave the time textboxes empty.

[Paul H]

Thanks Paul,

To avoid rebuilding the entire (very long) query in code I put this in the appropriate column in the criteria row in the Query module:

>=DateValue([Forms]![frm_DowntimeReasons]![txt_FromDate])+TimeValue([Forms]![frm_DowntimeReasons]![txt_FromTime]) And <=DateValue([Forms]![frm_DowntimeReasons]![txt_TillDate])+TimeValue([Forms]![frm_DowntimeReasons]![txt_TillTime]) 

To my surprise it worked.

Here's a bonus question. Is there any kind "time picker" similar to the Date Picker property in the text box?

[pbaldy]

I haven't used it but Brent is very sharp:

http://www.utteraccess.com/forum/Tim...-t1454249.html

[Paul H]

That's pretty interesting Paul, but kind of over the top for my purposes right now. I'll keep it on file for future reference. I think I can work with what I got for now.

Thanks for the assist.

Paul

[pbaldy]

No problem Paul.