Drag and drop in VBA (Access 2003). Is it possible?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a functioning Access 2003 database with an ImageControl which loads
and displays jpg images stored in a directory. Data and associated jpg files
change every month.

Currently, to display the image I have to manually rename each picture in
windows Explorer to match the record ID (or other field) in the data base so
that the right image is loaded and displayed. This is a long and tedious
process....

I would like instead to be able to simply drag a jpg file from Explorer and
drop it onto the Access DB form at runtime. When I release the mouse button,
I would need the system to automatically rename the jpg file to be the same
as the Record ID currently displayed and show the image.

The main problem is that I don't find any reference to Drag and Drop in the
VBA methods. Is that true or am I missing something ?!!@#?
If what I need is feasible, is there a code snippet somewhere to help me out?
Thank you all.
 
Access doesn't have drag-and-drop built into it.

Take a look, though, at what I wrote for Pinnacle Publication's Smart Access
in the Jan and Feb 2004 issues. You can download the columns (plus
accompanying sample databases) for free at
http://www.accessmvp.com/djsteele/DSNLessLinks.html

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



"(e-mail address removed)"
 
Back
Top