Share via

Cannot edit macro in access database 2016

Anonymous
2019-01-23T00:13:42+00:00

I have an old access database that was originally created with office 2007. We just moved to office 2016 (Office 365). I can open the access database and run it, however I need to make some changes to it. One of these changes is editing a macro the runs when you click the run button on the switchboard. There seems to be no way to view the macro much less edit it unlike in earlier versions of MS Access where it was pretty straightforward.

How do I edit it? I see that F11 still works to get around the switchboard, but when I explore the categories, I can see the "Macro1" listed in the macros, but all I can do from there is run it by clicking it. How do I open/view the macro for editing?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2019-01-23T02:22:49+00:00

    Is this an accdb?

    If you hit Ctrl+F11, do you get the VBA editor?

    Right-click the macro so the context menu shows. Post a screenshot.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments