PDA

View Full Version : Search Access Database - based on user input



chiefnz
07-11-2008, 01:27 PM
Hi all,

1stly... I am no expert with Access but would like to get to know it better.

I am trying to create a button on a form which, when clicked prmts the user to input the desired search criteria... for example by Asset Number?

Once they enter this data they click ok and the search is initiated...
If entries are found the results need to be displayed.
If no entries are found then a message needs to be displayed saying... "No such entry found? or something like that.

I have 1 table called Asset_Details and 1 form called Main_Assets.

Any help would be appreciated.

Cheers,

stormdragon
07-11-2008, 01:33 PM
Use a parameter query for searching vary user input.

Sorry got to go so don't have time to explain properly but a google search should yield a fair bit of info.

Speedy Gonzales
07-11-2008, 01:34 PM
You mean something like this ? (http://support.microsoft.com/kb/304352)