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?
