convert macro to VBA

[azhar2006]

Hi guys
I made a macro button for search. When I want to convert it to VBA language, I see that the conversion command is not activated. What is the reason?
Thank you

 

[June7]

Because it is not a stand-alone macro, it is embedded macro. Use "Convert form's macros to VBA" option in Tools group on Form Design tab.

 

[azhar2006]

Because it is not a stand-alone macro, it is embedded macro. Use "Convert form's macros to VBA" option in Tools group on Form Design tab.

I used the Convert Form Macros option on the Form Design tab. Access closed itself and made a backup.

 

[tvanstiphout]

That means Access crashed.
Step up your backup regime, just in case the file becomes corrupted.
Decompile it.
Compact and repair

If it persists, repair the Office installation from Control Panel.