Programatically access the label making wizard

message from Andy Levy on 26 May 2004
Hi

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

Thanks

AL
 
Jeff Conrad replied to Andy Levy on 26 May 2004
Do you want to launch the Label Wizard from a command button on a form?

' 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.
 
Mike Painter replied to Andy Levy on 26 May 2004
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.
 

Archived message: Programatically access the label making wizard (MS Access Error Message)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.