Running a module from a Form

[uk]

ok ok!!

I have created a Module, and I have created a Form.

I want to RUN the module by clicking a button on the FORM, how do I do this?

Help, Thanks!

 

[anvil19]

Hey uk

I'm assuming that you wish to run a macro, not a module. If so then do this...

1) RightClick the button and select "View Code". A CommandButton<Number>_Click event will be added to the forms code window.
2) Add the name of the macro into the event.
3) Run the form and click the button. The macro will run.

An event is a sub routine that responds to a user action like clicking a button or pressing a keyboard key etc, or a system action like a change of data in a sheet or the updating of a value in a control.

I Hope that helps.

anvil19

 

[uk]

no not a macro, a module!

Thanks

 

[anvil19]

Me again

A module is just a container for your macros that are not events routines (which are related to a form or sheet in Excels' case) and are also available to the entire project. If you wish to run all the macros in a module you would spacify each by name.

anvil19

 

[mdmilner]

Shouldn't you substitute the word 'Function' for 'Macro'?
Modification of Anvil19's post.

In Access2K - right click the button (Form View is fine) - select Properties
Go to the Event Tab
Click into the Row labeled 'On Click' and hit the three dots off to the right

To call specific Functions in the module you wrote:

Call functionname()

Add arguments within the () if needed for the function.
Identical Syntax for Subroutines

Mike

 

[uk]

How would you add a Message box to show once the Module/Macro has finished?

 

[Joe4]

At the end of the last macro to run, simply add the line:

MsgBox "The macros are finished running!"