Macro embedded and VBA

[jajoju]

Hello,

Since I use Access 2013 (before it was AC-2007), I can not create a VBA event procedure by inserting a command button on my form with the help of the Control Wizard.

In my property sheet, it's an embedded macro that appears and still there I can not convert to Visual Basic. A message appears: '' There is a problem opening the macro '' Macro Incorporated ''



Is this a bug from Access 2013? Is this normal ?? Is it because AC-2013 no longer accepts VBA procedures ?? AC-2013 wants to promote embedded macros ??? Is this a default of AC-2013 ???

With AC-2007, I did not have this problem ...

How to remedy this problem ???

Thank you
Jacques

[CJ_London]

if you are developing a web app - they don't use vba and you have to use a macro. If it doesn't need to be a web app, don't develop it that way.

I'm pretty sure the wizards now only create macros, but assuming you are not in a web app, in form design view on the ribbon under the design tab you will see an option to the far right to convert macros to visual basic

[jajoju]

It's what I did ... I used the option to the far right to convert macros to VBA ( like you said ) and ... it doesn't work again ...!!!
I do believe the wizard worked with AC-2007 in the past but it doesn't work anymore with AC-2013 ... It is strange !! Why is that ? I am Not developping a Web App ... and I do not know absolutely nothing about Macros ...
Thank you
Jacques

[ssanfu]

There is nothing forcing you to create a macro when you add a control to a form. You can click CANCEL and just write the VBA code (as I do).
I have been putting up with the wizard running when I add a control (A2010) - in A2000 I had turned off the wizards.
The wizards really irritate me because NOW they only create macros, not VBA code!


I just did a search on how to turn off the wizards.... found out how at
http://www.pcreview.co.uk/threads/di...-2010.4035691/ post #4.
To save time, here is how:

LOL Sure, glad to. In the Controls area of the ribbon, there are up/down
arrowheads for scrolling through all the controls you can add. Right below
the down arrowhead is a down arrowhead with a line above it. Clicking on
that brings up 3 additional options, one of which allows you to toggle the
control wizard.

Neil

I am happier ....

[jajoju]

Thank you for your answer ... I did a program 4 or 5 years ago with the VBA Wizard ( not Macro ) ... I am not an expert in VBA but the Wizard helped me a lot ... by adding part of the event procedure in VBA ...
I just had to write few commands in VBA to complete. I find VBA more limpid , more clear than Macro ( chinese for me ) ... Now , with the Macro Wizard ... I am all lost
Thanks

[CJ_London]

Not sure if it will help but if you go to File>Options>Object Designers, Forrm/Report section, try ticking the 'Always Use Event Procedures' box. I presume it is still available in 2013