Gustav Brock
gustav at cactus.dk
Mon Feb 24 11:40:01 CST 2003
Hi Charlotte > It works that way in runtime as well, Gustav. You don't have to be able > to see the database window to have this work. Thanks - I didn't know that. /gustav >> I think you are talking about the lines: >>> DoCmd.SelectObject acReport, "rptPRODUCT", True >>> DoCmd.RunCommand acCmdPrintPreview >> The True argument select the item from the database window. > Ah - I never use that, as I prefer a runtime environment where you can't > see the database window. So how do you handle that situation? > /gustav >> How can you select the report when it has not been opened? >>> This doesn't work: >>> DoCmd.OpenReport "rptPRODUCT", acPreview >>> This works: >>> DoCmd.SelectObject acReport, "rptPRODUCT", True >>> DoCmd.RunCommand acCmdPrintPreview >>> Although this may seem like a fix, I have to re-write code to handle >>> opening the report with a 'where' clause since 'where' clauses aren't >>> supported using the Runcommand method. >>> There must be a fix for this problem. >>> Anyone seen this problem? >>> I have Access Runtime on a PC that also has Office XP. If I create a >>> new database in XP (As an Access 2000 format), with one table with a >>> simple report and try to print or print preview, I get that Microsoft >>> Error where it wants to send a report to Microsoft. Then it kicks me >>> out of Access. >>> But, If I run the application with XP instead of the Runtime version, >>> there is no problem. Remember, this is an Access 2000 formatted >>> Database. >>> If I run the runtime on a machine that has Access 2000 and not XP, >>> there is no problem.