Gustav Brock
gustav at cactus.dk
Mon Feb 24 11:03:30 CST 2003
Hi John > 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.