help please

[wiredgecko]

I created a table to keep track of jobs. I also have a folder which I use to store pdf files relating to each job. located in G:\Jobs\####

in the table I have a field for Job_Number. I would like to create a command button hyperlink which will take me to the folder in the G drive for the particular Job_Number

hoping I was clear in what I am trying to accomplish

thxs

 

[Kamolga]

Hi,

Click on th cell where you jobnumber is and CTRL+K on windows (or go on insert tab, hyperlink), link to folder and browse your folder for required pdf.

Otherwise the code for a button might be

Dim myShell As Object
Set myShell =  CreateObject("WScript.Shell") 
[COLOR=#333333]myShell.Run "G:\Jobs\mypdf.pdf"
[/COLOR]