Hyperlink issues

[rebfein]

I have a table set up with a hyperlink field. The function is to be that the hyperlink allows the user to open a .pdf scan of the document for more information (otherwise, to add the extra info, the table would have at LEAST 40 more columns than the 15 it currently has).




I understand that in order for the hyperlink to work the files have to be in a folder within the database, which is in process (40 scans down, 3965 to go).

Questions:
How do I add the URL to the column?
And what would be the best way for the user, my boss, to assess the hyperlink? - I was thinking a button on a form that would open the .pdf in another window. However, from what I've read on the internet, it seems beyond my current capabilities, as it involves a lot of code; and in the scheme (or schema) of things; I'm not sure in the list of coding text, of where I am to place additional text).

Thank you for any assistance, and now, back to scanning...

[Micron]

files have to be in a folder within the database
you mean the files/documents have to be in a table? I wouldn't do that. If you don't mean that, then how do you put a folder in a database?
And what is the hyperlink linking to? A web page? Network file folder?

[Bulzie]

If you add a hypelink field, you can display the link directly on the form for them to click and open the PDF. Or if you know the file name and the path is the same each time, you could put this statement in the OnClick of a button to open the PDF(you would concatenate the file name with the "c:\Folder" & Me.PDFFileName.

Application.Followhyperlink "C:\folder\docname.pdf"

Will there only be 1 PDF file per record in your table?

[rebfein]

Hi Micron,

1. Meaning the scanned documents are in a file folder (Scanned) within the 'ECO folder' on the server, that also houses the ECO Database.
2. The hyperlink is linking to a scanned version of the ECO. The current tables only hold 1st level information (ECOTable, ModelRevTable, PartsTable, DetailTable, ScannedTable, and PartsTable). For more in depth information, I want my boss to be able to click on a button or the URL and open the .pdf version in another window.

[rebfein]

Bulzie,

"Will there only be 1 PDF file per record in your table?"

Thank you for the info, I'll experiment with my test db later this weekend.

[rebfein]

Thank you Stephen92,

Again, I'll look into this, this weekend.