Recent content by Jefftosh

I got it working! Just hafta make it pretty. There is no way I could have completed this in a timely fashion without the awesome help I received here. At 3AM no less! You guys rock!!!

Good morning! Thank you so much for your efforts on my behalf. Your code works. I am completely ignorant in SQL but I think I understand enough of what you did to try and apply this idea to the main database. You sir are a true champ and I can't thank you enough for your prompt and accurate replies.

So the idea was to be able to enter in one or several of the fields in the form and get back all records that match in the table. If you search on the form for Smith you will see that only 2 of them show up and the 2 that are missing do not have the Spouse Name field filled in. A client may come...

Thank you! Wow. You whipped that up in minutes! So I see you have used Or. I have around 10 columns(Fields?) that can be searched. I will try using OR for the other entries and see how that goes :)(y) Edit: I'll see if I can put together a mini version of what I'm doing so you can see what I'm...

Thank you for the hints. I will read the SQL link you suggested.

I tried this just now and unfortunately the query doesn't work at all with the apostrophes. Were they supposed to be Quotation marks? Edit: No that didn't work either. I don't get a syntax error doing as you suggested but the query searching any field returns no records at all.

Hi Folks , I will say right away that I am not familiar with Access other than knowing what it is. I have picked up a bit, googling, and will do my best to use the correct terminology. My friend runs a cemetery. He has been using Paradox from Corel to manage around 15000 records of current and...

Hi folks, I live in Canada and work in IT for a living; primarily on the hardware side of things. I have done ladder programming for automating farm equipment with microcontrollers and that's about the extent of my experience on the software side of things. I enjoy campfire Scotch and have too...