Using VBA to Search in Access 2007
25 categories, 32
i have a database at work that that is used to track project progress for environmental cleanup projects. I am trying to create a form (in Access) that uses check boxes to select which criteria to search for and then then have a "Go" button that will launch the search. I want the search to return only those records with info in them. For example if I select criteria 1 and criteria 5 I want that data to return only records that have info in criteria 1 AND critiera 5 not one or the other. Once the search is complete I would like the information to be displayed in a report.
There are only 500 records that contain 32 fields of data per record. There are only 25 criteria that I would like to let people search for. But I would like the report to show all 32 fields.
The fields I wanted searchable are:
contract task order
Phases
Active/Inactive
Category
FDE Date
INPR Status
INPR Date
PA/APA Date
SI Date
RI/FS Date
RD Date
RA-C Date
RA-O Date
LTM Date
IRA Date
EE/CA Date
RmD Date
RmA-C Date
PCO Status
PCO Date
Project NDAI Date
Project Concurrence Date
Property NDAI Date
Property Concurrence Date
Concurrence Status
I am a coding retard and have no clue how to begin. Any info would be greatly appreciated.
culleng
|
