hyperlink data not transferring to destination table

[markjkubicki]

I'm inserting records that includes a hyperlink field from 1 table into another that include a hyperlink field of the same name. In the source table, the hyperlink behaves correctly; however, when inserted into the destination table, it does not. Editing the hyperlink in the destination table shows that the link was copied, but with no text and no address (!?)



any thoughts whatsoever would be greatly appreciated,
mark

------------------------
Dim sSQL As String
sSQL = "INSERT INTO tbeAdditionalPages (type, printCatalogSheet, BaseCatalogSheet, CatalogSheetLink, PrintOrder, IsMountingDetail) " & _
"SELECT '" & Forms![frmSpec].[Type] & "', true, true, '#' & CatalogSheetLink, printOrder, false " & _
"FROM FixtureCatalogsPages " & _
"WHERE Manufacturer = '" & Forms![frmSpec].Manufacturer.Value & _
"' and CatalogNumber = '" & Forms![frmSpec].CatalogNo.Value & "';"
CurrentDb().Execute sSQL, dbFailOnError

[ajetrumpet]

Allen Browne may have already investigated it. Here is a forum post from him:

http://www.pcreview.co.uk/forums/thread-2623505.php

may want to check that out.

[markjkubicki]

so I went to your link ... (thank you) and revised my code to include as follows.
The result was: now the destination field has text, but still no address.

sSQL = "INSERT INTO ... 'text#' & CatalogSheetLink & '#' ...
CurrentDb().Execute sSQL, dbFailOnError

----------------------
I then revised it to:
'text#' & CatalogSheetLink.address & '#'

this resulted in a error.

[ajetrumpet]

I really don't have any experience doing this Mark. I hope someone else here can help you out. good luck with it.