acHidden withe report

[tania20]

Hi, Does anyone have any idea how to implement the same functionality as acHidden in access 2000 on OpenReport?. I have tried visible but this occurs after opening the report so I get screen flash effect-I need to prevent the screen from even appearing.

Cheers

Tania

 

[BuilderSpec]

Hi Tania

Can you not implement :

DoCmd.OpenReport "ReportName", acViewPreview, , , acHidden



Hope this helps!

Regards

BuilderSpec

 

[tania20]

Thats what I was trying but it does not allow the WindowMode agrument as it is only Access 2000 - only allows for OpenForm...

 

[BuilderSpec]

Let's see if their is a different way..

Why do you want to open the report hidden ?

Hope this helps!

Regards

BuilderSpec

 

[tania20]

When I open my custom switchboard form there is code on the load event that cycles through all the reports to set the page size to A4 - but this code requires the reports to be opened and closed. This works fine but creates a flashing effect as the reports are opened and closed.

 

[tania20]

Yay, I've solved the problem-thought I would post the solution for anyone else who may need it:

DoCmd.Echo False
DoCmd.OpenReport rptName, acViewDesign
Reports(rptName).Painting = False
Set rpt = Reports(rptName)

...other code here

DoCmd.Close acReport, rptName, acSaveYes
DoCmd.Echo True

Tania

 

[BuilderSpec]

Yay

Never even seen the echo command before..very useful !

Hope this helps!

Regards

BuilderSpec