How to edit a Macro? (1 Viewer)

Tina49

Registered User.
Local time
Yesterday, 22:44
Joined
Sep 29, 2011
Messages
34
I created two data macros in Access 2013. I created these Macros by having my table open and then I went to the ribbon and selected Table. I then used the AfterInsert. The first Macro was an AfterInsert Macro, and the second was an AfterUpdate Marco. I closed out of them and thought I could simply go back into the Macro to edit a field; however, I don't where I can edit them. When I go to Named Macro, the edit Macro is grayed out.
 
Last edited:

deanamiles86

New member
Local time
Today, 06:44
Joined
Sep 12, 2013
Messages
8
Sorry Im a bit lost with where you are, dont you just reopen the table and click AfterInsert again to edit the macro?
 

Tina49

Registered User.
Local time
Yesterday, 22:44
Joined
Sep 29, 2011
Messages
34
No, a new data macro appears, not the old one.
 

James Deckert

Continuing to Learn
Local time
Today, 00:44
Joined
Oct 6, 2005
Messages
189
When clicking the table button on the ribbon, are the After Insert and After Update buttons shaded showing that there is already a macro there?
After clicking the After Insert button, are you sure your macro is not just closed?
There're boxes to the left which will close/open a branch of code.
 

Tina49

Registered User.
Local time
Yesterday, 22:44
Joined
Sep 29, 2011
Messages
34
Sorry to all. Had the wrong table opened at the time.
 

Users who are viewing this thread

Top Bottom