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

Found this in another newsgroup archive.

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.

John Skolits
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com