Search results

Thanks Pat. I set ID# column to autonumber and as my primary key. I indexed State and Zip. Thanks again. CRO8

What would you suggest?

Hello all, My project involves the web, but my question is basic table structure. My client develops and sells his product to dealerships, who in turn sell directly to customers. He wants to add a searchable database to his website so that the user has the ability to search dealers by zip code...

figured it out! While the database is in form tab, I clicked in the desired field and went to edit > find and placed astericks before and after the search word. *8/9/02* yielded all files with this date This worked! Thanks. CRO8

I set up a form for my coworkers to record our daily tasks. I am interested in the ability to search for past records. Now, when I insert > new record and conduct an Edit > Find, the search is case sensitive so I have to know exactly what I am searching for. Without having to teach my dept SQL...

thanks.

In table format, I deleted all fields but autonumber is still not reset. What did you mean by 'compact the databse' ? Thanks. CRO8

I incorporated 'auto number' as one of my fields in a form I am creating. I did a few test runs (entering info) and the auto number has increased to #9. Now, when I have completed testing, and begin to use my new database- the auto number field is inaccurate because it is a t #9 and not #1...

thanks for all your help- i figured it out. Thanks. CRO8

I think I just found what I have been looking for. On the toolbox palette, I clicked on 'combo box' icon- this is what I want! Now I have to figure out how to configure. . . I will keep you all informed. Thanks for your help! -CRO8

Thanks Hay- but that is not quite what I wanted. I do not want to format my Access tool menu, I want to create a drop down menu within my form . For example, when you reply to this message, the screen you type in your replay - you have the option to select a size of your font- click the down...

Alex, Thanks for the assistance. I followed your instructions and the results I received were more focused on customizing the menu bar (File, Edit, View, etc.) than creating a dop-down menu in my form. Any other ideas? Thanks. CRO8

Hello All I am developing a form for my department that tracks individual/ group projects. One of the things that I would like to incorporate are drop down menus. I did a "drop down menu" search in the Contents and Index option within Access with few results. . . My question: How can I develop...