Learn how to a build a cloud-first strategyRegister Now

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

Access 2010 Build Event

I am use to old access where I would create a button
and when I went into build event it went right to the code block
Now it is taking me to this stupid macro stuff and I cant even get to the code box
is there a permanent setting to go directly to the code box
and if not how to I get to the code section like the old days so I can do my own code.
0
Stephen Roesner
Asked:
Stephen Roesner
  • 4
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
In the Access options you can select :
"Always use Event Procedures"
Option
However if you are using the Access .accdb format, ...the wizards will no longer create code, ...they will always create Macros.
There is know way (that I have heard of) to change this, ...it is simply the way Access .accdbs are set up to work.
You will have to write your own code manually
0
 
Jeffrey CoachmanCommented:
In other words, Access .accdb format will not create Code if you use the wizards, (...but .mdb format database will.)

You can still select :
"Always use Event Procedures"
form the Access ptions.

So you will create your button (or any other contrl) manually, ...then click on the event, ...then you will be taken immediately to the VBA editor instead of Access asking you:
Code Builder
Macro Builder
Expression Builder

JeffCoachman
0
 
Stephen RoesnerAnalysisAuthor Commented:
thanks i have the always use button clicked but was just frustrating to constantly copy and pasting old buttons to get to the build event - Access really bites sometimes.
0
Technology Partners: 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!

 
Stephen RoesnerAnalysisAuthor Commented:
Thanks for your quick answer
0
 
Jeffrey CoachmanCommented:
"Access really bites sometimes. "
Not really, ...
There is a good reason for this:
1. If you have been using Access for a while now, ...you should have most of the common code memorized by now.  So doing something like:
DoCmd.GoToRecord , , acFirst
...or:
DoCmd.OpenReport "YourReport", acPreview
...should be no big deal
2. ...or at the very least, you should have a textfile with all the basic code pasted in, ...then you can simply change the (object) names.

The reason MS made macros the default is so that "Non" developers could create simple automation without having the know VBA.

You will get used to it.
;-)

JeffCoachman
0
 
Jeffrey CoachmanCommented:
;-)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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