Search results

I already posted this but didn't get responses, so I thought I'd try again just in case... I have a form set up just for searching. It's an unbound form set up with numerous combo boxes (also unbound) so the user can search on as many fields as they want. The problem field is the date field. I...

I have been working on a search form for a week now and seem to have everything working with a couple of exceptions. I now need to add the ability to allow the user to search on a date field as well as a yes/no field (set up as a checkbox on the data entry form.) My search form is an unbound...

I needed to be able to add a new record to a combo box. I just tried using the example in the Microsoft database (Q197526). It works up until the InputBox appears to add the new record. Then I get an error "Data Type mismatch in criteria expression". I think if figured out why, but I don't...

I have been looking thru some of the items on searching (on forms) but so far have been unsuccessful with my attempts. Does anyone know of a way to turn a form (used for data entry) into a search form? Ideally (perfect world), click a button and all fields turn into search fields, enter as much...

Hi, I originally posted this in the form forum, but it was suggested I go the report route for this. I am trying to duplicate, in access, a price list that is currently on paper. The data needed for this price list is in 3 tables, and I have a basic query set up to pull all necessary data...

Hello, I'm not sure where to start with this. I may need a report instead of a form, but I'm looking for suggestions. I have a price list (on paper) that we want to have in Access in the same format. (A table & a query are already set up.) The price sheet looks something like this: Motor...