I
IMNovice
How can I create an Access AutoExec macro that I can use with Task Scheduler
so that at a certain time and day, it will launch Access and open a mdb file,
run query and print report? The problem I'm having is when Access is launched
and is opening the file, the macro security dialog box pops up and I have to
click ok or alt+O to continue to open the file. How do I get around this?
Presntly the macro security level is set to "medium". Do I need to set the
macro security level to "lowest"? Is there a way to leave the macro setting
at "medium" and write vb code or something to get around resetting the
security level?
so that at a certain time and day, it will launch Access and open a mdb file,
run query and print report? The problem I'm having is when Access is launched
and is opening the file, the macro security dialog box pops up and I have to
click ok or alt+O to continue to open the file. How do I get around this?
Presntly the macro security level is set to "medium". Do I need to set the
macro security level to "lowest"? Is there a way to leave the macro setting
at "medium" and write vb code or something to get around resetting the
security level?