T
Tammy
Yet another question! I have created a function to
determine the correct path of a file (being opened from
an Access database). As there are multiple files where
the doc could be, I am trying to assign a value to the
funciton which indicates the correct location. I am
wondering how I can test the value of the function
without rerunning it every time. Here is the code I have
skethced out:
if (Records.DetPath(file)) = "error" then
goto errorline:
else
if (Records.DetPath(file)) = "w" then
strPath = "Work/"
else
strPath = "Save/"
endif
endif
I have the function in a module named "Records". Thanks
for any suggestions! I have tried looking
under "functions" on the Knowledge Base, but I'm not sure
exactly what to search for?!
determine the correct path of a file (being opened from
an Access database). As there are multiple files where
the doc could be, I am trying to assign a value to the
funciton which indicates the correct location. I am
wondering how I can test the value of the function
without rerunning it every time. Here is the code I have
skethced out:
if (Records.DetPath(file)) = "error" then
goto errorline:
else
if (Records.DetPath(file)) = "w" then
strPath = "Work/"
else
strPath = "Save/"
endif
endif
I have the function in a module named "Records". Thanks
for any suggestions! I have tried looking
under "functions" on the Knowledge Base, but I'm not sure
exactly what to search for?!