[AccessD] Report Preview Question

Are you saying on the click event of the button that opens
the report?

Joe Hecht
jmhecht at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Heenan, Lambert
Sent: Thursday, February 02, 2006 2:03 PM
To: 'Access Developers discussion and problem solving'
Cc: 'Joe Hecht'
Subject: Re: [AccessD] Report Preview Question

Sorry, I was none too clear.

You make the call after the report is previewed, from the
code routine that
opened the report, not from within the report's module.
So...

    DoCmd.OpenReport "SomeReport", acViewPreview
    DoCmd.SelectObject acReport, "SomeReport"
    DoCmd.RunCommand acCmdZoom100

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Joe Hecht
Sent: Thursday, February 02, 2006 4:46 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Report Preview Question


Lambert

I tried your code on the open, activate and page header
events. I got an error saying you can not use select object
while it is
printing.

Any Ideas?

Thanks


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Heenan, Lambert
Sent: Thursday, February 02, 2006 12:51 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Report Preview Question

This will do it...
   After opening the report in preview mode...

    DoCmd.SelectObject acReport, "Some Report Name"
    DoCmd.RunCommand acCmdZoom100

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Joe Hecht
Sent: Thursday, February 02, 2006 3:38 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Report Preview Question


I have reports that I  have code to maximize on opening.

 

Does anyone know the code to set the preview size
automatically to 100%

 

Thanks

 

Joe Hecht

jmhecht at earthlink.net

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com