Can't edit embedded macro - command button in Access 2010

Posted on 2014-08-10
Last Modified: 2014-08-16
Hi There,

I have created some command buttons on a form in Access 2010, and when I tried to look at the procedures created by the button wizard, lo and behold, there was none. I have now figured out it has created embedded macros, which for the very simple tasks I'm carrying out is ok.

 But when I click on the ellipsis button to edit the [Event Procedure], it just opens the VBA editor with a blank procedure - very confusing. To change the functionality of the button I have to delete the words [Event Procedure] then create a new embedded macro, or key in some code - or - delete the button and create a new one.

How might I look at the embedded macro so I can edit it ?

Click on the ellipsis here
Get blank vba proecdure

Any help is appreciated.

Best regards,
Question by:slobber72
    LVL 74

    Accepted Solution

    It is not clear how you are creating your buttons, ...
    ...or what your buttons are doing...

    But if you are using the .accdb format, and you create your button using the wizard, ...
    Then when you open the property box, will say :
        [Embedded Macro]
    ...Not [Event Procedure]

    So it looks to me like you are just dropping buttons on your forms.
    When you drop a button on your form, a wizard should start up asking you what you want your button to do...
    If you follow all the steps, will have a button with an [Embedded Macro]

    If you drop a button on your form and the wizard does not open, then you will have to click the "Control wizards" button.
    Then try creating the button again.


    Give that a try, then let us know

    Author Comment

    I was just creating the buttons using the wizard. The event for "on click" it did only say [event procedure] that's why I was expecting to see vba code-but there was none. And I couldn't see / get to any macros. The button was working correctly but I couldn't edit it's actions.
    Deleting and recreating has worked. Thanks for helping me out on this one.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    OK, then you can accept your own answer here.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now