M
Muggs
I am working with Access 2003 and Windows XP Professional 2002. Each record
in my database is assigned a document number automatically and has a
corresponding document. The autonumber is formatted as "A00000" (document 1
is A00001, document 2 is A00002, etc.). The Table has a hyperlink field
which I have to manually enter the document hyperlink for each record. I
would like the hyperlink to be populated automatically on a Form. I have
inserted a picture that I would like to click on to open the document. On
the "Click On" event for the Image, I have the below code which obvioulsy
isn't working or I wouldn't be on this board. Also, the documents are stored
on a file server and so is the database.
Image = "#S:\Development\Documents\ & Format([DocumentNo], "A00000") & ".pdf"
Please tell me what is wrong with my code or if I'm going about this wrong.
Margaret
in my database is assigned a document number automatically and has a
corresponding document. The autonumber is formatted as "A00000" (document 1
is A00001, document 2 is A00002, etc.). The Table has a hyperlink field
which I have to manually enter the document hyperlink for each record. I
would like the hyperlink to be populated automatically on a Form. I have
inserted a picture that I would like to click on to open the document. On
the "Click On" event for the Image, I have the below code which obvioulsy
isn't working or I wouldn't be on this board. Also, the documents are stored
on a file server and so is the database.
Image = "#S:\Development\Documents\ & Format([DocumentNo], "A00000") & ".pdf"
Please tell me what is wrong with my code or if I'm going about this wrong.
Margaret