473,769 Members | 2,359 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1815
"Jack-of-all-traits" <no*****@noemai laccount.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
10535
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 fields. My question is how do I write the logic so it only includes the fields in the search criteria where the user has entered anything.
5
3002
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 (a wicked phrase). Some but not all of the words of that phrase exist in my website. I reported it and they removed the link but did not give explanations.
8
2060
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 the page should be indexed and seen by robots and which elements are simply page furniture and it is safe to ignore or not cache (e.g. adverts).
1
1791
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 application know the part number the user typed into the Yahoo search box. I would like to use that part number to query our database and present a dynamic web
39
4409
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 authors of content subconsciously mention the keywords "lately and noticed" within the same brief sentence, the reader may infer "an unintended message" through the process of "inferential scanning;" a method of noting "semantic anomalies" which may...
9
1694
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 restrict access to these pages to everyone except a few individuals. Is there a way to add a password to a subdirectory so that anyone trying to access these pages will have to input the correct password in order to view them? Thanks.
5
1291
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 searching - and whether I need to do anything on my pages to help with search requests? Thanks
16
2136
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 have no sensible place to report them and no way to prevent the same problem from happening over-and-over in multiple sites around the world. That idea simply doesn't work. But how about this one. Suppose we have all of those search engine...
0
2463
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 good search engines are there like Google, Yahoo and Live to name few of them. Though this search engines have extremely efficient, complex and beautiful algorithms designed by gems of the industry, but still they may not deliver best results for...
0
9586
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9423
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10210
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9990
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9861
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7406
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6672
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5298
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3956
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.