Solved Determine SetTempVar On / Off (1 Viewer)

[Sarah.M]

Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity).
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
FilterOn property to specify or determine whether the Filter property for a form or report is applied.

SetTempVar property how to determine whether the SetTempVar property is On and applied?

Please help

 

[arnelgp]

use IsNull([Tempvars]![TempVarName])

if it returns True, the tempvar is not yet created/initialized.

 

[Sarah.M]

use IsNull([Tempvars]![TempVarName])

if it returns True, the tempvar is not yet created/initialized.

Awesome I will try it
Thanks!

 

[Sarah.M]

use IsNull([Tempvars]![TempVarName])

if it returns True, the tempvar is not yet created/initialized.

I tried it but it does not work, I got error message
On MeetingListF on Open event
I tried the following ways I got error message
1.Nz(IsNull([TempVars]![UserID]))
2.IsNull([TempVars]![UserID])
3.Not IsNull([TempVars]![UserID])
4.IsNull([TempVars]![UserID])=False
5.IsNull([TempVars]![UserID])=True

Sample Attached
I put stop macro first line to stop error message just deleted it

plz help!

 

[The_Doc_Man]

Error 2950 is "Unable to run macro in Access database." It is saying that Access is not running in a trusted location. I sampled several articles and the first thing ANY of the articles said was "untrusted database" or words to that affect.

It seems that you finally have reached the point that not only can't you use VBA, you now can't use macros either. Your IT team has you nailed to the wall and you are going no further here.

 

[arnelgp]

i move your macro to the Load event.
on the Open event, the No control exists yet so you cannot SetProperty.

 

[Sarah.M]

i move your macro to the Load event.
on the Open event, the No control exists yet so you cannot SetProperty.

It Works Awesome!
Thanks!!!!!!!