shelties
asked on
Access 2007 runtime error 2950
I have an Access 2007 application which performs an Output to Excel Macro.
It works everywhere but runtime where I receive an error 2950 and a message saying "The command or action output to isn't available now". I have enabled content prior to compiling or creating a runtime. Funny thimg is (not really so funny) that it was running fine in runtime until I add more code to other non-related parts of the system. It still works everywhere except in runtime. I have run the macro on XP, Vista and Windows 7 as a runtime until I created a new runtime. Any suggestion will be appreciated.
It works everywhere but runtime where I receive an error 2950 and a message saying "The command or action output to isn't available now". I have enabled content prior to compiling or creating a runtime. Funny thimg is (not really so funny) that it was running fine in runtime until I add more code to other non-related parts of the system. It still works everywhere except in runtime. I have run the macro on XP, Vista and Windows 7 as a runtime until I created a new runtime. Any suggestion will be appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The issue continued when attempting to execute the macro from a runtime version on a VISTA machine. I would like the issue to be re-opened. Sorry for the confusion here. I'm new at experts-exchange.
Shelties
Shelties
The error you're getting is somewhat generic and doesn't really point to anything specific.
On the Vista machine, where is your database installed? What folder?
On the Vista machine, where is your database installed? What folder?
Also, can you post the code that throws the error?
ASKER
OutputTo Table, Vendors, Text Files (*.txt), C:\Vendors.txt, No, , 0, Print
Folder = C:\
I changed the Xls to .txt This works in Runtime with XP but not VISTA the error I get is :
Can't save the output data to the file you've selected
Then it refers to open files and permissions
Folder = C:\
I changed the Xls to .txt This works in Runtime with XP but not VISTA the error I get is :
Can't save the output data to the file you've selected
Then it refers to open files and permissions
ASKER
Took some time, but I found an error in the code.
Thanks.
Thanks.
ASKER