XP Report open bug?

[danvlas]

Hi everyone.

I have the following code:

strReportName = rptActiveReport.Name
DoCmd.OpenReport strReportName, acViewNormal

rptActiveReport is a Report variable that refers to an open report

The code is supposed to print the report and it does. However, after printing the report opens in Design view.
Tried the same code in Access 2003 and 2007 and it works great.
Anyone knows a fix for it? (I found a workaround, but I don't like it, so I won't post it).

Thank you in advance,




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Remou]

I have heard stories of 'invisible' break-points left over from earlier testing ...

 

[danvlas]

Thanks for the reply.
Unfortunately, it's not the case.
Tried decompile, importing all objects in a new file, compact, repair, everything I could think of.
And it works so well in all other versions.

The funnyiest thing is that it opens in Design View even in an mde file

It's not a bug, it's an undocumented feature...

The solution I found is against all principles, but there was nothing better I could find:

strReportName = rptActiveReport.Name
Echo False
DoCmd.Close acReport, strReportName
DoCmd.OpenReport strReportName, acViewNormal
DoCmd.OpenReport strReportName, acViewPreview
Echo True

Of course if user scrolls to page 20 of the report he will see the first page after printing, but that's it...




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Crowley16]

can you post more than just that snippet of code?

I suspect what you are doing is declaring an report object, then setting a report to the report object, and then opening that object and printing the report...

you could try to loop through either the screen collection or the allreports collection and detect which reports to be active, and then use the docmd.openreport "reportName" directly, without having to go through an object...

--------------------
Procrastinate Now!

 

[danvlas]

Well, thanks for the intention, but there is nothing one can do about the variable.
The application has a touch screen pad that has a 'Print' button. There may be several reports displayed, user just activates one and then touches 'Print'.
To print that report, the button should know its name and that is taken from the variable (which is set in the Activate event of each report)
Therefore, the simple instruction that I first posted is supposed to send the report to the print
er, and it does.
What is stumping is that after printing, the report stays on the screen IN DESIGN VIEW, even in an mde file.
And this happens only in Access XP.
Hope it's clearer now...


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Crowley16]

well, how's about putting a close clause after the printing of the report?

if reports("reportName").isloaded then
docmd.close acreport, "reportName", acsaveno
end if

or something like that...

--------------------
Procrastinate Now!

 

[danvlas]

Then I end up with what I figured ou, because the user wants the report to stay on the screen, so I open it again...


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[markphsd]

Can the report be designed in the design mode? This might open up a world of possibilities for MDE's.


Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[danvlas]

Well, you can:

- change the properties of existing controls
- remove controls
- change the properties of the report and its sections (record source, colours)

You cannot:
- add new controls
- view/change code (Project is unviewable)

Anyway, this is only possible in Access XP and only by opening the report once in Preview mode and then, without closing it, open it again in Normal mode to send it to the printer.

DoCmd.OpenReport "R_In", acViewPreview
DoCmd.OpenReport "R_In", acViewNormal

The 'Design' menu is unavailable.

Haven't found the answer yet...still searching.




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html