Runtime Error when running report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running a module in Access that exports data to Excel. When I ran this
DB on Windows 2000, I had no errors.

After switching to Windows XP, I get an error that debugs to the VBA code in
Access.

Once the macros is running, the Excel spread sheet opens. If I click on
another tab in the worksheet I get this error in my Acess VBA:

Run-time error '50290':
Application-defined or object-defined error

I am not sure where this problem stems from: Access, Excel, VBA or Windows
XP.

Any advice would be greatly appreciated!

Thanks in Advance,
Elena
 
If you converted the database from 2000 to XP, that causes some problems, try
creating a new XP database in 2002 format, then import all the objects from
your other database, compact and repair the recently created one, if the
problem persists check the topic in the knwoledge database in microsoft.com,
usually thet have good step-by-step resolutions,
 
Back
Top