Thursday, October 31, 2013

Creating Form For Macro In Microsoft Access





1) Creating A Form
2) Adding a Command Button to the form
3) Manually set the properties for Command Button
5) Adding an Event Listener to the Command Button
6) Running the Form

1) Creating A Form

1.1) Click Create Tab.
Click Form Design button.
1.2) Outcome:

2) Adding a Command Button to the form

2.1) Click Design Tab.
Click the Command Button.
2.2) Click and drag the mouse on the Form Detail Section to make a box shape for the button.
2.3) The Command Button Wizard window automatically pops up.
Click Cancel.
2.4) Outcome:
The button is given a default name Command0.

3) Manually set the properties for Command Button

3.1) Right-hand click the Command0 button.
3.2) In the Property Sheet type “Hello World!” in the Caption field.
Close the Property Sheet window.
3.3) Outcome:
4) Running the Form
4.1) Click the Form View button.
4.2) Outcome:

5) Adding an Event Listener to the Command Button

5.1) Click the Event Tab.
In the On Click field, find the name “mcrHelloWorld”.

6) Running the Form

6.1) Click the Form View button.
6.2) Outcome:

No comments:

Post a Comment