Creating a search form

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I've looked at previous posts and can't find anything that matches what I
want so I wonder whether anyone can point me in the right direction.
This is what I need:
I have a table with a number of fields I want to create a search form that
gives the user the option to do a wildcard search on say four of the fields
in the table using an option group. Is this possible and does anyone know
of an example I could base my form on.
Thanks
Tony
 
Tony,

I have seen an example on the Database Creations site. The database is
called: EZSearchSampler97.mdb. This is an example of exactly what you
describe. If the site does not have the file any more then I can send it to
you if you leave your email in the next post.

Alastair MacFarlane
 
Thanks Alastair, just had a look at their site and can't find the file you
mention. Does it work with Access 2002, just wondered with the "97"
reference?
Email is dito6athotmaildotcom change the at to @ and the dot to .
Thanks
Tony
 
Thanks Alastair downloaded the demo. Some great functionality there but
probably a sledgehammer to crack a nut and an expensive one on our budget.
But certainly looks powerful with plenty of choices
Thanks again
Tony
 
Tony,

I have no affiliations to this company and have never used the product. I
remember many years ago downloading a sample from their website and it was an
mdb file, rather than a locked mde file.

I have sent it to the address you previously posted.

I hope this helps.

Alastair MacFarlane
 
Alastair Windows Live Mail is blocking the attachment because as an mdb file
it thinks it's a virus. Could you change the file name to say .mdb1 and
resend it?
Thanks
Tony
 
Tony Williams said:
I've looked at previous posts and can't find anything that matches what I
want so I wonder whether anyone can point me in the right direction.
This is what I need:
I have a table with a number of fields I want to create a search form that
gives the user the option to do a wildcard search on say four of the
fields in the table using an option group. Is this possible and does
anyone know of an example I could base my form on.
Thanks
Tony
Click to expand...

Hi Tony,

I once did this using a series of combo boxes to select the field(s) and
text boxes to enter search criteria and then building up the SQL code at
run-time. Having said that, the built-in 'Filter by Form' feature is
infinitely more flexible and easier to use.

Regards,
Keith.
www.keithwilby.com
 
Thanks Alastair, that looks like I could use something along those lines
Thanks again
Tony
 
Back
Top