Runtime 2010 problem

[rickbanny]

Hi Guys

Got a problem with some code running in Access 2010 Runtime. This code runs fine when full-blown Access is installed but fails with a runtime error and closed the database when fired off in Runtime 2010.

Any Ideas?

DoCmd.OutputTo acOutputReport, "Report_Name", "Excel97-Excel2003Workbook(*.xls)", "\\filepath" & ".xls", False, "", , acExportQualityPrint

 

[Ranman256]

Some commands are not available in runtime.
Do you run commands at start?
It could be that output statement. Try transferSpreadsheet.

 

[rickbanny]

Some commands are not available in runtime.
Do you run commands at start?
It could be that output statement. Try transferSpreadsheet.

Hi

Tried transferSpreadsheet but that fails as well with te same error - no commands are run at start.

Cheers

 

[arnelgp]

DoCmd.OutputTo acOutputReport, "Report_Name", acFormatXLS, filepath & ".xls"

 

[Minty]

Pu an on error handler in and capture the error, then you will see what the runtime doesn't like.