Access 2007 and macros

[davesmith202]

When I use the Form Wizard for a button that opens a Form, it creates a Macro.

How do I get it to create the vba code instead, like earlier Access versions?

Thanks,

Dave

 

[andy_25]

Cancel the wizard. On the on_click event change to [event_procedure] then click the ... which will open the VB Edit window where you can enter your own code.

 

[davesmith202]

I am aware of that. But I like the use of the Wizard. Anyone?

 

[pbaldy]

As far as I know, you're stuck with them. I dislike them as well. According to Allen Browne's site, if you're in MDB format the wizards will create VBA code, but in ACCDB format they create embedded macros.

 

[davesmith202]

I think its a step backwards. Why on earth would they do that.

 

[Rabbie]

I think its a step backwards. Why on earth would they do that.

Who are we to question the wisdom of Microsoft

 

[davesmith202]

They got Vista wrong!

 

[boblarson]

When I use the Form Wizard for a button that opens a Form, it creates a Macro.

How do I get it to create the vba code instead, like earlier Access versions?

Thanks,

Dave

Have you tried going into the Access Options and then in ADVANCED or DESIGNERS area (don't have 2007 at work to see exactly where it is) and then find the checkbox which says something like "ALWAYS USE EVENT PROCEDURES." I can't remember for sure if you check that box if the wizards still do embedded macros. But if they do you can still convert them to vba.

 

[pbaldy]

I can't remember for sure if you check that box if the wizards still do embedded macros.

Sadly, they still create embedded macros.

 

[boblarson]

Sadly, they still create embedded macros.

Couldn't remember. But, you can run the convert to VBA on them and go from there.