Recent content by CEB

Hi Folks, I have a knowledge and logic test for a job soon, which I've never done before, and was wondering does anyone know if there is a site with example questions? The test is in C++, but I thought someone might know of a place that hosts many types? That's even if there are such a thing...

Thank you Len, that worked out fine for me. It turns out that there are over 5000 dups!! Thanks again, Colin

Hi Folks, I have a quick question...probably with my logic. I have 20,000 records in a query. I know that some of the records are duplicates because I have the names, for example, FirstName:"Fred", LastName:"Flintstone" and then another record with FirstName:"Flintstone" , LastName:"Fred". I...

Hi Colin, Yes you did change the code and that work great on the other table I needed it for!! However, on this table (a single table) it doesn't work. The difference now is I'm searching for Last name and First Name only and am selecting Lastname on the double click event in the list box. Do...

Hi Colin, I'm sure that's where I got the code originally. I have used the code after Update on the company example and still get the same error message. _______________________________ Private Sub SearchList_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone...

Hi Sarah, I'm sorry, I misunderstood your code. I now know what it's doing. If you are having problems with file names when you use it in other places, do you have to include the table names along with the field names (example) ________________________________________________ stLinkCriteria =...

Thank you Sarah for your reply. I got some code from this site a couple of months ago and it works great! What I have is a textbox that the user can enter first or last name (or part of) of a person they need to find. The list box changes as they enter the letters. They can then double click...

Hi Folks, Sorry for bumping my question again. It went down to page 2 and I'm hoping someone new might see it today. I'm under pressure to get this search working. The message I'm getting is still the same. I was wondering does it need a primary key as the table I'm using is old and has none...

Hi Folks, I have a search option on my form that allows the user to search a table by either first name or last name. They double click in the list box on the name they want. I am using the exact same code in another one but it doesn't seem to work. The error message I get is " The Microsoft...

Fofa, thank you very much for that...it worked great! Colin

Hi folks, I have a table with the words "Church of (whatever)" in one of the records. I am attempting to do an update query to remove the "Church of" part but leave the remaining part of the string. I am using a combination of Format and left but am not having any look. Any suggestion are...

Thanks alot Pat, I'll have to think about this further. Adding extra fields for the other users is definitely a way to go. Is there a way that they can only see what fields I wish them to see or do I have to break the table into seperate tables? I have already a lot of records in there and...

Hi folks, I have a table and I want most of the fields available to others. I also want the other users to be able to add fields to the table (not the master but theirs). Here's an example to explain it better: MasterTable contains the following fields: Name,Address,Phone,Training,Checks. I...

Thanks Truck time, I had just figured it out this second. Thanks again, Colin :)

Hi folks, Quick question....I have 2 combo boxes on my form (along with check boxes, text boxes etc). When I click on add new rec at nagivation controls and enter details, all the data is updated in the tables except for the combo fields? Should I be doing something else to update these fields...