enable vba callback code in access 2007

Posted on 2007-07-31
Last Modified: 2008-03-17
I am trying to use VBA callbacks to customize my ribbons..However even the simplest of button click is not working....
I came across this statements...

"One limitation is that code must be enabled in the database for the code to run."

If you use VBA callbacks, the database must be opened in enabled mode for the code to run.  You may receive an error in Beta 2 when opening a database with custom ribbons in disabled mode.

where is this option that enables mode for the code to run?? I cant find it anywhere...
I am able to make the button appear in the database, but when i click on it nothing happens...its not calling the vba code, even if i just have a msgbox statement..

Question by:Pra4444
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    See these links I am accumulating for A2007 - a good reference in general:  'Transisitioning to A2007    ' Various A2007 Issues    'A2007 Limitations list   ' A bunch of good stuff    'Ribbon
    LVL 12

    Author Comment

    I have gone through most of the links...but cant find where to enable it...
    I just want to know, how to enable vba callback code for a particular database....
    LVL 37

    Accepted Solution

    When you open the Access 2007 database, right under the ribbon bar, you should see a "Security Warning   Certain content in the database has been disabled" followed by a button that reads "Options..."
    click on that Options button, and a "Security Alert" dialog opens the radiobutton for "Enable this content", click "OK"...the database is now in "Enabled" mode.
    LVL 12

    Author Comment

    yeah i remember that..but i dont remember what i clicked...!!! it was a day or so ago, when i was fooling around...hmm...
    but it doesnt ask that anymore...
    LVL 12

    Author Comment


    You did point to me in the right direction..i went to access options->trustcenter-> clicked trust center settings and selected the radio button Show the message bar in all applications

    so , after i closed and opened it again, it gave me the security error and when i enabled it, my vba code worked like a charm..


    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!

    Join & Write a Comment

    Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    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…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    728 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

    16 Experts available now in Live!

    Get 1:1 Help Now