Jim Lawrence
accessd at shaw.ca
Fri Aug 16 02:51:27 CDT 2013
:-) Jim ----- Original Message ----- From: "Stuart McLachlan" <stuart at lexacorp.com.pg> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, August 15, 2013 3:46:44 PM Subject: Re: [AccessD] A2003 - Clear Web Browser Control Contents IOW your situation is improving. There are more known unknowns and less unknown unknowns. :-) -- Stuart On 15 Aug 2013 at 10:23, Jim Lawrence wrote: > I understand...the more I know, the more I know how little I know. ;-) > > Jim > > ----- Original Message ----- > From: "Darren" <darren at activebilling.com.au> > To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> > Sent: Wednesday, August 14, 2013 11:45:27 PM > Subject: Re: [AccessD] A2003 - Clear Web Browser Control Contents > > Hi Jim > Assume nothing - I am a luddite and hack > Darren > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence > Sent: Thursday, 15 August 2013 11:00 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] A2003 - Clear Web Browser Control Contents > > Hi Darren: > > Can I assume you have referred to Microsoft's explanation of how the control works and have checked how they implement it? > > http://msdn.microsoft.com/en-us/library/aa752044(v=vs.85).aspx > > Jim > > ----- Original Message ----- > From: "Darren" <darren at activebilling.com.au> > To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> > Sent: Wednesday, August 14, 2013 4:41:57 PM > Subject: Re: [AccessD] A2003 - Clear Web Browser Control Contents > > Hi Jim > Thanks for the reply. > Taking the focus away from the BrowserControl and doing a form refresh changes nothing. > The browser control still 'holds the file open' - has a handle to it. > I needed a way to just get the browser control to return to a state of holding open NO file, so I could just drag and drop another. > No biggie I have a clunky work around in place - it'll have to do. > > Again - Many Thanks > > DArren > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence > Sent: Wednesday, 14 August 2013 12:54 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] A2003 - Clear Web Browser Control Contents > > Off the top...would something as simple as On Lost Focus > me.refresh work? > > Jim > > ----- Original Message ----- > From: "Darren" <darren at activebilling.com.au> > To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> > Sent: Tuesday, August 13, 2013 6:22:32 PM > Subject: [AccessD] A2003 - Clear Web Browser Control Contents > > Hi All, > I have a web browser control on a form that allows users to 'drag' files from their desktops to get the file name of the 'dropped' file. > Works a treat. > But it seems I can only offer users one go, as I then have to close the form to 'reset' the contents of the Browser control. > As once a file has been 'opened' in the browser control (E.g. a CSV file) users are not permitted to 'drag' a second or subsequent file to that browser control. > I have tried Me. actXWebBrowserControl.Navigate "" and a few other things but to no avail and with varying error messages. > All I'm really using it for is to get the file name of the 'dropped' file and then run other tasks that' import' this file, once the file name is known. > Being able to see the contents of the file is irrelevant and I'd like to be able to simply drag and drop files to the browser control one after the other. > > Any thoughts? > > Here's my Code so far that gets the file name and then I run other tasks after that - this will wrap so be aware > > Private Sub actXWebBrowserControl_BeforeNavigate2(ByVal pDisp As Object, URL As Variant, Flags As Variant, TargetFrameName As Variant, PostData As Variant, Headers As Variant, Cancel As Boolean) Me.txtAssumedFilePath = URL MsgBox me.txtAssumedFilePath > > End Sub > > > -- > 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 > > > -- > 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