On SetValue Macro Action!

Question

Hi,

I have developed an application in Access 2013 Pro. and cannot get find SetValue macro, this action was available in Access 2003 so all application which I have developed with that version is functioning find when running the SetValue Macro Action in Access 2013. Could you tell me where I can find SetValue Action in Access 2013. I have already tried importing this action from my previously designed application in 2003 version but it dose not run, however, the macro action shows a yellow cautionary sign (a Triangle with Exclamation Point) in front of it, what does it mean? 

Thanks,

Dr. Pouyafar

---

RezaNiazi

Answer 1

the macro action is: SetProperty

then within that one has a choice of properties, of which one is Value

on the other question; typically the exclamation point symbol is indicating/warning an action that will add/change data - it is intended to be helpful -  but that is just an off hand comment and I'm not 100% certain in your case......

Answer 2

Hi Doc. Click on the "Show All Actions" button on the Ribbon to see if the SetValue action show up. Hope that helps...

Answer 3

SetProperty is not the same as SetValue.  SetValue still exists, it's just hidden by default.

---

Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

Answer 4

Hi Pouyafar,

Please visit the link mentioned below to get the information regarding Set Value Macro Action.

SetValue Macro Action-Access 2013

here it is also mentioned that in which conditions it will not work.

You have mentioned that “macro action shows a yellow cautionary sign (a Triangle with Exclamation Point) in front of it, what does it mean? ”.

Which message it displays to you?

yellow cautionary sign probably looks like this picture below. Can you tell us Which message it displays to you?

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 5

Hi again,

I followed your directions in the given link, but still getting the same yellow cautionary sign and there is not any message shown as popup message or dialog-box message, however, when I draw the mouse over the sign, it shows a controltip text saying "unsafe macro." For correcting the error, I checked the "Allow all trusted location on my network" checkbox and "Enable All Macros" option button in the Trust Center settings, but the sign did not go away and is shown on the left side of the macro action in the macro group. Therefore, I have included a screenshot of the macro group so it would be help to you in solving my problem.

Thank you,

Dr. Pouyafar

---

RezaNiazi

Answer 6

I followed your directions in the given link, but still getting the same yellow cautionary sign and there is not any message shown as popup message or dialog-box message, however, when I draw the mouse over the sign, it shows a controltip text saying "unsafe macro." For correcting the error, I checked the "Allow all trusted location on my network" checkbox and "Enable All Macros" option button in the Trust Center settings, but the sign did not go away and is shown on the left side of the macro action in the macro group. Therefore, I have included a screenshot of the macro group so it would be help to you in solving my problem.

The warning icon appears because this macro action is considered unsafe -- because it can change data -- and for no other reason.  Ignore it.

---

Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

Answer 7

Hi Pouyafar,

Because it should work, even with the triangles, as long as it's in a Trusted Location. The triangles only tell you that those actions will only deploy if in a Trusted Location, so if the actions still won't deploy then the database is not in a Trusted Location, again, you can use the Trust Center to create a trusted location and then place the database in that trusted location.

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 8

Hi again,

I tried your solution and neither of the problems; setting the value to designated field and the triangle were resolved. This is despite the fact that I tried two ways of assigning a Trusted Location to the database as you see in below screenshot, but it still no go. Is there anything else that I should try?

Thank you,

Dr.R.Pouyafar

---

RezaNiazi

Answer 9

Hi Pouyafar,

did you try to set value from VBA code?

if you are not able to set it from user interface you can try to set it from code. may be from there you can able to set the value.

Please try to check it and let us know whether it work for you or not.

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 10

Hi Pouyafar,

did your issue solved? or you are still facing an problem with your issue.

if it is solved and the above mentioned suggestion help you to solve your issue then can you mark it as an Answer that help to solve your issue.

if you have find the solution of your issue by yourself then can you please share your solution with our community so that if some other community member have same issue like you also get solution by your post.

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 11

Hi,

Unfortunately all the offered solutions were failure and I still can not get the macro to Run. I am going to try VB codes to set the value and or convert the Macro Group to VB codes and then Run it. But if it does not work then I have to hire a Witch Hunter!!!

Thank you,

Dr.R.Pouyafar (Niazi)

---

RezaNiazi

Answer 12

Hi Pouyafar,

did your workaround worked with VB or you are still facing a issue with that ?

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 13

Hi,

Since my Office Applications were not functional for today, I haven't try the VB code yet but I am going to let you know if it works!

Thank you,

Dr.R.Pouyafar

---

RezaNiazi