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
> Using Google To Search Text In An Access Db, Access 2010    
post Aug 17 2019, 02:45 PM

Posts: 49
Joined: 18-April 09

I have an access data base where each record contains a memo field named "ServiceDescription". This field in each record is at least 300 text characters long and there are at least 700 records. I know that google has the ability to build a custom search tool. How can I marry the google custom search ability with MS Access, so that a user can enter four or five words into a text field on an access form, and Access will then build a report showing which records contain the text entered into the form? VBA would be preferred for this task.
This post has been edited by ronehrlich: Aug 17 2019, 02:48 PM
Go to the top of the page
post Aug 17 2019, 03:17 PM

UtterAccess VIP
Posts: 1,609
Joined: 4-June 18
From: Somerset, UK

No idea how you could use Google for this but my question is why bother?
You can build perfectly good search tools in Access to achieve what you want

Go to the top of the page
post Aug 17 2019, 04:25 PM

UA Admin
Posts: 35,690
Joined: 20-June 02
From: Newcastle, WA

I agree with Colin here. This seems like it might be more trouble than it's worth.

I have a sample accdb on my website which illustrates several ways to filter records in forms, including exactly this kind of "free text" search where you enter multiple search words in a text box, separated by commas. It then applies a search across the contents of several different fields in the tables. Check it out to see if you can't adapt and modify it for your project.

My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
post Aug 17 2019, 05:11 PM

UtterAccess Editor
Posts: 10,097
Joined: 7-December 09
From: St Augustine, FL

We've done similar for "AI" purposes (e.g., upload bulk medical notes of one particular provider to gauge the quality of their notekeeping, etc), but in this case the analysis you're looking for is quite simply basic search stuff.

In the case of analyzing data for quality in text, we would be sending data to the service for processing that we simply could not replicate ourselves (in this case we used AWS services rather than Google, but same idea). The key point being that the data was processed outside of our software.

In the case of searching, you need to be operating on data inside your software, and that is not feasible the way that these services are set up. That is, the services are generally made to operate on data given to them, rather than data being pulled into a system to operate on the system's data directly. Thus, each time you wanted to analyze data via 3rd party service, you would need to push all of your data to it. Generally speaking.

That said, custom google search functionality might be a bit different, but it's also a bit of an archaic technology by now.

Go to the top of the page
post Aug 18 2019, 06:04 AM

Posts: 160
Joined: 28-March 18
From: Virginia

You might also want to check out my article on Complex Text Searches.

Dale Fye
Microsoft Access MVP 2013-2016
Developing Solutions, LLC
Go to the top of the page
post Aug 18 2019, 06:22 AM

Posts: 1,947
Joined: 10-February 08
From: Ottawa, Ont, Canada; West Palm Beach, FL


Link not found????

Good luck with your project!
Go to the top of the page
post Aug 18 2019, 08:38 AM

UtterAccess VIP
Posts: 11,487
Joined: 6-December 03
From: Telegraph Hill

A stray 'http://' got tacked on to the end of Dale's URL.

@Orange, try this instead





David Marten
Go to the top of the page
post Aug 19 2019, 07:13 AM

Posts: 1,947
Joined: 10-February 08
From: Ottawa, Ont, Canada; West Palm Beach, FL

Thanks David.

Good luck with your project!
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    21st September 2019 - 06:38 PM