Connecting Tech Pros Worldwide Help | Site Map

Opening an explorer window with access

  #1  
Old August 10th, 2006, 11:05 PM
kyle.crommett@gmail.com
Guest
 
Posts: n/a
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

  #2  
Old August 10th, 2006, 11:15 PM
Bob Quintal
Guest
 
Posts: n/a

re: Opening an explorer window with access


kyle.crommett@gmail.com wrote in
news:1155248108.070512.320800@m73g2000cwd.googlegr oups.com:
Quote:
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

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Denied trying to do quick editing Ron Weldy answers 12 November 19th, 2005 05:25 AM
Error Trapping In Access 2000 Peter Frost answers 6 November 12th, 2005 11:14 PM
Error Trapping In Access 2000 Peter Frost answers 6 November 12th, 2005 10:50 PM
cookie not sent with window.open Paul answers 18 July 19th, 2005 12:35 PM