vb 6 and access report

[keithsimpson3973]

Does anyone know, and if so can they give me an idea of how to do it, if the following is possible....

My access report is based on a start date and stop date. What I would like to do is have vb6 display a calendar the user would pick the start date and end date for the report instead of having to type the dates into the dialog box that Access displays when the report is run.

Thanks for any help you can give!

[padhuwork]

Does anyone know, and if so can they give me an idea of how to do it, if the following is possible....

My access report is based on a start date and stop date. What I would like to do is have vb6 display a calendar the user would pick the start date and end date for the report instead of having to type the dates into the dialog box that Access displays when the report is run.

Thanks for any help you can give!

Add this Control
Microsoft Windows Common Controls-2 6.0 (SP6)

if you haven't installed Service Pack 6, install it, you will be able to add this control.

Once you are done, you can control called DTPicker (Date Picker), using this you will be selected date, it appears like a combo box, once dropped down, calendar is shown with navigations (forward or backward)


All the best
Padhu

[keithsimpson3973]

Thanks Pahdu. I knew that. I actually have a custom form with a calendar on it that I select the date from. I do not know how to write the code. I am not sure how you would pass the data to replace the access prompt with a vb prompt?

[Killer42]

Thanks Pahdu. I knew that. I actually have a custom form with a calendar on it that I select the date from. I do not know how to write the code. I am not sure how you would pass the data to replace the access prompt with a vb prompt?

Are you running this report from VB6 now? Or only from inside access?