J
Jay
Thank you in advance
My access MDB project (MyProject.mdb) has a query named as Qry_Daily_Report.
This query is just a select-query with bunch of data in it.
Switchboard is my default one with start-up setting and I use windows
scheduler to run Myproject switchboard on daily basis..
As Swithboard opens on Form_open event , I want following things to be done.
1. Run Qry_Daily_Report and save this as Daily_Report_Today's Date format (
ex. Daily_Report_June_10_2006) in MyDocuments folder.
2. After step 1 is done, Toos>> Datbase Utilities >> Repair and Compact
Database
should be run
3. Exit Myproject.
Any code and comment are welcomed!
My access MDB project (MyProject.mdb) has a query named as Qry_Daily_Report.
This query is just a select-query with bunch of data in it.
Switchboard is my default one with start-up setting and I use windows
scheduler to run Myproject switchboard on daily basis..
As Swithboard opens on Form_open event , I want following things to be done.
1. Run Qry_Daily_Report and save this as Daily_Report_Today's Date format (
ex. Daily_Report_June_10_2006) in MyDocuments folder.
2. After step 1 is done, Toos>> Datbase Utilities >> Repair and Compact
Database
should be run
3. Exit Myproject.
Any code and comment are welcomed!