Consulting

Results 1 to 5 of 5

Thread: Add Macro to QAT

  1. #1
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,334
    Location

    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
    Greg

    Visit my website: http://gregmaxey.com

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    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.

  3. #3
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,334
    Location
    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:

    Greg

    Visit my website: http://gregmaxey.com

  4. #4
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    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.

  5. #5
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    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
  •