Search results

Sorry, I'm quite new to access but boss, asking me to do some quite demanding stuff - but thanks for quick reply! What you are telling me to do is: 1. Make query in design view 2. open table, i wish to add www. to 3. double click on the name of the field that i wish to add www. to 4. in the...

Right. This is my problem. I have a list of 120000 entries of the names of companies. and they have website addresses related to them. say, the AA and website theaa.com I have another table with 108 websites in that i have to see if they are already in the entries, and if they are not, add them...

Thanks, it didnt work though, just showed me the titles of the columns, but absolutely no data. (By key field you mean the ones I am interested in, and by left hand join, you mean drag the name of one field onto the other right?)

Thanks for replying. But how do i use that. Put it in the vb of a button? is compnayname meant to be the name of the table? what is the name of the textbox it is looking at to be similar to.

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 denisk, How do i make it so it doesnt search for the name in the WHOLE field but part of it, for instancee if i search for first choice, i want it to show me first choice holidays, first choice plc etc. also how can i get it to show me the result in a table. thanks alex

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

Thanks for reply Thanks for replying, do you think you could give me a bit of a walk through for that. I havent been using access long

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

huge database Thanks for replies. How do i go about adding primary keys or indexing fields. Thanks Alex

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

Thanks for replying. but my vb is not great so... what do i do with it, run it as a macro? How can I attribute each sub sector to a sector. I have a table with all the sub sectors next to there relevent sector, can i use this to do what i am trying to do, or have i missed the point.

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