Search results

I think I'm missing how that would help me

No that was my example of the problem. I dont know the house/cottage bit, but i know there are entries with two words the same, so can i get it just to compare all combinations of two words, rather than an exact match, to find duplicates, rather than me entering which two words?

can you run a like query that instead of picking two chosen words, i.s like "house" & "cottage" instead it just checks to see if there are two words the same, in any order. and shows me duplicates, i.e if i had entries "radio (UK) 4" and "radio (wales) 4" as a duplicate query these arent the...

yeah thats what i want, a filtered down table, that i can inspect, but 120000 records is a lot. what method would you suggest

Yeah that did help. It definately cleared up True false stuff. I was trying to work out why it weasnt true/false, but it still doesnt seem to work. I have the control source of check box Flag, this is my code: Private Sub Check43_AfterUpdate() If Check43 = True Then [Flag] = "F" Else [Flag] =...

mmm. This would work if i knew the companies which might be duplicates, I want it to show me any company that is almost like another one for instance. I dont know which ones are duplicates

Hi. I have two tables, of which i have run a duplicate query, removed the duplicates by doing an "is null" criteria, and keeping that new table. I know though there are still more duplicates but the names may not be exactly the same, say barclays and barclays plc. so i run another query on both...

Thanks, yeah it the second function i wrote above now works, when you click it, but you cant unclick it, the image of the text box is sort of greyed out, when you click it the tick doesnt come or go, but it does put an F in the field. But if you click it again, you cant remove the tick, and...

Thanks for that, I have a search buttong on the form, that finds a field, from a textbox and puts the info into the form, the name of the company into a textbox control. Can i get the list box to scroll to the name in the listbox, that is in the other textbox. And B, The field I am interested in...

Hi is it possible to have a table in a list box with all the relevent fields included? how would i go about this. thanks alex

I want a field in a table to have an F in, when checked, and do nothing when unchecked

Hi, I have a checkbox, and when its value is 1 (I understand this means its selected) I want a textbox, which is the control of a field called flag (and is invisible) on the form to take the value of F, and relay to the field on the table. but it doesnt relay to the table. My code is under the...

Hi Thanks for your reply, it still doesnt show me anything. I'm slightly confused as to whats its doing. Alex

Hi Doc and Brian. the first thing i do is search the forums, because A. the chances are what ever i'm asking is unique and someone has had the same problem before, and B. its quicker, but sometimes a question is phrased in a different way, and things can be quite difficult to find. Also trying...

I am trying to do a partial duplication query. this is the code from the SQL view in access SELECT filtered1.Company_Name FROM filtered1 WHERE (((filtered1.Company_Name) In (SELECT [Company_Name] FROM [filtered1] As Tmp GROUP BY [Company_Name], Left([Company_Name],7) HAVING Count(*)>1 And...

Hi Dennisk and Guus2005. Thanks for your help. I still struggled with it, and so went to the office help online. It said that i could do a partial letter similarity query. starting like this: select 0870.Company_Name From 0870 where (((0870.Company_Name) In select [company_Name] from [0870] as...

How do i use that. I cant put it in the criteria box, and also, do i make the query in design view, and enter the table that the update is happening to?

THanks for reply. As it happens it thats what I want, every word to have first letter capital. I used this line of code to do it, as an after update. Me.[Company_Name] = StrConv(Me.[Company_Name], vbProperCase) But I have a lot of records, entered using a query, so they arent getting an "after...

Hi. I have a load of records, that some of the first letter of a field, are not capitals, otherwise they are ok. the are loads of them though, so would take too long to go through by hand, is there a query i can run, to check it and change it if not? Thanks Alex

thanks, I somehow managed to do it