SOLVED! In Access 2010, Convert Macros to Visual Basic is Grayed Out

[Wayne]

I was trying to convert a macro to VBA in Access 2010 by opening the
form in Design Mode, then clicked on the Embedded Macro source, which
brought up the Macro Design window but the "Convert Macros to Visual
Basic" was always grayed out.

The solution I found was, rather than loading the form in Design View,
I clicked the Macro button under Create on the Ribbon which brought up
the Macro Design window. Under the Action Catalog window, there is a
section called "In this Database." I clicked down to the form and
textbox which contained the macro I wanted to convert, then double-
clicked. The macro displayed in the left hand window and the "Convert
Macro's to Visual Basic", was not grayed out so I clicked it and the
conversion was simple after that. Thought I'd pass this along to
others who may have had this frustration.

 

[truepyr]

Thanks!

Thank you so much for sharing! That is one of those things that you know it can be done, but there is only a certain set of circumstances to make it happen.

 

[midwestbob]

Thanks

Thanks for sharing. It's simple when someone holds your hand once through.

 

[mev]

Thank you. This is exactly what I was looking for!

 

[saeidy]

Thanks a lot for this you saved lots of time to me

 

[justapixel]

Big MERCI

Thanks so much for your post, just saved me a lot of work

 

[Fred Martino]

I am not able to convert any of the macros from the contacts sample database I just keep getting an out of memory message.

 

[Zaher]

Thank you for the time and effort made for sharing.