Results 1 to 3 of 3
  1. #1
    skyatis is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    11

    Small images in report

    I would like to include some icons in my report.

    Heres a simplified version of what Im trying to achieve, so far without success:

    tblAnimals



    Category
    Breed
    Quantity
    Bird Parrot 2
    Mammal Hamster 12
    Reptile Lizard 5
    Bird Budgie 9
    Mammal Rabbit 5

    On my report I want to replace the
    Category textfield with a suitable icon; a small picture of a bird, mammal or reptile.
    If at all possible I want to store the icons within thedatabase (eg in a table with CategoryName and CategoryPic fields); they wont take up much space and Idont want to be referencing externalfiles as this adds complexity when the database is packaged up and distributedto users around the organization.
    I tried adding them to the image gallery in a dummy form butmy report did not display the icons, just an empty box.
    I also tried using a table with an OLE Object field but this only displays on the report as a placeholder with the name of the icon file.
    What would be the most effective way of storing, referencing and displaying these icons?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Use the OLE field. In a form,drop the image control field on the form.
    bind it to the ole field,
    then in view mode, on record 'parrot',
    find a photo of a parrot,
    copy it, right click on the Image box on the form
    paste.

    now the parrot will show in the report or form.

  3. #3
    skyatis is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    11
    Thanks for that ranman! I needed to open the image in photos or similar and copy it fromthere, rather than copying the file from Windows Explorer.

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

Similar Threads

  1. Small Report Annoyances
    By james28 in forum Reports
    Replies: 24
    Last Post: 03-09-2014, 07:34 PM
  2. Display images in a calendar report?
    By hinsdale1 in forum Reports
    Replies: 5
    Last Post: 04-25-2013, 01:37 PM
  3. Print Linked Images in a Report
    By bosve73 in forum Reports
    Replies: 4
    Last Post: 02-02-2012, 11:12 AM
  4. Replies: 17
    Last Post: 08-26-2009, 11:27 AM
  5. Images in report
    By rudyp in forum Reports
    Replies: 1
    Last Post: 03-24-2009, 09:51 PM

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