Passing data from ActiveX Calendar to SQL query

[Bwintech]

Hi,

Im a dba and have not as yet indulged in the use of activex controls. I am now faced with building an front end to query the database and I would like to use the ActiveX calendar control to query over a date range.

I have played around a little but do not really understand how I can reference the date variables from the activex command and attach them to the sql statement.

I know how to query perfectly through VB script but not sure how to referance the variables of the object.

I would greatly appreciate any help of guidance on this matter, thank you kindly for your help.

 

[grtammi]

If you check the Developer Solutions database (Access), it shows you a slick example of how to use the Calendar control with an SQL query.

Greg