SETVALUE Argument can not run in disabled Mode

[Kobus-Dippenaar]

Hello Again,
Blessings to all.
I don't know, I have noticed that the SETVALUE argument is not openly available in the lookup tables when setting a macro. (But that aside)
I have set my drives c:\ and d:\ as trusted, and also thicked the sub folder option.
:banghead:
Your comments will be appreciated.

Regards,
Kobus

 

[pbaldy]

Are you saying that SetValue is not one of the available Actions to choose from? If so, you probably need to click on "Show All Actions" on the ribbon, with the macro in design view.

 

[Kobus-Dippenaar]

@Paul
Thanking you for your assistance.
On the embedded macro window, the "Show All Actions" is greyed out. It is not "live" so to speak.

 

[pbaldy]

I don't use macros so I'm not experienced in this area (I use VBA code). I did a brief test in A2010 and the "Show all Actions" button was still active in an embedded macro. What version are you using?

 

[Kobus-Dippenaar]

I am using A2007
I am starting to explore VBA.
The issue is I am looking up data in a second form, and would like to transfer the fields to the original form (the first form) I know one has to get focus, I think?
The Me. field name only works in the current form.
Maybe just help me with the VBA syntax of moving fields between two forms open at the same time.
Appreciate your help.
Blessings

 

[pbaldy]

Here's a reference on how to reference the forms:

http://www.mvps.org/access/forms/frm0031.htm

You do not need to set focus to the form or textbox, just:

Forms!TargetForm.TextboxName = Forms!SourceForm.TextboxName

 

[Kobus-Dippenaar]

Re: [Solved] SETVALUE Argument can not run in disabled Mode

@Paul
Tanks!
Quite "Lekker", Most enjoyable, Pleasant.

 

[pbaldy]

Happy to help!