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

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.




More information about the AccessD mailing list