Results 1 to 8 of 8
  1. #1
    togo is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2012
    Posts
    83

    Drag and drop images into form

    We want a catalog - style report but the boss is going to want drag and drop. The tables are based on a link to an image. Is this possible?

  2. #2
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Hi -

    First, if the tables are linked to images, what would you be dragging and to where? Second, reports are static, i.e. not editable (after they have been produced).

    Can you give more detail as to what you need to do?

    John

  3. #3
    Max D's Avatar
    Max D is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    63
    TOGO: yep, you need to provide more details really.

    Just to mention, my AccessImagine component supports image drag-and-drop to the form and works with linked images.

  4. #4
    togo is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2012
    Posts
    83
    dragging image files from a folder onto an access form, and then have the image paths extracted at that point and inserted into table. The report will display whatever images are linked in the table. Also I'm not sure why we need to worry about editability of reports, there are a multitude of ways around that.

  5. #5
    Max D's Avatar
    Max D is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    63
    Ok, its like I supposed. Then AccessImagine is the fastest way to implement this without getting your hands "dirty".

    As alternative, you can write all this functionality with VBA (or find somewhere that code and tailor it to your needs).

  6. #6
    togo is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2012
    Posts
    83
    I see that accessImagine uses OLE objects, and I've been having trouble making them display on reports.

  7. #7
    Max D's Avatar
    Max D is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    63
    It supports seamless automatic external image storage also.
    Place AccessImagine on form, specify StoragePath property and bind it to some field for filenames.

    It will make all the rest of work.

  8. #8
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Hi -

    Given your description of your requirement, it might be easier to use the the MS Access interface to the File Dialog object to select the file, and then extract the required data from the file name returned to Access.

    Here are a couple of links I found. They refer to Windows XP, so the use in Windows 7 may be different:

    http://blogannath.blogspot.ca/2010/0...cks-using.html

    http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

    HTH

    John

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

Similar Threads

  1. API: Drag and Drop from Explorer to a text box
    By ybg1 in forum Programming
    Replies: 1
    Last Post: 01-02-2012, 02:23 PM
  2. Replies: 9
    Last Post: 05-30-2011, 12:08 PM
  3. Drag and Drop into Textbox
    By jagvent in forum Forms
    Replies: 1
    Last Post: 12-20-2010, 09:31 AM
  4. Drag and Drop Between Textboxes. Please Help!
    By kcpope in forum Programming
    Replies: 2
    Last Post: 10-19-2010, 05:03 PM
  5. Drag N Drop example between 2 listboxes
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-30-2010, 10:10 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