[sbhagat786]

I want to generate a script that would launch an access database which needs two entries - start date (yesterdays date) and end date ( todays date) every morning 7am and also print the report to a particular printer.
I have just the basic vb6 knowledge (VBin 24hrs by SAM) and no experience. If someone would give me suggestions and guidance, it would be wonderful.
Appreciate your help!!!!

[Nova Dragoon]

this belongs in VB forum

[born2c0de]

sbhagat786, on Sep 28 2005, 09:30 PM, said:

I want to generate a script that would launch an access database which needs two entries - start date (yesterdays date) and end date ( todays date) every morning 7am and also print the report to a particular printer.
I have just the basic vb6 knowledge (VBin 24hrs by SAM) and no experience. If someone would give me suggestions and guidance, it would be wonderful.
Appreciate your help!!!!

Which method do you want to use?
You can either do it programatically or use the Data Control.

[Amadeus]

Well, any VB application can easily be scheduled by the operating system, so you just have to define exactly what you want the application to do. Here is a short look at working with dbs from VB...and you can take a look at this for some ideas about printing, including the Printer object, although it has its own problems...aside from that, what does the application have to do?

[sbhagat786]

born2c0de, on Sep 28 2005, 11:28 AM, said:

sbhagat786, on Sep 28 2005, 09:30 PM, said:

I want to generate a script that would launch an access database which needs two entries - start date (yesterdays date) and end date ( todays date) every morning 7am and also print the report to a particular printer.
I have just the basic vb6 knowledge (VBin 24hrs by SAM) and no experience. If someone would give me suggestions and guidance, it would be wonderful.
Appreciate your help!!!!

Which method do you want to use?
You can either do it programatically or use the Data Control.

Hello Pro!
Will sound stupid - if you use VB6 is it programatically?
I have no idea about Data control.
I would prefer to have it simple as possible so I can understand and trouble shoot.

[born2c0de]

If you want it to be as simple as possible, use the ADO Data Control.
I'll post a tutorial soon on it, but meanwhile you can experiment with it and ask any questions you have on it on the forums.
The Data Control is by default placed in the General Tab in the Toolbox. Place your mouse over each control and wait for the tooltip to appear so you know which one is the data control.
Once the Control is added, click on the Custom Property and the Rest is all a matter of selecting options.