Results 1 to 6 of 6
  1. #1
    JayX is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    62

    Exclamation Attachments

    When creating an attachment is there a way for it to show the file name along with the Image/Icon?

  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,929
    Show it where - on the table? No.
    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
    JayX is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    62
    no In the form view in an attachment box

  4. #4
    JayX is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    62
    This is what it looks like now but I'd like the file name to appear next to the Image/Icon...any suggestions?

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Here is what I could make work. Form in Design view, drag the Attachment field from the field list to the form. Create a textbox with ControlSource: =yourAttachmentFieldName.FileName(0)

    Assumes only one item in the Attachment field.
    See http://msdn.microsoft.com/en-us/library/ff193567.aspx
    http://www.cimaware.com/resources/article_135.html
    http://office.microsoft.com/en-us/ac...001213852.aspx
    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.

  6. #6
    JayX is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    62
    works great...thanks!

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

Similar Threads

  1. attachments
    By chiefmsb in forum Forms
    Replies: 3
    Last Post: 08-08-2011, 11:25 AM
  2. attachments
    By chiefmsb in forum Forms
    Replies: 0
    Last Post: 07-12-2011, 07:32 AM
  3. attachments
    By chiefmsb in forum Access
    Replies: 0
    Last Post: 07-10-2011, 07:38 PM
  4. attachments
    By chiefmsb in forum Access
    Replies: 0
    Last Post: 07-08-2011, 03:56 PM
  5. attachments
    By chiefmsb in forum Access
    Replies: 1
    Last Post: 06-28-2011, 04:20 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