UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Traversing And Updating Pages Using The Webbrowser Control, Access 2010    
 
   
adamsgj
post Aug 21 2015, 11:22 PM
Post#1



Posts: 53
Joined: 29-March 14
From: Sunny Brisbane Australia


There is an apparent lack on the net of working examples of VBA code that interact with web sites, traversing pages and updating fields. While I'm appreciative of the code snippets I found on UA and elsewhere along with some specific help at times from the UA community, this meant that there was a lot of trial and error in fully developing my solution even though I've been writing VBA and VB for a long time. Intellisense also isn't that helpful in exposing all the methods and properties and nor is MS Technet particularly useful for VBA (the are significant differences in implementing a VBA vs VB solution).

I offer the attached which was written for a particular web site but is easily adaptable to suit variations providing page flow is predictable. Of course there may be better and more efficient ways of coding than what I offer but it works for us and volumes are, and will remain, low. Hopefully it will give any members wanting to develop something similar a head start.

The form uses the native webbrowser control. The code should be sufficiently commented for developers to follow but I'm willing to answer specific questions if required.
Attached File(s)
Attached File  WBBrowser.zip ( 1.27MB )Number of downloads: 148
 
Go to the top of the page
 
Pleasure
post Sep 13 2015, 10:05 AM
Post#2



Posts: 257
Joined: 1-July 05
From: Greece


Is it possible to have a 2003 version ?
Thank you
Go to the top of the page
 
adamsgj
post Sep 13 2015, 06:21 PM
Post#3



Posts: 53
Joined: 29-March 14
From: Sunny Brisbane Australia


Microsoft stopped supporting Office 2003 last year and I can't think of a reason why users should not have migrated to later, supported, releases except for the cost. The Native Webbrowser control was introduced in Access 2010, I think, so clearly will not work for releases prior to that. How you would achieve the same functionality in earlier releases is something I'm not inclined to research. The basic flow of the code should be the same I would have thought. Good luck.
Go to the top of the page
 
zoisalexis
post Sep 21 2015, 02:56 PM
Post#4



Posts: 85
Joined: 21-December 05



#Pleasure
There is a sample of what you need here....
http://www.UtterAccess.com/forum/activex-w...r-t1059830.html

HTH
Go to the top of the page
 
Squirrel1970
post Oct 2 2015, 07:32 AM
Post#5



Posts: 206
Joined: 11-July 09
From: Boston, MA


I tried downloading your webbrowser zip file and when I try to open the DB it says it's an unrecognized database format. Can you try posting it again please?
Go to the top of the page
 
HiTechCoach
post Oct 3 2015, 02:39 PM
Post#6


UtterAccess VIP
Posts: 18,993
Joined: 29-September 03
From: Oklahoma City, Oklahoma


Squirrel1970, it require Access 2010 or later. It uses the new native Web Browser control that was added in 2010. It was able to open it Access 201o and 2013 . What version of Access are you running?
Go to the top of the page
 
adamsgj
post Oct 3 2015, 07:52 PM
Post#7



Posts: 53
Joined: 29-March 14
From: Sunny Brisbane Australia


Yep A10 or later. Here is the latest version with a couple of minor changes
Attached File(s)
Attached File  WBBrowser.zip ( 1.27MB )Number of downloads: 122
 
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 01:35 PM