Search results

Hi all, on frmCustomerSearch I have two buttons with code, a Search button and a Clear button. I would like the clear button to clear the search boxes and then refresh the subform 'fsubCustomerSearchDetails' to show all records in the subform. It clears the search boxes fine, but I cant get it...

Hi all, I have a search form with search combo boxes "frmCustomerSearch" which displays search results in a subform "fsubCustomerSearchDetails". I would like to display the number of records found from the search at the bottom of the main form, but I can't work out how. Many thanks for all your...

vbaInet - They are two of the problem records. Eden Court and Edenholme 1a are probably house names and numbers so would be in House/Flat_Number only. There are only a few like this really and will be fine to manually correct them. The biggest number of problems/mistakes are all the flat...

vbaInet - they are separate records, thanks Brian - It didn't say which row it failed on, i'm probably doing something wrong :/ I've attached the file with one record now. Many thanks.

Many thanks for all your replies! I'm very grateful! I tried using Brianwarnocks code to split the data in excel (version 2), but i'm getting an error "runtime error 9. subscript out of range" Any ideas what i'm doing wrong? Other than that i'm a bit of a novice with vba and i cant work out...

Hi all, many thanks for reading. I have a customer database which i built. I have always used two separate fields for 'House/Flat Number' and 'Street', and there are 6000 correct customers entered in this way. The company has now bought 35000 leads for marketing, which will be added to the...

Hi all, firstly please forgive me if i'm a little slow, i haven't done any access work for a year or so and i'm a bit rusty :o Basically i have a customer database which holds customer details and orders. It's been created and working fine for a couple of years, but i recently found something...

Hi all, I have a report which lists customer details along with details of their last purchase. It is the first dynamic report i have done. It lists customer title, surname, house number, street, area, town/city, tel, then purchase date, season, products and cost. I have a form which i'm using...

I want to be able to choose any area's or towns and have it bring up the records that contain either so i guess i need to change code to do that but i don't know how. Or perhaps someone has some quite different code i can use? I don't know, i just tried to follow a tutorial as stated earlier...

Or is it something to do with the fields used in the query/report? I have the Areas multi-select list sourced on tblAreas, which is AreaID - PK, Autonumber Area - Text and the Town list on tblTown_Cities, as follows Town_CityID - PK, Autonumber Town_City - Text CountyID - Number, but not...

No there must be something wrong with my code. I've tried it with just one multi-select list on tblTown_Cities, with a simple report on JUST tblTown_Cities, and if i select any towns at all it shows no records :( Pllleeeeaassseeee can someone help?? Many thanks in advance.

Hi all, firstly i'm very new at coding so please forgive me if i sound unexperienced, i am :) I have a report which lists customer details along with details of their last purchase. It is the first dynamic report i have done. It lists customer title, surname, house number, street, area...

Yep i've done it now and it works fine, thanks for your help FoFa. It was just that i wanted to know where the extra numbers were coming from, and i worked out that obviously when only using two fields there are less unique records than in the full query with five fields. All the extra ones were...

So do u mean to have 2 copies of tblCustomerPurchases in the same query? Edit: No it's ok, i worked out what i'm supposed to do with it :o It works fairly well but for some reason it shows 4935 records, where it should be 4923? Do you think that might be because a few customers might have...

That's because there are no cases open on that day, or closed.

Can't anybody help? :( I'm running out of time and getting stressed with it :( :'(

Sorry FoFa, i'm not that intelligent obviously :o I can't work out what to do with that? Whats CP1 and CP2?

Sorry MStef but i can't see how you did that :o I know it must be something on the report but i can't see where? I would actually rather it was done in the query if it was possible as i am going to be making the report a dynamic report with filtering and maybe sorting, so if it's something...

Hi all, i have a query which will be used for reports, and only the last order placed by a customer is needed to be shown. Here's the table used in the query:- tblCustomerPurchases CustomerNumber PurchaseNumber - PK,Autonumber DateOfPurchase SeasonID TotalCost So obviously for one customer...

Thanks Wazz for all your help, i'm really gratefull :) I'm having real trouble with the multi-select search now aswell but i'm going to start a new thread in the reports section as it's more appropriate and i think i've taken far too much of your time already :o sorry. And thanks again.