Problems from making a access database

[Fred Ho]

I have a form with several text boxs ( for several fields of records
information)hoping that user input at least one of the information to any of
the field in the form and it will search the data sheet and if match will
output the all the record information with the same form. (Pull down menu cannot work as more than thousands of records)
Also the below is the subform to show the related project (that is the searched record) drawing list in a list form.
Pls teach me how to do all these?
P.S.: if there are 5 cat. of projects and I may need to give A0001...A0002,
BXXXX,CXXXX,DXXXX and EXXXX as the primary key, and they are in Excel
originally, can I import them as 5 different data sheet and link the primary
keys to let the datatbase to search all of them as in 1 form? One data sheet is not work as if add new record they are in 5 diff. cat. (that is A0299->A0300 and
C0500->C0501). Hope can understand and many thanks for any help!
Can access form add the pdf file as the jpg... tiff to show the related drawing on the corner of the form?
Thanks a lot!

[nico5038]

I have a form with several text boxs ( for several fields of records
information)hoping that user input at least one of the information to any of
the field in the form and it will search the data sheet and if match will
output the all the record information with the same form. (Pull down menu cannot work as more than thousands of records)
Also the below is the subform to show the related project (that is the searched record) drawing list in a list form.
Pls teach me how to do all these?
P.S.: if there are 5 cat. of projects and I may need to give A0001...A0002,
BXXXX,CXXXX,DXXXX and EXXXX as the primary key, and they are in Excel
originally, can I import them as 5 different data sheet and link the primary
keys to let the datatbase to search all of them as in 1 form? One data sheet is not work as if add new record they are in 5 diff. cat. (that is A0299->A0300 and
C0500->C0501). Hope can understand and many thanks for any help!
Can access form add the pdf file as the jpg... tiff to show the related drawing on the corner of the form?
Thanks a lot!

Lots of issues in one discussion :-)
Lets start with the design of the table you need. Every database is founded on tables and a correct design can save a lot of trouble in the future.
Looks like you need a tblProject table. The category should be recorded as a separate field when we follow the normalization rules. The combination you have now has a limitation, as what to do after adding A9999 ?
By having two separate fields you can easily increment to 10.000 and higher.

Are the fields recorded for all 5 projecttypes in the excel sheets all the same ?
Then add these fields to the tblProject table and then we can use an import to get the table filled with all 5 sheets.

Getting the idea ?

Filtering (finding records) can be achieved in a form, but also in the opened table by using the right-click. See the description I give my users:
http://www.geocities.com/nico5038/xR...nstruction.zip

Nic;o)

[NeoPa]

There is an article that illustrates Example Filtering on a Form. I think this may help with the main part of the question.