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

John Skolits JSkolits at CorporateDataDesign.com
Mon Feb 24 10:51:14 CST 2003


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.


-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Monday, February 24, 2003 11:32 AM
To: John Skolits
Subject: Re: [AccessD] ACCESS 2000 Run Time and Office XP - Can't print
*MORE INFO*


Hi John

How can you select the report when it has not been opened?

/gustav


> 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.

> Still looking..

> John


> -----Original Message-----
> From: accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com]On Behalf Of John Skolits
> Sent: Monday, February 24, 2003 9:46 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] ACCESS 2000 Run Time and Office XP - Can't print


> (Ooops! Posted this to SQL_Server by mistake)

> 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




More information about the AccessD mailing list