Google Search

[euanhampton]

Hi, Im trying to make a google like search query on my database so a user can type in one word and then the database will search for all the records which contain this word and display them.

Any ideas?? I only want it to search through the one table,

Im no expert on VB so if someone could translate it into basic english that would be good.

Cheers

 

[DRathbone]

Wat you want is a main form with a single combo box and search button, then a subform with all required results (based on a query from your DB) then if for example you where searching for productid within the query criteria specify

Like "*" & [Forms]![themainfromname]![txtseachboxonform] & "*"

then within your vba a simply me.[subformname].requery will do the trick.

Use the search function on this forum theres some great examples poeple have posted. http://www.access-programmers.co.uk/forums/search.php?searchid=1216773

 

[euanhampton]

Ok but Im not sure what the possible searches are, they could literrally put any word in and I would want it to return each record (no matter which field the data is found in) ??
Sorry
Cheers

 

[Dreamweaver]

This is how I do it using a form displaying the current record for say Toyah

This is a text search

CmdGoogle.HyperlinkAddress = "http://www.google.com/search?q=" & "%22" & Me![RecordingArtistName] & "%22"


Images
CmdGoogleImages.HyperlinkAddress = "http://www.google.com/images?q=" & "%22" & Me![RecordingArtistName] & "%22" & "&sa=N&tab=wi"

Plus the IMDB
CmdIMDB.HyperlinkAddress = "http://us.imdb.com/Name?" & Replace(Me![RecordingArtistName], " ", "+")

Each will require a command button on the form