-
Add Macro to QAT
Hi Experts,
A real novice with Access and Access VBA. However, I've poked my toe in the pond and have managed to create a project that is working well. I have a standard module with the following procedure that when run from the VBE displays the named form. I would like to add this "Macro" to the QAT. However, when I look at the QAT Editor and select choose commands from "Macros" my macro doesn't appear. How would I add this macro to the QAT?
Public Sub ShowForm()
DoCmd.OpenForm "Select Applicant"
End Sub
-
Sorry, I am not familiar with the term QAT.
You do not have a "Macro", you have VBA code which is contained in the VBA Editor.
To open the editor click alt + F11.
-
QAT is "Quick Access Toolbar"
I know how to open the VB Editor. In the other Office applications (well Word and Excel). VBA code (or procedures) are considered "Macros" for the purpose of customizing the QAT:
-
You have to be careful with Access as it has Macros and VBA and they are not the same thing.
Unfortunately I do not know how to add Access VBA to a QAT, it is normal for it to be applied to an Access object on a form or report or called from a Module.
-
Greg, I forgot to ask you, why do you want to add the VBA code the QAT?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules