By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,209 Members | 1,100 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,209 IT Pros & Developers. It's quick & easy.

how can i get access to use search engines and return simple results?

P: n/a
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 ?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Jack-of-all-traits" <no*****@noemailaccount.info> wrote:
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.
I have seen a link at google.com which mentions API calls and such. Google Web APIs
http://www.google.ca/apis/
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 ?


Yup, you need to move through your table using a recordset based on a query.
See the Sample Code illustrating looping through a DAO recordset page at the Access
Email FAQ at http://www.granite.ab.ca/access/email/recordsetloop.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.