Label Wizard

[HServ]

How can I link directly to the label wizard from the switchboard so users
can select their own layout? Thanks

 

[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.

If you are using the built-in Switchboard Manager post back
and I'll help you set up the requirements.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[HServ]

Thank you Jeff! That was much easier than I expected..
I am using a command button on a form so I put that code into the macro I
was already using and it worked like a charm!

 

[Jeff Conrad]

in message:

Thank you Jeff! That was much easier than I expected..
I am using a command button on a form so I put that code into the macro I
was already using and it worked like a charm!

Excellent, glad to help.