Recent content by CGC

Ok, I'm still stuck. I looked at the QrySmp00 and that won't work. Following this method, it only picks up the records that have a Date and not all of them do. The people using this search form want to be able to search by date, or not, depending on the info they are looking for. Also, they want...

I'll give it a try! Thanks for the suggestion - hopefully it will give me a solution!

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...

That does work, however the problem is that they want this form to be searchable on one or all fields. So they may or may not want to search on the date field. If I set it up this way, they will have to put a date in and they may not want to search on that field. Anything else I could try? If...

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...

That got me going in the right direction. I found out the dbText s/b dbInteger and it seems to be working fine. Thanks for the info!

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...

This has been great help and I'm starting to get somewhere. But I am having problems with one of my fields on the "Search" form. It's corresponding field in the query is actually an ID field but it displays a name instead of an ID number. On the table that my query was created from, the field...

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...

Sorry for my delayed response on this. I am still having problems and thought I could figure it out myself (wrong!). I probably should have explained this better the first time, but I think my problem is in the fact that all the info I need to create this grid-report is all in one field. The...

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...