Search results

Yeah actually I tried it again and it works great! Many thanks for your time! I really appreciate it!! :D

So this goes in the text box at the bottom of frmCustomerSearch, and =Count(*) in box at bottom of fsubCustomerSearchDetails? I'm just checking because i'm still getting #Error :(

Excellent, works perfectly! Many many thanks!!

Hi all, I'm a bit stuck! I'm building a form to show customer orders which haven't been delivered yet. I would like it to be continuous forms so that they can all be viewed at once. The form uses qselUnprocessedPurchases which brings together qselCustomerDetails and qselCustomerPurchases...

Brilliant thanks. That works, except it shows a blank record with #Name? in every text box. Is there any way to change that?

Any ideas anyone? Many thanks in advance!

Ok cheers. The search form is frmCustomerSearch.

I'm really sorry to take up your time!!! I've tried both of these and they both still show #Error on 0 (zero) results. Am I doing something wrong? Sorry and thanks again

Hi all, I have created a form which searches and displays results in a subform. The search works perfectly and I can search on any combination of fields. However, on opening the form or pressing the clear button, all records are shown in the subform. I would like to change this so the subform is...

Actually could I trouble you for a bit more help? I have =Count(*) in my subform footer, and =[fsubCustomerSearchDetails]![txtDCount] in a text box on my main form. It works perfectly, except when the subform shows no results... instead of 0 (records) it displays #Error. How can I change it to...

Hi all, I'm unsure how to go about this and wondered if anyone might have an idea to get me started? I have a customer sales database, and the owner would like to send out deliveries once there are 150 items ordered. The company sells compost, mulch etc for gardening so they are heavy bags and...

It's ok, thanks for the help but I worked it out myself. I added two fields to the existing customer table, 'postcode' and 'homephone'., which meant i could just append all the records as they were and each customer would get a primary key in my original table. Then I created two append...

Sorry but I don't follow? Could you explain more? Cheers

Yes they're in separate tables because we don't have post codes and home numbers recorded for all our customers. So any ideas? Many thanks.

Hi all, I have a customer database and I've imported 36000 new customers from an excel file into a new table, called tblLeads. I have changed the field names and types etc in this new table to match the field names already created in the existing database. The table looks like this:-...

Yes that works great, many thanks!!

Hi vbaInet, the name property IS already fsubCustomerSearchDetails. The forms are unbound, will that make a difference?

Brian, apologies, the two blank columns were already there in the file. I should have removed them first. Anyway the code works perfectly. Many many thanks for your help and time!!! :D

Thanks vbaInet, I have done that. Unfortunately the text box just displays '#Name?'

Brilliant, works perfectly! Many thanks!! :D