embedded macros vs event procedure

[jmlight]

I am using the Button Wizard to open a form. When I review the property sheet under Event - it calls up an Embedded Macro.

How do I get it to be an Event Procedure automatically instead of an imbedded macro?

 

[HiTechCoach]

I am using the Button Wizard to open a form. When I review the property sheet under Event - it calls up an Embedded Macro.

How do I get it to be an Event Procedure automatically instead of an imbedded macro?

Per Microsoft, you can't change the default at this time.

I am hoping this will be fixed in the SP2 update.

 

[Banana]

You can check "Always Use Event Procedure" for either 2003/2007 (earlier version may have it, but I don't know for sure.

2003:

Tools -> Options, Form/Reports

2007

Office button -> Access Options -> Object Designer

 

[jmlight]

Thanks - I'll look for where that option might be

 

[HiTechCoach]

Here is my source:

Stop 2007 from writing macros

note the the replies from:
Clint Covington
Lead Program Manager, XAS Services
Microsoft Corp.
http://blogs.msdn.com/clintcovington

 

[Banana]

I might not be understanding something, but I created a new button using wizard, selected random action. I went to the button and it had [Event Procedure] for the click event and I can open the code behind the form for and see the code for that button....

 

[Banana]

Aha, now I just figured out my confusion.

Though I was using 2007, I was dealing with .mdb which writes code, but if I use a .accdb, macros is used instead!

Now I feel like a silly goose.

 

[HiTechCoach]

Aha, now I just figured out my confusion.

Though I was using 2007, I was dealing with .mdb which writes code, but if I use a .accdb, macros is used instead!

Now I feel like a silly goose.

Banana, it happens to the best of you gurus.

What is also bad is that if you downgrade an 2007 database that used the wizards to create command buttons with embedded macros, they will not work. You have to manually edit ever command button and convert the embedded macro to VBA code.