Enable code in 2007?

[Ivor Williams]

I've been using Access for a number of years and have been writing simple
VBA code successfully for a number of those years with much help from this
forum. I just started using the 2007 version and have encountered an issue
I've never come across before. None of the controls I add to forms are
functioning properly, if at all. As an example, I added a command button to
the form and using the wizard set the OnClick event to open a form. Clicking
on the button does nothing. I also created a basic combo box using the
wizard to "Find a record on my form based on the value I selected in the
combo box". Changing the value in the combo box is supposed to trigger the
AfterUpdate event, causing the form to display the record chosen. This
doesn't happen, either. Ideas?

Ivor

 

[Pete D.]

Couple of things.
Access has a trust center and you must do one of the below.
Sign the project (VBA Code) with a certificate.
Place files in trusted location selected through the trust center under
access options.
within trust center
Select "Show message bar in all applications when content has been blocked.
If the last isn't selected user won't even know something isn't right except
nothing works.

 

[Albert D. Kallal]

Access 2003, and 2007 come with their code (macro) settings at high.

Just set the macro settings to low..and you code etc. will run fine (you
have to exit after you do this).

You only need do this once, and then all applications mdb/accDB etc will run
without problems.

go

office button->access options->trust center->hit on the right side the
button Trust Center Settings

then choose macro settings., and choose the botton one called:

"Enable all macros"