CAll the Report Wizard (2K XP)

Topic

New Reply

Is there a runcommand to call the report wizard using a specfic query as the basis for it.
thanks

Reply | Quote

Replies

I don’t know the answer for Access XP, but maybe somebody knows how to adapt the following.

In Access 97, the report wizard is stored in Wzmain80.mde.
To call the report wizard in code, you can use

Run "wzmain80.frui_Entry", "QueryName", acReport

where QueryName is the name of an existing query.

If you set a reference to Wzmain80.mde, you can use

wzmain80.frui_Entry "QueryName", acReport

instead.

I don’t know whether XP works the same way. At the least, the file name will be different (probably Wzmain90 for Access 2000, but for XP ?)

Reply | Quote

it looks like its name acwzmain.mde. I set a reference but the part you called does not exist and there are about 400 possibilities and I could not figure out which one it is.
If anyone knows, Help!
Thanks
Zave

Reply | Quote

I have to point out that even if you make this work, you can’t distribute a wizard with an application, so it will break on a target machine if their installation doesn’t include the wizards.

Reply | Quote

It is for a specific person who cannot figure out (!) how to choose which query to base the wizard on. They have a full install of Access.
thanks for the reminder though.

Reply | Quote