Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Hyperlink searching

Discussion in 'Information Technology' started by Matt, Sheffield, UK, Jul 28, 2006.

  1. Matt, Sheffield, UK

    Matt, Sheffield, UK
    Expand Collapse
    Guest

    I have a field on a table which is a hyperlink to a folder on our system, I
    want to run a query that only selects certain submissions that have this
    hyperlink in a certain folder ie

    archive/folder1/ - I want it to find these
    business/folder2/ - I dont want to find these.

    i thought I might be able to add the field to a query and use the criteria
    to specify the first part of the link 'archive' but it doesn't find anything,
    are there hot keys or anything i could use in the query criteria so access
    doesn;t matter whats after the initial match for 'archive'.

    Any ideas anyone, thanks
     
  2. Loading...

    Similar Threads Forum Date
    World War 1 Sikh-Canadian Pioneers: Still Searching for Our Sikh War Heroes History of Sikhism Feb 20, 2011
    Sikh News US to begin searching Sikh turbans (Bangkok Post) Breaking News Sep 3, 2007
    Sikh News Sikh community condemns policy on searching turbans (Oakland Tribune) Breaking News Aug 29, 2007
    Searching for an answer Spiritual Articles Mar 22, 2006
    Soul-searching Doctors Find Life After Death Interfaith Dialogues Nov 15, 2004

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Use

    Like "*archive/*"

    as your criteria.

    (I believe the first asterisk is necessary, as I suspect you've got
    information in front of the folder name. If you don't, try it without that
    first asterisk)

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    <Matt>; <Sheffield>; "UK" <MattSheffieldUK@discussions.microsoft.com> wrote
    in message news:984B1C1A-AC69-4A05-AAD4-3E42E75D8BFA@microsoft.com...
    > I have a field on a table which is a hyperlink to a folder on our system,

    I
    > want to run a query that only selects certain submissions that have this
    > hyperlink in a certain folder ie
    >
    > archive/folder1/ - I want it to find these
    > business/folder2/ - I dont want to find these.
    >
    > i thought I might be able to add the field to a query and use the criteria
    > to specify the first part of the link 'archive' but it doesn't find

    anything,
    > are there hot keys or anything i could use in the query criteria so access
    > doesn;t matter whats after the initial match for 'archive'.
    >
    > Any ideas anyone, thanks
     

Share This Page