473,325 Members | 2,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

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

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
1 1790
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: JP SIngh | last post by:
Hi There I am creating a search page and need help writing the code to build the sql string. I have 3 fields on the main page which a user can choose to enter search terms in any of the 3...
5
by: George | last post by:
Hi, Anyone has the background for explaining? I have made a search on my name and I have got a link to another search engine. The link's title was the search phrase for the other search engine...
8
by: Craig Cockburn | last post by:
Hi I'm aware of the use of robots.txt and the use of <META NAME="ROBOTS" CONTENT="index,follow"> However, what would be more useful is to be able to control within a page which elements of...
1
by: disaia | last post by:
2 problems: Example: If a person types in a part number into Yahoo: 1. Is there a way for Yahoo to list your web site as one of the results. 2. If the user clicks on your link, can your web...
39
by: Noticedtrends | last post by:
Can inference search-engines narrow-down the number of often irrelevant results, by using specific keywords; for the purpose of discerning emerging social & business trends? For example, if...
9
by: Victor & Toni Jo Friedmann | last post by:
I have a home page with Verizon. Within this home page I have several sub-directories with their own associated pages. One of these subdirectories has personal contact information and I wish to...
5
by: Mantorok | last post by:
Hi Can anyone advise me on how I can get my asp.net site to be searchable from search sites such as Google? I have absolutely no idea where start, where to go to get the site involved in...
16
by: Kent Feiler | last post by:
If I understand the general direction of recent posts, the idea is to improve the quality of html/css by soliciting help from the various browsers. Browsers can certainly detect problems but they...
0
by: passion | last post by:
"Specialized Search Engines" along with Google Search Capability (2 in 1): http://specialized-search-engines.blogspot.com/ Billions of websites are available on the web and plenty of extremely...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.