Frank Freese
asked on
Convert macro to vb code gets error
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hopefully this bug is fixed in the Office 2010 SP1 update coming soon.
ASKER
thanks again folks - will move to 07 and wait for SP1
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
just created my tables -
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks cap - think I'll go back to 2007 until they get 2010 right - great information
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.