tnguyen315
MIS
Please help,
I have an access form with 2 text boxes "Start Date" and "End Date" and a button "Closed form". I would like when the user hit the closed button, then it will automatically copy the external database to another folder and rename it based on those 2 text boxes.
The external database is in network "K:\Custom\TVB\Customer.mdb"....This is the original database. On the form, Start Date: 04/01/2009, End Date: 04/21/2009. When user click on the closed button on the form...I would like to copy the Customer database and place it in another folder and rename based on Start and End Date such as "K:\Custom\TVB\NewDB\040109-042109-Customer.mdb"....
If anybody know, please help...I'm very appreciated.
Thanks.
I have an access form with 2 text boxes "Start Date" and "End Date" and a button "Closed form". I would like when the user hit the closed button, then it will automatically copy the external database to another folder and rename it based on those 2 text boxes.
The external database is in network "K:\Custom\TVB\Customer.mdb"....This is the original database. On the form, Start Date: 04/01/2009, End Date: 04/21/2009. When user click on the closed button on the form...I would like to copy the Customer database and place it in another folder and rename based on Start and End Date such as "K:\Custom\TVB\NewDB\040109-042109-Customer.mdb"....
If anybody know, please help...I'm very appreciated.
Thanks.