Microsoft Access Help

[muddyfox470]

Ok well i shall start this and anyone else needing help for Microsoft Access can come here, add their queries or find their answers. Also if you have any helpful hints i am sure people would find it useful if you could take the time to post here.

Lets get the ball rolling...

I have a humongous Access Database now, containing hundreds of references to search through, and as this is going to be accessible by a few other employees i need to make this process as easy as possible.

Primarily i would like to create some queries, i.e. to list the categories, by a specified name. The problem is that these cells (and there are quite a few hundred of them) contain lists of keywords, seperated by a hyphen (-) so how can i get access to create a query so it can search through the ciolumn to find the necessary keywords.

I guess this would be pretty similar to the keyword search (or binoculars icon) that is in Access anyway. Just is there anyway to automate it to find the words that people require, or to create different queries and hence reports for these keywords.

Thanks in Anticipation

(i hope you understand what i mean)

Ian

[daverobev]

I'm guessing "make it a relational database by splitting stuff out based on the rules of database normalisation, which would make this a doddle" doesn't help?

IE, have a table of (for example) customerID and Keyword, where you have multiple keywords per customerID?

No..didn't think so...sorry

[Dougal]

How about using in the SQL statement for the chekcing

"...field like '*" & txtInputBox & "*' ...."

That'll look for the term inside txtInputBox within the field in the database

[muddyfox470]

Oh cheers Dougal i shall have a try of that in a bit!


so would i type

keywords like '*" & txtInputBox & "*'

(but where do i put the words i want to search for?)

cheers

ian

[herulach]

Is it in a query on a form? If its on a query then "*" & [Insert Prompt for pop up box here] & "*". In the matches bit.
If its on a form then put the value you want to search for in a string and replace the [] with a string, then put it in the forms filter property, obviously with [Name of field with keywords in] = before it .

Although i would second the go read a book on data normalisation, what the hell were you thinking viewpoint.

[muddyfox470]

You both have PMs, any help would be greatly appreciated!

Cheers

Ian