Results 1 to 3 of 3
  1. #1
    Bazsl is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2016
    Posts
    47

    How know if there are multiple images attached?


    I have a form with an image control displaying JPEG images from an attachment field in the table. How can I make the user aware that there is more than one image attached to a row in the table? If I click in the image control a floating toolbar containing a left arrow, a right arrow and a paperclip appears. If the right arrow is enabled the user knows that there are multiple images. Is there some way to let the user know that there are multiple images without the user having to click the image control? Thanks.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    The attachments are a recordset. Create a recordset and get the count.

    set rst= currentdb.openrecordset(tbl.attachFld)
    msgbox rst.recordcount

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

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

Similar Threads

  1. Multiple Images Per Record
    By Mandody in forum Access
    Replies: 10
    Last Post: 04-07-2015, 05:15 AM
  2. Replies: 2
    Last Post: 06-24-2013, 10:41 AM
  3. Placing multiple images in a form?
    By snowboarder234 in forum Forms
    Replies: 1
    Last Post: 04-30-2013, 05:42 PM
  4. Multiple invoices attached single job
    By lpkorn423 in forum Reports
    Replies: 3
    Last Post: 07-18-2012, 12:30 PM
  5. Multiple Images per row?
    By Mnelson in forum Access
    Replies: 1
    Last Post: 07-05-2012, 09:10 AM

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