Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post

    Access macros: O where art thou AutoExec?

    First let me admit that the last time I did anything serious with Access was when version 2003 was the current version out there. And so when it comes to the new interface in 2007 I am a little lost. My problem is finding and dealing with Macros. I can create a Macro in Access but I can't find it after words. I thought at first I was accidentally creating an embeeded macro, something I read about on the "HOW TO MACRO" page at Microsoft's office tips site. The problem is that even if I create a macro and don't specify its embedded it still seems to disappear.

    What I've Tried So Far:

    1) Open an existing Access db (file type = .accdb ) and after the main form loads I close it so that nothing is showing in the main area of the Access GUI.
    2) I go to the "Create" tab and then the "Other" group on that tab and I select MACRO and then CREATE.
    3) After selecting RunCode and selecting a function in a module in the DB file I then click SAVE and assign it the name AutoExec.
    4) I use AutoExec because I want this macro to run when the thing is opened in Access.

    After the above I can see on the left side of the Access GUI an icon for the new Macro and it shows the name AUtoExec. Everything appears fine till I do anything that resorts or re-shuffles the various Access Objects shown on the left side of the screen. This is when all the Macros disappear and I can no longer find them again.

    If I close Access and reload the accdb file I get the "STOP ALL MACROS" popup and if I stop them I can once again see the macros on the left side of the Access GUI and so long as I donít change how the Access Objects are shown on the left side I can see the Macros. That said I canít believe that this is how you have to always edit a Macro even ones not named AutoExec.

    What gives?

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    In the navigation pane, at the left, you have a sort of dropdown, where you can choose what type of object you want displayed there. You can have tables, macros, forms, queries, etc. One of the options is All Objects. So to see what macros you have, choose either macros or All Objects.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thanks, that did it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •