I am trying to open an access 2002 report named Station Log in a VB6 program. I would like to preview it within access and then be able to print it from access. I am NOT interested in using a data report, I have tried it and dont like it. The access report is much easier to format and program.
The code I am currently using works fine in that it will print the report, but it will not preview it for me first. I really do not understand what part of this code is causing it to print either, but it does print.
Private Sub cmdTurnover_Click()
Dim acc As New Access.Application
acc.DoCmd.OpenReport Reportname:="Station Log",