Control wizard creatars macro, not VBA code

[marlan]

Hi,

Iv'e just upgraded my computer, I am now running Acc 2010.

first: I still want to develope mdb files, because there still may be clients out there running 2003. Am I loosing some great feature only in newer version?

Second: I see control wizard on forms and reports creates macro. I would like it to create code, so that I can add other code to it. Is there a way to control this?

Thanks in advance!

 

[CJ_London]

Am I loosing some great feature only in newer version?

Not really, in the the ACE side of things, deleting the contents of a table is considerably quicker and it may be my imagination, but ADODB seems quicker. From the form (/my) perspective the main change is the button design.

Is there a way to control this?

yes - don't use the control wizards - if you are that experienced you don't need them anyway

 

[AlexHedley]

There is a button that converts macros to vba in the ribbon.
You could then add to that.

 

[RuralGuy]

I see control wizard on forms and reports creates macro. I would like it to create code, so that I can add other code to it. Is there a way to control this?

Not true. Go to File>Options>Object Designers>Form/Report design view - and check Always use event procedures.

 

[marlan]

Thanks All of you!

There is a button that converts macros to vba in the ribbon.
You could then add to that.

Do you meen collapse all? it gives me to much local language (Hebrew in my case)... is there an other button Iv'e missed?

 

[AlexHedley]

If you open the Macro in Design View then click on Convert Macros to Visual Basic

This was just a simple Macro that opened a Form and produces the following.

 '------------------------------------------------------------
' Macro1
'
'------------------------------------------------------------
Function Macro1()
On Error GoTo Macro1_Err

    DoCmd.OpenForm "Form1", acNormal, "", "", , acNormal

Macro1_Exit:
    Exit Function

Macro1_Err:
    MsgBox Error$
    Resume Macro1_Exit

End Function

 

[marlan]

Great tool!

works only for saved macro as a DB object, not for macro genrated to a control.

But thanks, it's great!

 

[RuralGuy]

Open a form and then select the Design tab and look at the far right side of that tab.
Convert Form's Macros to Visual Basic