Darren - Active Billing
darren at activebilling.com.au
Tue Dec 22 08:43:47 CST 2009
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