Access 2010 Build Event

Posted on 2014-08-14
Last Modified: 2014-08-15
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.
Question by:Grizbear51
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    In the Access options you can select :
    "Always use Event Procedures"
    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, is simply the way Access .accdbs are set up to work.
    You will have to write your own code manually
    LVL 74

    Accepted Solution

    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


    Author Comment

    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.

    Author Closing Comment

    Thanks for your quick answer
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    "Access really bites sometimes. "
    Not really, ...
    There is a good reason for this:
    1. If you have been using Access for a while now, should have most of the common code memorized by now.  So doing something like:
    DoCmd.GoToRecord , , acFirst
    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.

    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now