Help… Access 2007 The Action or event has been blocked by disabled mode…

[CesarAustin]

So frustrated… I’m trying to do a simple make table.. and I keep getting that stupid error. At the bottom of the page.. does anyone know what that means.. or what I have to do…

Error: The Action or event has been blocked by disabled mode…

 

[Joe4]

Have a look here (specifically, the last topic):
http://office.microsoft.com/en-us/access/HA101085051033.aspx

 

[CesarAustin]

thank you... i guess i need to slowdown... so many little things that I have to do that the old access didn’t have… thank you Joe4

 

[Joe4]

Your welcome. We just upgraded to 2007 here also, and I am also having "fun" adjusting to all the new changes. I don't mind the ribbon, but I can't say I am all that wild about the new look. And some of the security changes are driving me a little bonkers.

 

[CesarAustin]

Tell me about it / I’m actually stuck again… I just finished creating a small macro and I can’t find the “set warning”… I changed access to enable the macros but, I still can’t find it… and I also can’t find the “compact and repair “..

 

[CesarAustin]

I found the “compact and repair”…. Now my big issue is that “set Warning” for my macros..

 

[Joe4]

Both can be found under Access Options. To get there, click on the Microsoft Emblem in the upper left hand corner of the Access window, then select Access Options.

Macro Settings
- Click on the Microsoft Emblem in the upper left hand corner of the Access window
- Select "Access Options"
- Select "Trust Center"
- Select "Trust Center Settings"
- Select "Macro Settings"

Compact & Repair
- Click on the Microsoft Emblem in the upper left hand corner of the Access window
- Select "Manage"
- Select "Compact & Repair Database"

 

[CesarAustin]

In the macro setting.. I did that.. I picked “Enable All Macros….”but when I go back to my macros… the “set warning” option is not there… am I doing something else wrong??

 

[Joe4]

Not sure. Note that under the "Macro Settings" listing, there is also one named "Message Bar". You may want to choose the first option, "Show the Message Bar in all applications when the content has been blocked.". That will at least give you the message when stuff has been blocked.

You can also set up Trusted Locations, so it will trust the VBA of any application found in a specified directory/folder.

 

[CesarAustin]

Dang… I’m just about to give up and go back to the old Access.. . I can’t set/find the stupid “Set warranting” for my macros…..

I have gone to the “Trust Center Setting” and have “Enable all macros”… I have add the path to where that database is and listed it as a trusted location… I don’t know what else to do…

(Sigh)