Disabled state in Access 2007

I have an access DB at work, which I will put on our network when finished.  I am working a macro with "SetValue" in it, but it still won't run.  I have added the network and the computer locations to the trusted sources, I have enabled all content, as well as enting the registry key to run in sandbox mode, but still get the same error.  I have followed all steps I have found online, and restarted my computer, but still cannot get it to run.   it is very important i fix this not only for my computer but for the users who will use this DB.  Any Help will be appreciated.
sealjoyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe OvermanEngineerCommented:
What error do you get? Where are you trying to set this value (form, table, report)? In what state is the (form, table, report) when you try to set this value?  What value are trying to set?
0
puppydogbuddyCommented:
see this link and verify that you followed the guidelines for setting up Trusted locations. Also note the demo on enabling blocked macros.

                     http://office.microsoft.com/en-us/help/HA100319991033.aspx
0
sealjoyAuthor Commented:
It is in an embedded macro in a form.  This is to control a drop down list to populate based on the previous dropdown list's choice.  Example Drop down list 1 has Types 1-4, needs to auto populate another dropdown list to include different categories based on the types, categories 1-4 (4 categories per type), then 4 problems per category... kind of like a list tree... these will populate a table once chosen.  I am not sure what you meant by what state the form is in... It is in the add mode when it is displayed.  the actual error i get is " The 'SetValue' macro action cannot be run in disabled mode."
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

sealjoyAuthor Commented:
I have followed all the advice from that link Puppydog, that is why it is so disconcerting.  I have gone in and followed all the steps for enabling all macros, then I reopen my DB, still doesn't work. Set all the trusted locations and moved my DB out then back into the location and reopened it, still doesn't work.   Added the Registry key mentioned... restarted computer, still doesn't work.  I am at a loss... hence why i am here.
0
vguzmanIT ManagerCommented:
take a look at
http://www.eggheadcafe.com/software/aspnet/32714928/disable-security-warning.aspx 
and make sure you have the right registry settings when using the runtime version.
0
Joe OvermanEngineerCommented:
The reason I asked about state is because some properties cannot be changed by SetValue unless in design mode.  But you are not changing properties of any controls.
It sounds like the macros are still disabled...
Double check and see the link puppydogbuddy provided if you have questions.
0
sealjoyAuthor Commented:
I have done all but 1 of those codes, my issue with this is will all my users have to reset thier registries in order for this to work?  I need to find a better way to do what I am trying to do if they have to set thier registries.  If I can get it to work on my computer, it needs to work on the network when I am finished.  most of my users have to be coached on how to disable thier macro's so having each one set a registry setting is not very effective.  the two options i have are the VBA script which does not seem to work and this embedded macro.  the Macro is also my biggest headache.
0
sealjoyAuthor Commented:
See attached images. for proof i have followed the directions by Microsoft for setting up trusted locations, macro settings and the error presented.
Setting1.jpg
Setting2.jpg
Error.jpg
0
sealjoyAuthor Commented:
Can anyone tell me If i have done anything wrong with my settings? or is this a glitch somewhere with my network or computer?
0
vguzmanIT ManagerCommented:
It seems your database is still in 2002-2003 format. Backup your database and try to convert it to 2007 version to see if it makes any difference. Also you can try to do compact / repair.
0
sealjoyAuthor Commented:
I created a 2007 version just now, pulled in all the data, and redid the embedded macro... now i get the attached warning
Error2.jpg
0
vguzmanIT ManagerCommented:
You can follow :
http://support.microsoft.com/kb/931407
to test if the DB is trusted or not.  Look at the "MORE  INFORMATION" part.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sealjoyAuthor Commented:
Just created the form and macro... nothing happened... the form did not pop up... but adding the form seemed to fix the problem... Thank you...
0
sealjoyAuthor Commented:
I think the solution was interesting.  I can now get the function to work without an error code.  thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.