Results 1 to 7 of 7
  1. #1
    kelann is offline Learning ... thank you!!
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    132

    "OLE Object" Fields - More user-friendly way of working with them

    Hi, all!



    I have an OLE object field (OrgAttachment).
    On my form (OrgAddF), this field is supposed to let them add an attachment -- perhaps an info flyer that is used by the organization.

    Is there a way to put this on a form thatis more user-friendly than the "right-click, select a file type from a long list of strangeness, and, after uploading, get a weird sort of icon" method? Something like an "Add attachment" button that brings up a "browse" dialog, and after the item is located and selected, it lists the file name of the item?

    Thanks for any thoughts!!

    --ak

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,594
    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
    kelann is offline Learning ... thank you!!
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    132
    Thanks, June, but, actually, they just confuse the hell out of me!

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,594
    Those are just about the best references I have seen, especially the one about code for attachment field.
    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.

  5. #5
    kelann is offline Learning ... thank you!!
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    132
    Thank you! I will be sure to read them in detail and maybe, with reading though them, I will pick up some stuff ... then I'll do it again and pick up a bit more!!

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,594
    Keep in mind, the friendlier the interface, the more code needed. If you aren't already well-versed in VBA programming, this effort will be quite a leap. So what do you mean by 'Advanced Beginner'? Have you been developing with VBA?
    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.

  7. #7
    kelann is offline Learning ... thank you!!
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    132
    Thanks, June! Quite honestly, I'm not sure what the breakdowns would be, but even though I've done a bunch on my own in this database, I'm thinking, based upon what I've learned from you all, that Proto-Beginner is probably more accurate!!!!!

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

Similar Threads

  1. Replies: 1
    Last Post: 04-10-2012, 08:48 AM
  2. Replies: 0
    Last Post: 02-20-2012, 04:57 PM
  3. Replies: 0
    Last Post: 01-11-2012, 12:34 PM
  4. Replies: 9
    Last Post: 05-19-2011, 12:08 PM
  5. Replies: 1
    Last Post: 04-14-2011, 03:46 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