How to open the Report Wizard using code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to open the Report Wizard using code ? I know that

DoCmd.RunCommand acCmdNewObjectRepor

is the command to open the New Report Window, but I can't figure out how to code it to go directly to the Report Wizard

Any ideas?
 
Hi,

Not sure I can help too much, but this may get you going:

' Access 2000 Code
Application.Run "Acwzmain.frui_entry", "qryVendorList", acReport

' Access 97 Code
Application.Run "wzmain80.frui_entry", "qryVendorList", acReport

Now using this code I had to pass in the name of a saved query.
I'm sure you could do the same for a table name.
I have not tried any other methods.
I do not have Access 2002 or 2003 to see if this code is valid for those
versions.

Hope that helps,
Jeff Conrad
Bend, Oregon

lab said:
Does anyone know how to open the Report Wizard using code ? I know that

DoCmd.RunCommand acCmdNewObjectReport

is the command to open the New Report Window, but I can't figure out how
Click to expand...
to code it to go directly to the Report Wizard.
 
Back
Top