Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Assign a a macro to button on user from

Posted on 2013-11-21
2
Medium Priority
?
495 Views
Last Modified: 2013-11-22
Hi Experts

I have a userform with a command button in ms access 2003 and I would like the button to call/run my macro Private Sub cmdMyButton_Click

how would I do this....what are the steps...
0
Comment
Question by:route217
2 Comments
 
LVL 9

Accepted Solution

by:
QuinnDex earned 2000 total points
ID: 39668233
Open a form or a data access page in Design view.

Make sure the Control Wizards Button image tool in the toolbox is not pressed in. This turns off the wizard.

 In the toolbox, click the Command Button tool Control.

On the form or data access page, click where you want to place the command button.

Make sure that the command button is selected, and then click Properties Button image on the toolbar to open the command button's property sheet.

In the OnClick property box on a form, 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. On a data access page, you can attach code written in either JScript or Microsoft Visual Basic Scripting Edition (VBScript) to a command button by using the Microsoft Script Editor.

Do one of the following:

To display text on a command button on a data access page: Type the text in command button's Value property box.

To display text on a command button on a form: Type the text in the command button's Caption property box.

To display a picture on a command button on a form: In the command button's Picture property box, type the path and file name for a .bmp, .ico, or .dib file. If you're not sure of the path or file name, click the Build button Button image to open the Picture Builder.
0
 

Author Comment

by:route217
ID: 39668351
Thanks for the feedback. ...excellent
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question