[AccessD] ACCESS 2000 Run Time and Office XP - Can't print *MORE INFO*

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.




More information about the AccessD mailing list