<div>
I was just creating the buttons using the wizard. The event for &quot;on click&quot; 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. <br />
Deleting and recreating has worked. Thanks for helping me out on this one. <br />
Craig
</div>


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.
Craig

<div>
OK, then you can accept your own answer here.<br />
;-)
</div>


OK, then you can accept your own answer here.
;-)

<div>
<div class="content wysiwyg-content">
Hi There,<br />
<br />
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.<br />
<br />
&nbsp;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.<br />
<br />
How might I look at the embedded macro so I can edit it ?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/08_w33/865538/C--Users-edwcws-Documents-Snagit-11-08-2" target="_blank" title="Click on the ellipsis here (37 KB)"><img alt="Click on the ellipsis here" class="file-block lazyload" style="max-width: 719px;" data-src="https://filedb.experts-exchange.com/incoming/2014/08_w33/865538/C--Users-edwcws-Documents-Snagit-11-08-2" /></a><br />
<a href="https://filedb.experts-exchange.com/incoming/2014/08_w33/865539/C--Users-edwcws-Documents-Snagit-11-08-2" target="_blank" title="Get blank vba proecdure (17 KB)"><img alt="Get blank vba proecdure" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/08_w33/800_865539/C--Users-edwcws-Documents-Snagit-11-08-2" /></a><br />
<br />
Any help is appreciated.<br />
<br />
Best regards,<br />
Craig
</div>
</div>


C--Users-edwcws-Documents-Snagit-11-08-2

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 ?






Any help is appreciated.

Best regards,
Craig

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.