H
HServ
How can I link directly to the label wizard from the switchboard so users
can select their own layout? Thanks
can select their own layout? Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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:
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:
H
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!
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!
J
Jeff Conrad
in message:
Excellent, glad to help.
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.