Wapug
Registered User.
- Local time
- Today, 13:07
- Joined
- Apr 14, 2017
- Messages
- 51
At the end of every month I, or someone else now, need to export a query named qMonthEndMaintenanceData to an excel workbook with a tab named qMonthEndMaintenanceData. The Excel file is already located in a folder named for the previous month and workbook named for the month. I can do this in access by creating an export and just going in and updating the path, however, I would like to automate it for others, so they are not going into the database and monkeying with things. How can I set it so that a button on a form will open a browser to allow my user to browse to and select \\ShareDrive1\Tracking\April\AprilMonthEndData.xlsx or whatever location they wish?