A Andy Levy May 26, 2004 #1 Hi Is it possible to programatically access Access's label making wizard ? Thanks AL
M Mike Painter May 26, 2004 #2 Andy Levy said: Hi Is it possible to programatically access Access's label making wizard ? Click to expand... 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.
Andy Levy said: Hi Is it possible to programatically access Access's label making wizard ? Click to expand... 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.
J Jeff Conrad May 26, 2004 #3 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.
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.
