Search Multiple fields

O

O Wilson

Hello,

Is there a way to search multiple fields simultaneously?

I have a purchase order form and have created 20 text
boxes for each potential line item. I'd like to be able
to add a search command button that looks through all the
records for a specific item.

TIA

Owen
 
V

Van T. Dinh

I think your Table is incorrectly structured.

Suggest you look into the sample database "NorthWind" that comes with your
Access software and see how to handle items in purchase orders / sale
invoices.

Once you have the correct structure, seaching will become much easier.

HTH
Van T. Dinh
MVP (Access)
 
R

Resti M. Guay

Read the FindRecord Method topic on the Visual Basic Help to help you more
for this problem.
resti
 
T

Tom Wickerath

Hi Owen,

As Van has stated, your table design is not correct. Consider re-designing your database before
you spend too much more time with your current design. You currently have an Access spreadsheet.
You should not have several fields that describe the same type of data (line items).

You should spend some time gaining an understanding of database design and normalization before
attempting to build something in Access (or any RDBMS software for that matter). Here are some
links to get you started. Don't underestimate the importance of gaining a good understanding of
database design. Brew a good pot of coffee and enjoy reading!

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf

http://www.eade.com/AccessSIG/downloads.htm
(See the last download titled "Understanding Normalization")

http://support.microsoft.com/?id=234208

http://support.microsoft.com/?id=289533

Also recommended: Find the copy of Northwind.mdb that is probably already installed on your hard
drive. Study the relationships between the various tables (Tools > Relationships...)

Since you appear to be new at this game, now would be a good time to commit yourself to using
naming conventions. They're not that hard to learn. You will be able to avoid errors that
others encounter if you use naming conventions and avoid the use of special characters and
reserved words.

Commonly used naming conventions
http://www.mvps.org/access/general/gen0012.htm
http://www.xoc.net/standards/default.asp

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763

Reserved Words in Microsoft Access
http://support.microsoft.com/?id=286335


Tom
______________________________________


Hello,

Is there a way to search multiple fields simultaneously?

I have a purchase order form and have created 20 text
boxes for each potential line item. I'd like to be able
to add a search command button that looks through all the
records for a specific item.

TIA

Owen
 
Top