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

Hi Darren,

vba332 is for Access 97, IIRC.

Not sure what you're calling it for, but you'd need
to use FindWindow/FindWindowEx to get the handle
of the form and the control when it's clicked
(Dev Ashish has a trick for that, I recall)

Maybe you're right, there are wider, less slippery paths
to follow than this one.

-
Michael R Mattys
MapPoint and Database Dev
www.mattysconsulting.com
-
----- Original Message ----- 
From: "Darren - Active Billing" <darren at activebilling.com.au>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, December 22, 2009 10:38 AM
Subject: Re: [AccessD] A2K:Get file name after drag and drop_SecondSend


> Hi Matt
> Looks promising - I can get no further now - I keep getting an error
> File not found vba332.dll
> So I found a copy of vba332.dll on the net and put it in the local folder 
> of the
> dB. No good then dropped it into C:\Windows\System32 still no good
> Then in desperation I tried to register it via access but was told it 
> wasn't
> that sort of file
> I also then tried (in utter desperation) to create a reference to - that 
> too
> failed
> So sadly that's the end for me
>
> Any suggestions?
>
> Many thanks
>
> Darren
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike Mattys
> Sent: Wednesday, 23 December 2009 1:55 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] A2K:Get file name after drag and drop_SecondSend
>
> Darren,
>
> You might try here:
> http://digitalpbk.blogspot.com/2006/12/drag-n-drop-files-from-explorer-to-vb.htm
> l
> I looked through a few pages, this one looks pretty good.
> -
> Michael R Mattys
> MapPoint and Database Dev
> www.mattysconsulting.com
> -
> ----- Original Message ----- 
> From: "Darren - Active Billing" <darren at activebilling.com.au>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Tuesday, December 22, 2009 9:43 AM
> Subject: Re: [AccessD] A2K:Get file name after drag and drop_SecondSend
>
>
>> Hi john
>> Thanks for the reply
>> I want a client to drag and drop file onto a field on one of my forms
>> I want to know if Access can determine the name of the file that was
>> 'dropped'
>> on that form or field in some mouse up routine
>> So this is in order to get a value into MyControl.value
>>
>> Many thanks
>>
>> Darren
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
>> Sent: Wednesday, 23 December 2009 12:50 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] A2K:Get file name after drag and drop_SecondSend
>>
>> If the name is in a control, then MyControl.value should give you the
>> contents
>> of that control.
>>
>> Or am I missing something?
>>
>> John W. Colby
>> www.ColbyConsulting.com
>>
>>
>> Darren - Active Billing wrote:
>>> Hi team
>>>
>>> Merry Christmas to all
>>> I had no response on this one the first time I sent it through
>>> So here goes again :-)
>>> Many thanks in advance
>>>
>>> Darren
>>> ~~~~~~~~~~~~~~~~~~~~
>>>
>>> Hi team
>>>
>>> Does anyone know how I can determine the file name of a file after it 
>>> has
>>> been
>>> dragged from (say the desktop) to an RTF field I have on an Access form?
>>>
>>> Basically I be will writing a reasonably simple import routine for a
>> determined
>>> file type
>>>
>>> Normally I would have a text box on a form that stores the path and 
>>> allow
>> users
>>> to invoke a browse dialogue box.
>>>
>>> But I'd rather just let the user 'drag' the file and drop it onto a
>>> pre-determined place (The RTF Field) on one of my forms - get the file
>>> name
>> and
>>> then perform the import routine as if the file name was added to some
>>> field by
>>> the browse dialogue box
>>>
>>> Make sense?
>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com