Solved

The "Set Value' Macro action cannot be run in disable mode. in MS Access 2007

Posted on 2009-05-18
5
3,437 Views
Last Modified: 2012-05-07
Hi,

I have MS Access 2007 file when i open, I got Security Warning in top there is button Options... when i click there, inside there are 2 option
Help protect me from  unknows content (recommended)
Enable this content

when i select " Enable this contect " i got error, you can see that error in screen shot 3.

but same file is working well another pc. how i can fix.
2.jpg
3.jpg
1.jpg
0
Comment
Question by:shariqsaeed
5 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 24410663
According to your screen shots, you did NOT choose the option to 'Enable this Content'.  The security warning bar is still showing in screen shot 3.
0
 

Author Comment

by:shariqsaeed
ID: 24410737
when i choose security Option > enable this content then i get this Error which is in screen shot.
foget all thing when i open file > chose Security Alert Option > select " Enable this contenct" when press ok i got this erorr. which is attached.
 

Pic-4.jpg
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 24410811
Change your trust settings, see if that helps initially

Click the office button on top right then select Access Options
then select Trust Center and click on Trust Center Settings
In Macro Settings, Enable All Macros
In Trusted Locations, you could try adding your path where the db is or click on "Allow Trusted Locations on my network"


Have u got a similar question to this?
0
 

Author Comment

by:shariqsaeed
ID: 24411139
yes, i have open another place becasue here they didnt reply.
0
 

Expert Comment

by:sealjoy
ID: 28461269
I have a db on a work computer, would like to put it on the network.  I have both the network and my computer location as trusted sources, and also have enabled all content.  I tried adding the registry key, but still my Access 2007 DB will not run the macro with the "SetValue" option.  I still get the "disabled mode" error any help?
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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…
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…

820 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