Access 2007 Hyperlink

Topic

New Reply

Access 2007.
Table has a field named FPath which is populated from code to include the path of a file based on the users selection.
The table is updated with a full list of files within a selected folder.
I had the links working yesterday and the only change I made was to include a ‘DateAdded’ field to indicate when the record was added.
The field still appears in Hyperlink format (blue, underlined) and the cursor changes to Hand on hovering over the field.
But the link no longer opens the file ref.
For instance:
The field contains s:mancpayrtido12.txt
This should open up the text file 12.txt when clicked.

The field is still defined as
Data Type: Hyperlink
Unique

Any pointers for settings?
Thanks
Alan

Reply | Quote

Replies

If you open the table, go to the FPPath field and press F2, what do you see? There should be # characters around the path/filename, e.g.

#s:mancpayrtido12.txt#

or

s:mancpayrtido12.txt#s:mancpayrtido12.txt#

Reply | Quote

If you open the table, go to the FPPath field and press F2, what do you see? There should be # characters around the path/filename, e.g.

#s:mancpayrtido12.txt#

or

s:mancpayrtido12.txt#s:mancpayrtido12.txt#

Nope, just plain text when F2 selected.
Can I add the # as part of the update code? or is it as excel array formula and only relevant when entered correctly?

Reply | Quote

Nope, just plain text when F2 selected.
Can I add the # as part of the update code? or is it as excel array formula and only relevant when entered correctly?

Thanks for the pointer Hans, just updated code and works a treat with # added as part of the sql insert.

Cheers
Alan

Reply | Quote

Bit more strangeness.
I added a new record manually and typed in the original file path/name and the record was not prevented from being added…even though the field is set to Primary-No Duplicates.
The hyperlink did work on this field though.

Reply | Quote