Changing a Macro into VBA

[Lou_Reed]

I am using MS Access 2010 I am programming the VBA aspect of the MS Access software. This database that I have
has several embedded macros that I would like to convert to VBA.



I have not been able to do that. I am unable to bring up the

Convert Form's Macro to VBA.

The button is not easily found. I just cannot seem to locate this.

Where is it and how do I convert an Embedded Macro to VBA.

Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

[ranman256]

usually all commands in vba are docmd.XXXX
docmd.openquery
docmd.transferspreadsheet
...

[Lou_Reed]

I am using the following link as my instruction guide. The link is: http://www.iaccessworld.com/how-to-c...ro-to-vb-code/.

When it gets to

Step 2 Under the form design view, click on the "Convert Form's Macro to Visual Basic".


I am not finding the radio button to do that. I am lost here.

Where is this button?


Respectfully,

Lou Reed

[Lou_Reed]

Okay, I got it. No need to answerer this question. I have my answer.

I do have one additional question and that is : is the embedded macro code lost forever.

Any help appreciated.

Thanks in advance.


Respectfully,


Lou Reed