Generated Access reports

[hafiff]

Hi everyone,

I have created many reports in the past using button that I created. All the reports that were generated by the macro button is showing in front of other open windows (forms, query, etc.). This time when I created a new database, the reports I created display on a tab - not popping out.

Also, how do you create a macro script after the report is popping out, there will be printer dialog to appear so the user just simply click the print all or by pages later?

I am sure that it is an easy fix, but I just could not figure out at this time so your help is greatly appreciated.

Thanks,
HA

 

[ranman256]

what do you mean ...'popping out'?
do you mean printing to the printer?
Is this what you want instead of the report going to 'print preview' to a tab?

if so, the command is
'TO PRINTER
docmd.openreport "rMyReport"

'FOR PRINT PREVIEW
docmd.openreport "rMyReport",acViewPreview

 

[hafiff]

Thanks for the quick reply. Popping out means that it will not be going to 'print preview' to a tab.
Also, can I have the macro version of the vba code below please?
FOR PRINT PREVIEW
docmd.openreport "rMyReport",acViewPreview

Thanks!