Hi NG

I need a little help with syntax in Access Runtime 2010...
I want to use Inveron variable to set a Reg.Key(Trusted Location)...

The environ variable %LOCALAPPDATA% remains on my laptop...

I want to create a Trusted Location. I tried these two scriptlines - but
with no luck...

%LOCALAPPDATA%\MyFolder\ - not working
[LOCALAPPDATA]\MyFolder\ - not working

It should end up with :
C:\Users\Bjarne\AppData\Local\MyFolder\

Help needed please...
Bjarne

bsn wrote:
If I enter in the immediate window
? environ("temp")
I get the value of the Temp environment variable

T u for answer...
I can to get all my environ variables in vba code...but...
What i need is what i have to hardcode in Access Runtime 2010...
Bjarne

bsn wrote:
I did not understand your above response.

If all people have the same folder paths...
Function RetLocal() As String
Dim strUser As String
RetLocal = Environ("UserName")
If RetLocal > "" Then
RetLocal = "C:\Users\" & RetLocal & "\AppData\Local\MyFolder\"
Else
RetLocal = ""
End If
End Function

If I enter from the immediate window
? RetLocal()
it returns
C:\Users\Salad\AppData\Local\MyFolder\

"Salad" skrev
bsn wrote:
I did not understand your above response.
-------------------------------
Sorry
I have to hardcode an environ variable(Registry key), in the Packet
Wizard...
And I dont know the syntax, as described before...
SNIP

Bjarne