• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 636
  • Last Modified:

Access 2010 VBA - How do I turn off macros and turn on VBA

Hi,
See attached.

I am creating some simple forms with buttons to call other forms.

The system is creating macros when I would much prefer if it just created regular VBA.

How can I prevent it from creating macros.


Keystone-Prototype.zip
0
Patrick O'Dea
Asked:
Patrick O'Dea
  • 3
  • 2
  • 2
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
file > options > object designers > form/report design
check always use event procedures
0
 
Patrick O'DeaAuthor Commented:
Thanks capricorn1,

I  have already ticked this box.  (I believe that it is ticked in the database I attached).

However, the problem persists??

Any further thoughts??
0
 
Rey Obrero (Capricorn1)Commented:
try to compact and repair or close db and open again.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

  With the new emphasis on macros once again, I don't think you'll find a switch to turn it off.  You can turn off the Wizard, but I don't believe there is anything to make it generate VBA code rather then a macro.

JimD.
0
 
Rey Obrero (Capricorn1)Commented:
<However, the problem persists??>
if you are using the wizard to create the button, then you can not turn off the creation of embedded macro.

you can, convert the macro created to vba
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

 Note that there is a "Covert Form Macro's to VBA" on the ribbion.

  However Microsoft is really trying to get people to move away from the VBA, mostly so that DB's can be published via Sharepoint.

JimD.
0
 
Patrick O'DeaAuthor Commented:
Thanks all,


I "Saved As" to 2003 and the problem is gone.   Not very satisfactory though.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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