Run the built-in Report Wizard

  • Thread starter Thread starter EricB
  • Start date Start date
E

EricB

Does anyone knows whether there is a way to run the
access report wizard from code? many thanks in advance
for any help or suggestions!!!!

Eric.
 
Use the ACWZTool. This should show in your code window and the syntax for
Access 2000 or 2002 will be something like:

Application.run "acwztool.frui_entry", "Name of your Table Or Query", acReport

You can use similar syntax to run most of the Wizards.

Hope this helps.
 
I tried running acwztool.frui_entry but I get a run-time
error 2517, can't find the procedure.
This doesn't seem to work.

Thanks.
 
Make sure you see a collection of ACWZMAIN objects in your VBA project
explorer window.
If you don't see it and haven't done so already, try running any wizard and
see if ACWZMAIN displays.
I've only ever used this in Access 2000, so if you're using a newer version,
they may have changed the Syntax.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't create a report from my query in Access 1
Reports in Access 1
Strange error when building report. 5
Access 2007 vba code to launch label wizard 8
Using a Parameter Query in a Report? 2
Can't run report wizard from code 1
Object Dependency Tracking 3
Running reports in Access 2007 1

Back
Top