[AccessD] A2K:Get file name after drag and drop

I've verified that the sample code at the link http://digitalpbk.blogspot.com/2006/12/drag-n-drop-files-from-explorer-to-vb.html posted earlier works in A2k.  You've got to be careful when stepping through code and working in the immediated window some times when working with API calls as Windows is somewhat sensitive when you return or set unexpected values, or, if you cover a window that is getting mouse messages with a code window.  Once implemented and debugged, it is stable in A2k on my Vista laptop.  I had a bit of a fuss attempting to pass a reference to 'me.Form' and the application crashed a few times until I just passed 'me'.  The A2003 version I've got running uses a subform that required me to pass me.parentform.subform.Form whereas the example I worked out in A2K used a file list directly on a form rather than a sub form.

 

I've deployed a version of the code in the 2003 environment and users are happy with the new convenience.  No reported issues a few days after deployment.

 

Jürgen Welz


> > > From: darren at activebilling.com.au
> > > To: accessd at databaseadvisors.com
> > > Date: Sat, 26 Dec 2009 20:14:59 +1100
> > > Subject: Re: [AccessD] A2K:Get file name after drag and drop_SecondSend
> > > 
> > > Hi Jurgen
> > > When you say great code are you referring to the link in Michael's post
> below
> > or
> > > was there some code or example in your post I can't see?
> > > 
> > > Many thanks
> > > 
> > > Darren
> > > 
> > > 
> > > -----Original Message-----
> > > From: accessd-bounces at databaseadvisors.com
> > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jurgen Welz
> > > Sent: Wednesday, 23 December 2009 8:46 AM
> > > To: accessd at databaseadvisors.com
> > > Subject: Re: [AccessD] A2K:Get file name after drag and drop_SecondSend
> > > 
> > > 
> > > Great Code. Works well in Access 2003. Properties on the VBA Editor Help ->
> > > About screen in this version of Access shows VB 6.3. I added the form code
> to
> > a
> > > sub form Filelist common to several forms in an application. It stores the
> > full
> > > file path and name in the strFilename variable of the Public Dropped
> procedure
> > > as written.
> > > 
> > > 
> > > 
> > > This procedure will allow me to directly copy files to one or more of the
> > > folders displayed in my file list subform using file procedures in VBA. Very
> > > Nice!
> > > 
> > > Ciao 
> > > 
> > > Jürgen Welz 
> > > 
> > > Edmonton, Alberta 
> > > 
> > > jwelz at hotmail.com
 		 	   		  
_________________________________________________________________