PC Review


Reply
Thread Tools Rate Thread

Assigne Macros to a Single Command Button

 
 
Mohammad Sibtain Arain
Guest
Posts: n/a
 
      20th Mar 2010
How can i run a macro by using a button and how can i change the macro on
runtime
--
Regards

M.S.Arain
 
Reply With Quote
 
 
 
 
ryguy7272
Guest
Posts: n/a
 
      20th Mar 2010
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...ng-With-Macros

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



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Mohammad Sibtain Arain" wrote:

> How can i run a macro by using a button and how can i change the macro on
> runtime
> --
> Regards
>
> M.S.Arain

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command button - Trigger one of Two Macros =?Utf-8?B?VmlubnkgUA==?= Microsoft Access Form Coding 1 11th May 2007 08:43 PM
Re: Single Action Command Button Douglas J. Steele Microsoft Access 0 1st Dec 2006 03:10 PM
Two Macros under One command button =?Utf-8?B?Um9ueQ==?= Microsoft Excel Misc 1 11th Mar 2006 12:11 PM
command button and macros =?Utf-8?B?QnJpYW4=?= Microsoft Excel Worksheet Functions 4 13th Oct 2004 11:39 PM
Command Button Macros ExcelMan Microsoft Access Form Coding 1 13th Sep 2004 04:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:56 PM.