Outputing Access report to Excel error

  • Thread starter Thread starter Ross
  • Start date Start date
R

Ross

Could someone shed some light on a problem that I can't seem to resolve.

I have a Access2003 Database with various forms and reports, on some reports
the user has an option to print preview the result of a report and also a
button (standard with access) to Analyse it with MS Office Excel.

It used to work fine, but now for some reason it gives an error when they
press this button.

"Microsoft Office Access can't complete the Output oprtation.
The Visual Basic code you entered contains a syntax error or the Output
procedures are not available."

It is only doing it on 1 PC and I have reloaded MS Office and it still does
it.

Thanks in advance for any Ideas
Ross
 
You may have a reference to an old libary. Go to the code of some report,
form, or start a new module then click on Tools - References and see if any
start with MISSING:

My guess is your db was created in an older version of Access?

Hope this helps.

- Jason
 
Thank Jason, I will give it a go.


Jason W. Martin com> said:
You may have a reference to an old libary. Go to the code of some report,
form, or start a new module then click on Tools - References and see if
any start with MISSING:

My guess is your db was created in an older version of Access?

Hope this helps.

- Jason
Click to expand...
 
Back
Top