[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.html
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