Programatically access the label making wizard

[Andy Levy]

Hi

Is it possible to programatically access Access's label making wizard ?

Thanks

AL

 

[Mike Painter]

Hi

Is it possible to programatically access Access's label making wizard ?

Do you mean pop it up as a user option?
If so, I don't know.
If you mean use it, then all the functions to roll your own report (which is
what a label is) are exposed in VBA.

 

[Jeff Conrad]

Do you want to launch the Label Wizard from a command button on a form?

If so, use this code:

' Access 97 Code
Application.Run "wzmain80.mlbl_Entry", "TableOrSavedQueryNameHere"

' Access 2000/2002/2003 Code
Application.Run "acwzmain.mlbl_Entry", "TableOrSavedQueryNameHere"

You have to pass in the name of a saved query or table name.