An update query problem

[CQCDave]

I have a table warrentyregristration that has a hyperlink field. I am attempting to run an update query to update all records. There are 18,500 records in that table.


These records represent the warranty information that customers have send in to our company after purchasing our product. These were mailed/faxed/emailed to our Sales dept. The scanned these into a pdf file and thy reside on the server. Any issues from the customers were noted on the pdf files by use of the "sticky note" on the pdf, I was able to extract all the file names from the directory remove the .pdf and import these records into table.
The users access the data through a form bound to the table. I want to update the hyperlink field to the corresponding pdf file on the server. The server info is as follows: \\w2008svr\kit master files\. In the vehicleregistration table these is a field VIN#. I want to combine the server info and VIN# data and add .pdf at the end. I have tried UPDATE warrantyregristration SET warrantyregristration.Hyperlink = "\\w2008svr\kit master files\ [WarrantyRegristration]![VIN#] .pdf"; But that shows up the field like this \\w2008svr\kit master files\ [WarrantyRegristration]![VIN

Any help would be appreciated. I am using Acess 2010.

[pbaldy]

I don't use hyperlink fields, but with a text field you'd concatenate:

"\\w2008svr\kit master files\" & [WarrantyRegristration]![VIN#] &".pdf"

[CQCDave]

That did update the field, it displays the correct address. But it will not work, when you click on the hyperlink, the edit hyperlink box opens up and the address is listed in the Text to display, but not the Address if i copy and paste to the Address field it will work. In the table the hyperlink field is populated.

[pbaldy]

Not sure how to get around that. I don't like the hyperlink field, as what you see and what it actually stores are different. I just use plain text fields and use FollowHyperlink or whatever to open the file.