OutputTo

[Guest]

Hi All,
I'm Using (MS Access XP on Windows XP).
I have a function that outputs report to SNP Format, the report-menu is displayed after the Autoexec Macro.

For the same data:
I'm encoutering an error : "The command or action 'OutputTo' isn't available now...".
If I bypass the Autoexec Macro and re-run it (from inside the application), no error is displayed.

Any Help will be very appreciated.
Thanks in advance.

G.Haddad

 

[Bill Nicholson]

From your description it might be a situation where Access isn't completely
loaded and initialized yet, but I'm only speculating. What I'd try first is
adding a programatic delay before your OutputTo command to give Access more
time to finish its start-up. You could write a simple for-next loop and
inside the loop execute a series of Sleep commands.

Just a guess.

Bill Nicholson
nicomp @ yahoo.com

Hi All,
I'm Using (MS Access XP on Windows XP).
I have a function that outputs report to SNP Format, the report-menu is

displayed after the Autoexec Macro.

For the same data:
I'm encoutering an error : "The command or action 'OutputTo' isn't available now...".
If I bypass the Autoexec Macro and re-run it (from inside the

application), no error is displayed.

 

[Guest]

hi

I tried what you suggested but it didn't work

Note: I'm not running directly the OutputTo command after the Autoexec Macro

The Macro displays a menu from which I run my Code to do the OutputTo Task

-If I Bypass the Autoexec, then after that MS Access is loaded, I run the Autoexec macro, the menu is displayed normaly and no error is occured

-If I Open the application and the Autoexec is run directly then the error appears

I tried to make a delay (30 seconds) before displaying the menu but nothing hapenned

Very wier

Any help
G.Haddad