Outputing Access report to Excel error

[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

 

[Jason W. Martin]

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

 

[Ross]

Thank Jason, I will give it a go.

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