Well a work-around I found is to simply open the form before the OutputTo, and close it once complete.
Can't guess exactly why it works though. Something to do with the modules being loaded I guess.
Thanks, but I'm not really familiar with DoEvents, so I can't seem to get it to work. Maybe a little more info will help -
The automation actually works fine when it's executed while Access is already open (through OnLoad or OnClick events), but when I open the db through a Scheduled Task...
I am automatically opening an mdb and outputting both a query and a report to the local machine. It seems I can only automate 1 OutputTo action. Whenever I try both (in either order, or the same one twice) it returns:
Run-time error '2046'
'The command or action OutputTo isn't available now'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.