My goal here is to get access to open a folder that is related to the
current displayed record. For example, if the customer's last name is
Smith, i want the folder "//server01/jobphotos/Smith" to pop up when
you click the Job photos button.

So far this is all I have for it...

RetVal = Shell("explorer /e,/root, //server01/jobphotos/Smith")

This works on a one time basis, but i need it to be variable so it
bases the folder name on the last name of the contact record. Any help
would be greatly appriceated. Thanks

kyle.crommett@gmail.com wrote in
news:1155248108.070512.320800@m73g2000cwd.googlegr oups.com:

My goal here is to get access to open a folder that is related
to the current displayed record. For example, if the
customer's last name is Smith, i want the folder
"//server01/jobphotos/Smith" to pop up when you click the Job
photos button.
>
So far this is all I have for it...
>
RetVal = Shell("explorer /e,/root,
//server01/jobphotos/Smith")
>
This works on a one time basis, but i need it to be variable
so it bases the folder name on the last name of the contact
record. Any help would be greatly appriceated. Thanks
>
>

RetVal = Shell("explorer /e,/root,//server01/jobphotos/""" &
Lastname & """")




--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com