Search results

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

I'm an idiot!!! It was a typo (I almost lost the will to live!!!) . :D

Hi BDawg04 , I'm not sure if this will work but on the "On Form Load" can you setfocus to one of you objects at the to of your form? eg: ____________ Private Sub Form_Load() Me.LastName.SetFocus End Sub __________ Colin

Hi Folks, I know this has been covered here before...but I just can't figure it out! I added a new text box to a form, (which is driven from a button) and I now get the "Enter Parameter Values" message?? I have entered the following code behind the button DoCmd.SetWarnings False DoCmd.OpenForm...

Thanks very much, thats works perfectly. It was recking my head!!! :D , I much appreciate the reply, Colin

Hi Folks, I have been trying to create a search list on a form. I used the example on this forum but still can't get it to work. I have a text box to accept input. I have a list box to display info. I have the following code in the onchange event of the text box: _________________ Private Sub...