Search results

Alan, Thanks for that info. I knew there had to be some code back there somewhere but without any formal training I didn't know where to look. It turns out your code and my code were very close but even after I corrected my code I was still getting over a million records. About 260,000 more...

Alan, Thanks for the quick answer. I don't quite understand where I should use that code. I understand what it is doing and I'll probably have to add the rest of my info to get my table 1 filled in properly. In my mind, I thought the use of an access query would do the trick. It seems so...

Hello Again, I must be brain dead since I have a simple problem that I cannot get to work. I have 2 tables. One has names, addresses, city, state, zipcode and other info. The second table has state, zipcode and county. I want to add the counties from table 2 into table 1. I've been playing...

Sorry for the confusing wording. I'm new to Access and this type of coding so I don't always say what I mean. The original question was to help me pull data from a table using 2 parameters so I could display the results. That now works fine. I also have an unbound form that is filled in by the...

Hi Paul, Thanks. After I posted my solution it dawned on me that I was trying to use "AND" and not "&" so when I tried it with "&" it worked fine with all the code on one line. I was going back to correct my Post when I saw your solution to the problem was what I had tried. You are correct...

I found the solution to the problem. I added a line to the code and now I get the most recent contact. For some unknown reason the code did not like everything in one statement?? I forgot to mention that I'm using Access 2000 if that matters. Dim LLSQL As String Dim LLSearchString As String...

Paul, Thanks for the quick reply. I should have put in my post that I am new at Access and self taught and don't understand a lot of the functions. I had a poor teacher!!! Your answer makes sense to put the info in descending order but I don't know how to incorporate the code into the code...

I have been fighting this for a couple of days and could use some help. I have a program that keeps track of contacts made with people and need to know the last time (most recent date) that I contacted an individual and display the info. Here is what I have so far: 'Dim LLSQL As String 'Dim...

Hello, From Knildon in Pittsburgh, PA. I'm a new self taught Access user and need some (a lot) help! Thanks in advance.