Printing a report

[Amateur]

Dear Sirs
I have a form with a command button which should preview a report from
another database.
I use the following code:
**************
Private Sub Imprimircomsiones_Click()
DoCmd.OpenReport "c:\cps208\sales\salespersonalcommission",
acViewPreview, "", "", acDialog

End Sub
**************
Can someone tell me where my mistake is laying?
Thanks
Klaus

 

[Wayne-I-M]

Hi

Have a look at this answer I gave a while ago - change the macro from
opening a form to opening the report - there is not much difference in the
shell call


http://groups.google.com/group/micr...roup:microsoft.public.access#2c74f466a27b250d

 

[Amateur]

Hi Wayne

I have the following cde for my button:
*******************
Private Sub preview_Click()
Call Shell("""C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE""
""C:\cps208\sales.mdb""/Xpreviewcommission ", 1)
End Sub
********************
I created a Macro in the "sales.mdb" - Echo, setwarnings,OpenReport,Quit.
OpenReport I put in Preview mode.
If I push my command button the Db "sales" comes up - is doing nothing - and
close again.
What am I doing wrong? I just would like to see a preview from the report
before printing.

Thanks
Klaus