Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 650
  • Last Modified:

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
0
Mistebar
Asked:
Mistebar
  • 5
  • 2
  • 2
  • +2
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Do you have the property set to Yes shown in the image ?

mx
Capture1.gif
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Mike,

  Starting with A2007 and Microsoft's new focus on macros, there is no longer an option to have it create VBA instead of a macro.

  Setting the option MX mentioned above now only affects the use of the builder button (...).

  There is a macro to VBA converter button on the ribbon.

JimD.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<I'm not being forced to create Macros in any of my A2010 dbs ...>>

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

JimD.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
oh.  Well, in never having used the wizards ... guess I would not notice that.

mx
0
 
Jeffrey CoachmanMIS LiasonCommented:
To clarify what Jim posted...

In an Access 2007 or newer *Format* database, the wizards will only create Macros.

If you want the wizards to create VBA code, then you will have to convert the DB back to the 2002-2003 format.

However, this one benefit is, IMHO, not worth converting the format for.

Like most Experts here, I have pretty much memorized any wizard code, and can write it myself.
Remember the wizards only do fairly basic things anyway, ...so it is not that hard to use the wizards at first, then simply copy the code they create to a note pad file to use for reference.
;-)

(Also remember that Intellesense and the VBA help files are always there to help.)

;-)

JeffCoachman

0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
<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
0
 
Jeffrey CoachmanMIS LiasonCommented:
Hey, I never got my Bozo shirt...
;-)
lol
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yeah ... they were special order only !
0
 
MistebarAuthor Commented:
A very thorough answer.

Thanks

Mike
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now