Open report from VBA, without printing

[Piedone]

Hi!

I have experienced a a really odd problem when writing an Access application. I would programatically open a report (because i need to pass a value to it) with DoCmd.OpenReport. I would like to open it for viewing, not in print preview (as there the recordsource couldn't be modified anymore), like when you open it from the command bar with the button "Report View".
The odd thing is, that apparently there's no way to simply view the report without immediately printing it :-). I tried the code
DoCmd.OpenReport "ReportName", acViewReport, , , acWindowNormal, "value_to_pass"
with every view mode. As i know with acViewReport it has to display the report instead of printing it... Is this some bug or i am missing something?:

[nico5038]

Use the Preview like:

DoCmd.OpenReport "ReportName", acViewPreview, , , , "OpenArgs"

Nic;o)

[Piedone]

Use the Preview like:

DoCmd.OpenReport "ReportName", acViewPreview, , , , "OpenArgs"

Nic;o)

Thanks, that would do it, but as i have written, unfortunately it's not possible to modfiy the recordsource prooperty in print preview, so it's not possible either to make a report with a customized query.
I made a new try and have explored that with an open argument (even with an empty one) Access 2007 doesn't print. That's OK, but Access 2003 still does...

[nico5038]

When I want a "dynamic" recordset I just manipulate the query before activating the report.
In general however using a filter gives enough flexibility, but incase you really need the query to change use this code before the Docmd.OpenReport:

Dim qd as DAO.Querydef
 
set qd = currentdb.querydefs("qryRptYours")
qd.SQL = "select x from tblY where x =" & Me.X
 

Getting the idea ?

Nic;o)

[ADezii]

Thanks, that would do it, but as i have written, unfortunately it's not possible to modfiy the recordsource prooperty in print preview, so it's not possible either to make a report with a customized query.
I made a new try and have explored that with an open argument (even with an empty one) Access 2007 doesn't print. That's OK, but Access 2003 still does...

If you wish to make any modifications to a Report prior to actually Opening/Previewing it, open the Report Hidden first, make your changes, then Re-Open in the proper Mode.

DoCmd.OpenReport "rptEmployee", acViewNormal, , , acHidden

[Piedone]

Thanks a lot to both of you, it works!