Access 2007 "[Embedded Macro]"

[Daniel]

Just installed office 2007 - whenever I add a combo box, button or anything
in a form, I don't get the usual "evemt procedure" in the property sheet, I
get this "embedded macro" - is there a way to change this back to the event
procedure and go back to the VB screen as in the older versions of access?

Thanks

 

[boblarson]

If you use the Wizard for adding the controls, you can't. You need to do it
manually. But, you can set the Always Use Event Procedures checkbox so that
you can get there without having to select when you do it manually.

To set that option, you go to the Round Office button, then to Access
Options and then to Object Designers and then look down the list and it
should be about 1/3 to 1/2 down the page of options.
--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[MikeJohnB]

Can you explain a bit more Bob, I don't like the embeded Macro, I want to see
the code behind the Combo Box as it used to be. I have selected always use
event procedures but still get embeded macros where event procedure should
be. Is there no way to see the code generated by the wizaerd then? A
retrograde step perhaps from Microsoft as I used to use Macros, does this
mean I have to code the combo box myself now?

 

[boblarson]

Yes, unfortunately - MS has had complaints about this from a lot of people.
If you use the wizards in an ACCDB file (not in mdb), you cannot look at VBA
because it is an embedded macro. You can go look at the macro, but since it
doesn't use code, but macro actions, it isn't the same as before.

So, if you want to view the code behind it, as code, you need to code it
manually and NOT use embedded macros.
--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[MikeJohnB]

Thanks for your reponse Bob, as I said, a retrograde step from Microsoft. I
guess I will have to establish sample code in mdb and copy it across to accdb
in future, (Set up templates is what I mean) I sometimes add or change code
in combo boxes for additional functionality, not good if its macro based
though.

Anyway, enough moaning I guess but once again, thanks for you help.

Regards

Mike