Hey all,

So at work lately, I've been converting all of our automated databases from a PC over to a virtual server. One big difference and time consuming process for me has been adjustng all vba code to work with 2010. the old pc was still using 2000.

So, my latest problem seems to be with getting the error OutputTo command is not available. All of these databases are run via task scheduler and either run a macro that then opens a form, or opens the database itself with a startup form getting launched.

I thought I had the issue resolved, by switching from macros to startup forms, as it seemed to resolve the issue for a week. (I think its due to the navigation pane not being visible in 2010) - which I thought was related to a macro opening a form.

I have searched for a few weeks now, and can't seem to find a definite answer to this problem. Hoping someone here has some insight on this, or a possible work around.

docmd.transferspreadsheet works fine, however I need outputto for ths particular database that exports reports and rtf files.


Note: the same database will run fine If i manually open the database and launch the form. No errors get thrown. Only if task scheduler launchs the database via macro ...and apparently now even if a startup form launches with no macro.