Bruce Bruen
bbruen at bigpond.com
Wed Jun 11 07:56:14 CDT 2003
Shamil, Gustav, Darren and Jim (and all youse uzzer guys!) Thanks for the info. I had come up with Shamil's idea of forcing the object as per my out-of-line message. It's interesting to note that once I did force it that way, I added a second command button using the raw navigate on the control - and it works! Go figure????? :-} I am using the control in AXP on XP/SP1 (IE 6.0.28.. Shdocvw.dll ver 6.00.2800.1106 (xpsp1.020828-1920))- so the cut paste method wasn't necessary, but I guess all the gliches are still not out. Its an interesting beast - given that shdocvw, from my reading, is the IE "engine" that lets you have office apps inside IE... And it works the other way around as well. Its also very powerful, almost... I cant imagine a need for a MyComputer explorer inside an app, but there it is and it works, almost... I can see it could be possible to use .URLLocation, .document and the beforeNavigate events to do some fancy footwork. So, having given them (the yewsers) the tool to automatically grab html pages, parse them and present the info in Access forms, and now given them the view of the original page (on demand) where the data came from, I wonder what the buggers will want next! Thanks again. Bruce -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil Salakhetdinov Sent: Wednesday, June 11, 2003 9:10 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Displaying web page in a form > Don't ask us why, but this works! Yes, Gustav - you're right - this is how I did also manage to work it but I forgot :) - sample is here: http://www.smsconsulting.spb.ru/shamil_s/download/web97.zip (25 707 bytes) And writing: Me.WebBrowser2.Object.Navigate "http://www.microsoft.com" i.e. using .Object. is a must... Shamil ----- Original Message ----- From: "Gustav Brock" <gustav at cactus.dk> To: <accessd at databaseadvisors.com> Sent: Wednesday, June 11, 2003 2:37 PM Subject: Re: [AccessD] Displaying web page in a form > Hi Bruce > > >From IMATips 2000-07-25: > > --- > Avoid errors with the browser control in Access forms (97) > > If you've ever tried to use the Microsoft Web Browser control in an > Access 97 form, you may have been greeted with the error messsage > "There is no object in this control," when you tried to view the form. > This is because Access 97 isn't compatible with an updated DLL that > was introduced with IE 4.0. Fortunately, the problem is easy to fix. > Once you draw your browser control on the form, select it and press > [Ctrl]X to cut it. Then, immediately press [Ctrl]V to paste it back on > the form. Reposition the browser and you'll find that you can now open > the form without any errors. Don't ask us why, but this works! > --- > > And David SDC (<info at sdconsult.com.au>) 2002-10-11: > > --- > I solved this problem some years ago and gave it to Ken Getz who > included it in Access Adviser magazine. The trick is to add the > browser object to your form, then drag it to the required size. Having > sized it right, now copy it to the clipboard (control X) and then > paste it back to your form (Control V). It will now keep its size. You > can only do this once. To set to a different size, start from scratch > by pasting a new control. I discovered this approach by accident, but > think it is to do with getting two independent programs (Access and > Active X) to agree on a setting at the same time. It works with other > active X objects also. > --- > > /gustav > > > > Hmm, > > > Referenced OK > > (Registered OK) > > Inserted OK > > But... > > Me.actx_WebBrowser.navigate "some url" > > gives runtime error 438 "Object doesn't support this > > property or method" > > > Any ideas? > > > Tia > > Bruce > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren > > DICK > > Sent: Wednesday, June 11, 2003 4:54 PM > > To: accessd at databaseadvisors.com > > Subject: Re: [AccessD] Displaying web page in a form > > > > Hi Bruce > > Just like Jim said > > Reference the shdocvw.dll in the references. > > (It will show up in the list as Microsoft Internet controls) > > > Then from your long list of available ActiveX objects find one > > called Microsoft web browser. Insert that onto a form and call it > > say...actX_WebBrowser > > > then code will trigger it will be... Me.actX_WebBrowser.navigate > > http://www.microsoft.com > > > Hope this helps > > > Darren > > _______________________________________________ > 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