Search results

thank you so much for your help it looks and works perfectly now!

i made a switchboard from scratch and when i view the switchboard it has an arrow on the left side and records on the bottom, so it is making it look like i am entering data and it is keeping track of how many times i do it. Please help i am trying to make this look like a switchboard done from...

ok Doug i have a few things. the strWhereValue is a bunch of if statements to find a field that is not null and what ever the value is in that field put it in strWhereValue. now could you explain that code for the recordsource a little more because this is what has to happen, i have a form that...

this is my code: strSQL = "SELECT contacts.contact.id, contacts.postalcode, contacts.city, contacts.firstname, contacts.lastname, contacts.state, contacts.day_phone, contacts.evening_phone, contacts.budget_range, contacts.new, contacts.used, contacts.length, contacts.date_of_birth...

i was wondering if there was a way of putting an sql statement into a report through vb code. i know how to do it for a listbox but i would like to put it into a report so we can print out the results of the sql statement.

i tried to open your db file again and i got the same error as last time: The Compressed (zipped) Folder is invalid or corrupted. it sounds like the example i need to see becuase of the search.

ok, first jfgambit, your link didn't work. Second, Andy i zipped my db and it is about 150 or 160 kb, so could i get your email so i can send you the db? thanks for your help.

i thank you very much for taking the time to help me and any comments that anybody has are taken constructively. you didn't offend me in any way. i understand that having one table with lots of data is not the best way to go about doing things but i wasn't sure how to make more than one table...

the form is a customer form, name, address, phone number and what the customer is looking for or purchased (basic info, much more is on the form but not needed for my problem at this time). what i would like is to use to same form that is used to enter in this information to search the info...

i have a form that i use to enter data in and i would like to put a search button on that form. that is the easy part, now, there are a lot of check boxes, text boxes, a few drop downs. i would like to be able to enter something in that form and hit the search button and for that to find all...