Darren - Active Billing
darren at activebilling.com.au
Tue Dec 22 09:38:37 CST 2009
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