Code - depending at home or the Office

[darinmc]

Hi
I have these 2 strings of code below
When i'm working on the design at home, I use the 1st line and
when at work the 2nd...

'stPathA = "C:\Lynx\EmpPhotos\" & Me.EmpRegNo & ".jpg"
stPathA = "\\Lynxserver\lynx\EmpPhotos\" & Me.EmpRegNo & ".jpg"

Is there an easish way to change this in an ADMIN form WITHOUT having to go into the code all the time??

Thx
Darin

 

[Remou]

You can probably use the computer name to check where you are, or if this is not permitted by security, you can use a global variable.

If Environ("ComputerName")="WorkName" Then ...

Or
If gvarWork=True Then ...

If this is used to link tables, the best bet is to maintain a table of tables and use this to check the connect property of each table.