asked on

Turn off Macro and Use VBA

I have always been able to force Access to use VBA instead of macro's by marking Use Event in Access Options. For some reason, in a new Access 2007 database I wrote, it does not work and still gives me Macros. I have closed and opened the data base, started new form, still get Macros

Thanks

Mike

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Do you have the property set to Yes shown in the image ?

mx
Capture1.gif

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

also see:

https://www.experts-exchange.com/questions/24201327/Embedded-Macros-in-Office-2007.html

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"there is no longer an option to have it create VBA instead of a macro."
Where or what is this ?

I'm not being forced to create Macros in any of my A2010 dbs ...

mx

Jim Dettman (EE MVE)

<<I'm not being forced to create Macros in any of my A2010 dbs ...>>

Wizards will not generate anything but macro's...

JimD.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

oh. Well, in never having used the wizards ... guess I would not notice that.

mx

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

<Has anyone notice the the Expert Ranking (genius, guru, bozo, etc) is missing under the EE emoticons ?
Not sure when this started, but I just posted this on the Bug page>

mx

Jeffrey Coachman

Hey, I never got my Bozo shirt...
;-)
lol

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Yeah ... they were special order only !

Mistebar

ASKER

A very thorough answer.

Thanks

Mike