Assigne Macros to a Single Command Button

  • Thread starter Mohammad Sibtain Arain
  • Start date
M

Mohammad Sibtain Arain

How can i run a macro by using a button and how can i change the macro on
runtime
 
R

ryguy7272

Create a command button running a Macro
1. Open a form in Design view.
2. CClick the Control Wizards tooDesign→Use Control Wizardsl on the
Ribbon in the toolbox if it's pressed in. This turns off the wizard.
3. In the toolboxcontrols toolbox, click the Command Button tool .
4. On the form, click where you want to place the command button.
5. Make sure the command button is selected, and then click Properties Sheet
on the toolbar Ribbon to open its property sheet.
6. In the OnClick property box, enter the name of the macro or event
procedure that you want to run when the button is clicked, or click the Build
button to use the Macro Builder or Code Builder.
7. If you want to display text on the command button, type the text in the
Caption property box. If you don't want text on the button, you can use a
picture instead.

Also:
http://www.scribd.com/doc/3948608/MS-Access-Working-With-Macros

This is good too:
http://www.learnaccessnow.com/chap18d.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top