Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010
    Posts
    4

    Unanswered: Show attachment based on table data

    Is it possible to show a picture attachement in a form based on table data?

    For example, I want to show a different picture based on a number in a table. The number would refer to a shelf where an item is located, i.e.; 1 - 12. I would like to show a graphic that highlights the shelf that corresponds to the number. I don't want to attach a picture for each record. I just want to choose the location number and have Access automatically display the correct image.

    Is this possible?

    Thanks,

    Todd

  2. #2
    Join Date
    May 2010
    Posts
    601
    Todd,

    That should be possible.

    Here is an example that should how to use a image file and display on a form. This can easily be modified to do what you want.

    See:
    Picture in Database
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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