This is a big problem and I really need help, no one seems to
know how to solve this problem.
I want to take the data from a record in a particular a field that
contains the names of generic products made up of 1 to 4 words
and search each record online, on a search engine such as the
google.com or altavista.com. Then also retain or record the
results given for the number of hits form the search engine
website... take the number of total hits and record it back into
my database in the field known as hits.
Eg.
My Field Data Contains the following: "Blue Windows"
So, instead of me phsically opening up explorer and typing
up the word "blue windows" into the google search box
on the google.com search engine home page, and then
pressing with the mouse the google search button to get
the results which is about 3,740 hits, then taking that
number 3,740 and typing it into my form window in
access under the field name "Hits" for the given record
I want this to be automated right from the access window
when I press a button on my form. I want to be able to
thus obtain the number of hits for each word searched
in my record, and do this automatically.
How can I do this, and what does it involve ? Can I
also do this so that access moves on to the next record
until all the record fields have been searched ?