Run-time error '2046' on OutputTo

[scmroddy]

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'

Thanks in advance!

 

[beetee]

Just a guess, but is it possible the two 'output to' commands are attempting, but failing to, run concurrently?

If that's the case, I'm not sure of a bulletproof way to tell the output to is complete. One method might be to put the second 'output to' command in a loop (with a DoEvent), and k

 

[beetee]

Sorry, I truncated the previous response... (stored it in notepad after the server hung up, then pasted it back incorrectly)


Just a guess, but is it possible the two 'output to' commands are attempting, but failing to, run concurrently?

If that's the case, I'm not sure of a bulletproof way to tell the output to is complete. One method might be to put the second 'output to' command in a loop (with a DoEvent), and keep trying until the error doesn't occur.

 

[scmroddy]

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, it returns this error.

 

[scmroddy]

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.

 

[myknlat]

That makes it too easy. However, it does work. I thought it a conflict between a timer_interval in my automatic database shutdown in the event that the user did not use the db for 30 minutes. The funny thing is that it works (without opening and closing) in design mode where you override autoexec macro and db settings (pressing shift). Nonetheless, my quest has subsided until I reinvent the urge to find out why my subsequent instances of OutputTo can't be done. Thanks for the tip.

Myk

 

[myknlat]

Application.Echo False

code to open
code to output
code to output (cont)
code to close

Application.Echo True

... and they won't know you took the easy way. Happy OutputTo-ing.