Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    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:\manc\payr\tido\12.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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    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:\manc\payr\tido\12.txt#

    or

    s:\manc\payr\tido\12.txt#s:\manc\payr\tido\12.txt#

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    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.

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='786507' date='28-Jul-2009 11:54']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:\manc\payr\tido\12.txt#

    or

    s:\manc\payr\tido\12.txt#s:\manc\payr\tido\12.txt#[/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?

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    [quote name='ase001' post='786510' date='28-Jul-2009 11:59']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?[/quote]
    Thanks for the pointer Hans, just updated code and works a treat with # added as part of the sql insert.

    Cheers
    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •