How to open the wizard reports with vba

[BigBud]

Hi,

I have a button on my form that has to open the wizard from access itself to make reports.

I have the following code but it gives me a type mismatch error:

Private Sub cmdRapportMaken_Click()

Application.Run "acwztool.frui_entry", "tblFamilie&Kennissen", "acReport"

End Sub

Can someone please give me the solution or another way to invoke the wizard reports with vba...

 

[BigBud]

I found the above code on this site:

http://www.mvps.org/access/general/gen0028.htm

I almost copied it exactly but it gives me this error(type mismatch)

Pls help

Thx...

 

[TonyJollans]

Hi BigBud,

I don't know if it's the whole solution, but acReport is an Access constant and by putting it in quotes you are making it a string - hence the type mismatch. try it without the quotes.

Enjoy,
Tony

 

[BigBud]

Tony,

Thanks for this wonderfull solution. It did fix my type mismatch error!

Now I get a dialog box that says: "The form name 'frui_frmMain' is misspelled or refers to a form that doesn't exist."

Strange...Someone ?

 

[TonyJollans]

BigBud,

I have Access 97 but the 97 version from your link works fine for me. Maybe you are missing some References (Tools > References in the Module Editor). May need a bit of trial and error.

Enjoy,
Tony

 

[BigBud]

I'll check it out.

Thx...

 

[BigBud]

Seems that there are to many references to check...I'm in trouble...

 

[BigBud]

I have the solution!

The site I mentioned earlier made a mistake. It had to be:
Application.Run "acwzmain.frui_entry", "tblFamilie&Kennissen", acReport

acwztool must become acwzmain

Thx for the help everybody...

BigBud