Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Issue in creating macros in MS Access.

Copper Contributor


I would like to create a macro to run queries in MS Access, and  then schedule it.

I am able to create a macro to export the output excel file to local folder,  but have to enter the input parameters (query has four input date parameter which is the start and end date of the pay period) manually for that. 

I would like help to have this programmed, so that the query can run on schedule with input parameter being dynamically programmed instead of manual entry.  

Any help on this is greatly appreciated. 

0 Replies