Search results

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

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

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

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

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

Hi. I have two tables, both with load of info. I need to run a query, that checks data in table1 against data in table2. If it is in table two, then moves on. If it is NOT, then shows the results to me. So that i can see which ones were not there. how do i go about that. thanks Alex

Hi. I have a list of 120000 entries, of companies in the UK. I need a query that will grab all the ones which have relevent similar names to others, like a duplicate query, but a bit more specific. For instance, First Choice UK, and First choice PLC are the same company, but have two entries...

Hi, I have two questions which i dont think are two far apart, hence same thread. First is, how do i make a search text box, that when i click a button searches for what is in that text box, rather than bringing up the find box. It is alright but it always compares it to what was last tabbed...

Hi, I have an address database and in the zipcode/postcode box, i want all letters entered to go to capitals ie rj20 4ls would go to RJ20 4LS after update. how could i do this, what do i add to text boxes after updat? Thanks Alex

hi. I have two monitors. on the left I have a table with 120 000 entries. On the right I have a form, that searches the entries and shows me the data from the fields in textboxes. Each Time i search (the table is in alphabetical order) in the form, I have to check the table to see whether the...

Hi, I have a huge databse with a form, showing record info. If I use a search button to search the databse it takes ages to find the record. The quickest way is to find the record by hand, find the record number, copy that, and paste it into the form and hit enter. Does anyone have any ideas...

Hi, I am inputing addresses into a massive databse, through a form, does anyone know a way, that i can get it to do a search for the address based on the postcode, like how googlemaps does it or something? Thanks Alex

Hi, I have a huge table full of records, with a column called sectors, and sub sectors. For instance if the sector is animals, a sub sector(activity as i am calling them) could be a vet. On my form, I have a combo box for selecting the sector, what i want is another combo box for selecting the...