Charlotte Foust
cfoust at infostatsystems.com
Mon Feb 24 11:15:00 CST 2003
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. Charlotte Foust -----Original Message----- From: Gustav Brock [mailto:gustav at cactus.dk] Sent: Monday, February 24, 2003 9:03 AM To: John Skolits Subject: Re: [AccessD] ACCESS 2000 Run Time and Office XP - Can't print *MORE INFO* 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. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com