SetTempVar

[alhotch]

Hiw do I set this variable in a macro using the function from API: Get Login
name
http://www.mvps.org/access/api/api0008.htm ?

This function gets the ComputerName and I want to set a Temp Variable so I
can refer to it in queries.

 

[Steve Schapel]

Alhotch,

In a macro, just enter the SetTempVar action, in the Name argument enter
whatever you want the name of the TempVar to me, and in the Expression
argument, just enter like this:
fOSUserName()

 

[alhotch]

Works as advertised, Steve. I had originally used a "sample" macro that
demonstrated this capability. I was using:

ComputerName - Macro Name
SetTempVar - Action
MyVar,fOSMachineName - Argument
[TempVars]![MyVar]<>0 - Condition
MsgBox - Action
="You entered " & [TempVars]![MyVar] & "." - Argument
RemoveTempVar - Action
MyVar - Argument

This three line macro was giving me a "Type Mismatch" error. Removing the
"<>0" part of the above [TempVars]![MyVar] Condition makes trhis macro work
correctly.

Thanks for your help. I was sure I had done it right but not being a VB
programmer, I was doubting the fOSMachineName function.