Jim Lawrence
accessd at shaw.ca
Thu Aug 15 11:23:14 CDT 2013
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