We help IT Professionals succeed at work.

Convert macro to vb code gets error

Frank Freese
Frank Freese used Ask the Experts™
on
Experts,
When I use the wizard to create a button and then wish to convert the marco to VB code I get an error message stating that Access has stopped working.
Also, how is it I can not incorporate a screen shot in my question to help you all see what I'm, referring to? I've tried Alt - Prt Screen and Ctrl-V with no luck.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
Top Expert 2016
Commented:
if you have an A2007, you can convert those macro to vb

open form in design view,
from ribbon
        Database tools > Macro
             Convert form's macro to Visual Basic
Top Expert 2011

Commented:
Hopefully this bug is fixed in the Office 2010 SP1 update coming soon.

Author

Commented:
thanks again folks - will move to 07 and wait for SP1
Top Expert 2011
Commented:
Hopefully your did not use any of the new features in 2010 that will make it incompatible with 2007.

Author

Commented:
just created my tables -
Top Expert 2016
Commented:
see this link as reference
Backward Compatibility between Access 2010 and Access 2007
Features that are not available in Access 2007

http://msdn.microsoft.com/en-us/office/cc907897.aspx

Author

Commented:
thanks cap - think I'll go back to 2007 until they get 2010 right - great information
Top Expert 2011

Commented:
Since 2007 and 2010 create embedded macros with the wizard I avoid the control wizards. This also avoids the need to convert Macros to VBA code.