How do I add a link to a macro to the Quick Access Toolbar

Question

I am trying to add a button to run a macro in Access 2007 to my Quick Access Toolbar (QAT).

In Excel 2007, I have never had an issue. In the Customize Quick Access Toolbar window I can select Macros from Choose Commands From and then all my non-private macros are listed. I can add them to my ribbon.

However, in Access 2007 nothing shows up in this list of Macros. I feel like there is something in the fundamentals of Access and Macros I am missing but not sure what ...

Thanks for your help.

Adding module example saved as TestModule (see screenshots as well). I still feel I am missing something very simple here ... sigh

Option Compare Database
Option Explicit
Public Sub HelloWorld()
    MsgBox "Hello world!"
End Sub

Answer 1

In Access the macro's are per-database (and per-user), and what that list is showing you is the all the macro's in the currently opened DB.

So if you setup a Macro for a database, and then close it, the macro is not available in the list anymore.