Linking a Module to a Macro in Access

JoeRooney

Board Regular
Joined
Nov 27, 2017
Messages
102
Hi,

I am new to access and I would like to find out how to linka module to a macro so I don’t have the run the module through VB.

The module is working fine but I can’t figure out how tolink this to either


  1. A macro so I can run it from the Database tools tab
  2. Assign it to a button on a form.

Any help on this is greatly appreciated.

Thanks,


 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,478
Add a button onto a form, then look at the properties of the button and use the Event On Click use the ellipsee button and select VBA, then use Call and the subroutine name from the module sheet and save close the VBA screen down change the view of the form and you should beable to run the code from the button.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,122
Messages
5,466,814
Members
406,500
Latest member
Tknotmaxx

This Week's Hot Topics

Top