Search forms (1 Viewer)

[Mozz]

Hello,

I'm trying to use Access as a library catalogue for the charity I work for, and although fairly happy with the results I would like to move it on abit, away from using "Filter by Form" as a way of searching. My catalogue is about to go "live", and I would like the users here to come first of all to simple search boxes.

So, when a user wants to search for a book by Title, or Author or Subject, they can enter a term in one of three boxes and this would then take them to the full record for this item.

Is this possible using Access, without programming?

Any help greatly appreciated.

Mozz

 

[businessman]

it is possible if you use a query that searches using the wildcard (*) symbol infront and behind the value they enter. its not a very easy way to do it.

Without programming its very hit or miss. I'm using a search in my DB to search every field in my DB for a value that the user enters. it is much easier creating my own SQL string and moving on from there.

 

[bonekrusher]

try here:

http://www.access-programmers.co.uk/forums/showthread.php?t=100246