I'd like to use a DTPicker Control that is on a dialog form, in my query 

criteria to select a date field. I can't reference it.



Thanks,



Pedro Metello

Pedro



What is the name of your Date/Time Picker?  Here's how you can reference

it.



I have two Date/Time Pickers on a form.  Once called ocxDtTime_From and

one called ocxDtTime_To.

I also have a label (lblMsg) on the form that displays the values of the

two controls

I've added a button (cmdViewDates) to fill the label's caption property

when its Click event is activated.



Here's the code:



Private Sub cmdViewDates_Click()



    lblMsg.Caption = "From " & ocxDtTime_From & " thru " & ocxDtTime_To

    

End Sub



John Ruff - The Eternal Optimist :-)







-----Original Message-----

From: pedro.metello@m...

[mailto:pedro.metello@m...] 

Sent: Monday, November 26, 2001 8:17 PM

To: Access

Subject: [access] How to use Dtpicker in a query criteria ?





I'd like to use a DTPicker Control that is on a dialog form, in my query



criteria to select a date field. I can't reference it.



Thanks,



Pedro Metello

---

You are currently subscribed to access as: papparuff@c... To

unsubscribe send a blank email to $subst('Email.Unsub')

DTPicker is available through VB6, are you sure it's available in Access?



Walt

It is available if you have the Developer's version of Access



John Ruff - The Eternal Optimist :-)







-----Original Message-----

From: Walt Morgan [mailto:wmorgan@s...] 

Sent: Monday, November 26, 2001 12:24 PM

To: Access

Subject: [access] Re: How to use Dtpicker in a query criteria ?





DTPicker is available through VB6, are you sure it's available in

Access?



Walt







---

You are currently subscribed to access as: papparuff@c... To

unsubscribe send a blank email to $subst('Email.Unsub')