Results 1 to 4 of 4
  1. #1
    davidf is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2012
    Posts
    2

    Question Show Images linked to Numerical field in multiple rows of a table

    HI I want to be able to link and show a small image based on the numerical field in the adjacent column of the table

    eg if table column had No 1 in it it would show image-1, if it had No 2 in the table it would show image-2 ( see tabkle below)
    report currently pulls out all data required - just dont know how to get the number thats pulled out to link and show an image as well as number

    Using MS access 2007



    Ref No Name Level Image - would show in this column Date
    002 A Bloggs 3 < based on number being shown here
    908 B. donaldson 2 < eg image 2
    568 Fred. Jones 4 < image 4
    984 Albert Walker 1 < image 1
    452 jone zebra 1 < image 1

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    These images are stored in external folder, not an attachment field? Are the images similarly named, like: Level1.jpg, Level2.jpg, etc.

    Use an Image control with a conditional expression in the ControlSource.

    ="PathToFolder\Level" & [Level] & ".jpg"

    PathToFolder example:
    "R:\Photos"

    If this is a multi-user db, would require every user to have R: drive mapped on their computer.

    I just tested UNC (universal naming convention) path reference which uses server name as reference: "\\servername\path\filename"
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    davidf is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2012
    Posts
    2

    Many thanks for the reply - but ...

    Many thanks for the reply below - but I didnt quite follow it .

    where would you suggest I store the images ? they havent been put anywhere yet
    how do I then add then into the report ?
    does this code go into the qsel file or another file ?


    thanks

    David



    Quote Originally Posted by June7 View Post
    These images are stored in external folder, not an attachment field? Are the images similarly named, like: Level1.jpg, Level2.jpg, etc.

    Use an Image control with a conditional expression in the ControlSource.

    ="PathToFolder\Level" & [Level] & ".jpg"

    PathToFolder example:
    "R:\Photos"

    If this is a multi-user db, would require every user to have R: drive mapped on their computer.

    I just tested UNC (universal naming convention) path reference which uses server name as reference: "\\servername\path\filename"

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Place images in a folder located whereever you want.

    Create an Image control on the report. The expression would go in the ControlSource property. This establishes a dynamic link to the images so that each record will display image relevant to it.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Limit rows of linked excel table
    By FJM in forum Access
    Replies: 1
    Last Post: 06-15-2012, 02:43 PM
  2. Replies: 0
    Last Post: 04-04-2012, 12:42 PM
  3. Replies: 2
    Last Post: 11-05-2010, 04:47 AM
  4. Replies: 3
    Last Post: 08-17-2010, 02:49 PM
  5. Replies: 17
    Last Post: 08-26-2009, 11:27 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums