sample(s) please

[mitchem1]

Does anyone out there know of a sample Search form that I could study?. What I have in mind is a form with multiple combo boxes. Records are retrieved based on what the user selects in the combos. If all combos are left blank, all records should be retrieved, even if some of them contain nulls. thanks.

 

[DT]

What version of Access are you using? I have an Add-in that you might find useful.

DT

 

[mitchem1]

I am using Access 97. I would love to see the Add-in. Thanks.

 

[DT]

What is your email address and I will send it to you...or go to this website:

http://www.aadconsulting.cjb.net/addins.html

and look for SMART FORM WIZARD

Lots of stuff to check out here. Good luck!

 

[mitchem1]

Thanks DT,
I will go to the site and take a look.

 

[Cosmos75]

Good Link

DT,

Cool link! Lotsa good add-ins that go on my MUST-TRY list! Thanks!

 

[Janet Thomas]

For what it's worth, I have a database that seems to do what you wanted. (I have in AC2K but can convert. Have zipped but file still 267KB so can't attach here - if you want, please email me)

This database has a form called "Entry Form". On it there are lots of combo boxes where you can choose criteria for selection or leave them as a wildcard (*). There are three command buttons - the first one opens a form that uses the selection criteria in the SQl in the record source. The other two buttons open the same second form but add additional filters on top.
I don't think this will deal with null values in fields - sorry.

I have learned VB and Access on-the-fly the past few months and so please excuse the poor naming standards, etc. - a bit embarrassing. I have now bought a book so am improving! However, it works very well and someone might find it useful.

 

[Cosmos75]

Janet Thomas,

If it's OK with you, could you email me that db file as well?

 

[MICHELE]

I have a search screen(form) that seems to do what you want with combo boxes. It works off of a query with several IIF statements in the criteria.

I am not real strong in vba. And you'll see that this form is pretty basic. However, my company loves it and it has saved them tons of manual searching time and energy.

Email me if you would like to see it.

 

[Cosmos75]

MICHELE,

I'd like to see it.