Create a Macro Library or Macro Include File - Open the Current Form's VBA Module from the Quick Access Toolbar in Microsoft Access


	Back to Open Form Module Comments List

Create a Macro Library or Macro Include File

Constance Britten

18 days ago

Is there some way to create either a library of macros or else some kind of macro include file?

I was able to create a library containing the Open Form module and then add a reference to that library to the D62.02 database, but I also had to create a macro in the D62.02 database to call it.

I tried simply adding the macro to the library file that contained the Open Form module but the D62.02 database didn't pick it up.

	Richard Rost @Reply 18 days ago
Yes, it's possible. You can put the code in your library file, but you can't call a macro in the library directly. You need to wrap the macro's action inside a public Function in the library, then create the small RunCode macro in each front-end database to call that function. I spent all of Developer 63 and 64 covering library files and how to use them properly.

Constance Britten OP @Reply

18 days ago

Richard Thank you so much for your reply!

While we students are taking your courses we're working with a lot of databases, so I was trying to see if I could eliminate a "hazard to navigation" during the process of implementing this handy quick access toolbar button. That is, after IntelliSense didn't pick up the function name while I was creating the small RunCode macro in the D62.02 database, I was trying to avoid repeatedly tripping over my bad memory going forward.

Ah well, I'm sure I'll have "OpenCurrentFormModule()" memorized eventually. ;-)

Next Unseen