Search results

Hi all, could somebody please help me to construct this form? I have a few duplicate customer queries (different duplicate fields etc). I would like to construct a form to make it easy for an end user to remove the duplicates. The main problems are... 1. the newer customer is to be deleted 2...

Ok I know more of whats needed now so I'll start a thread in the forms section. Thanks.

Ok thanks. So is it possible to consolidate data in a form with a duplicate query base?

The owner pays a salesperson more for selling to a new customer, less for selling to existing customers. If the data is not consolidated then all the salespersons entries will be marked as 'new customers' and pay more. I know I know it's complicated :o but thats how he wants it. So it has to...

Thanks for the reply! Unfortunately it's not a one off. The problem is that the owner wants a section for a salesperson, to add new customers. He wants to hide existing customers from the salesperson. In which case it seems like theres no option to prevent duplicates at entry?

I think firstly with the duplicates query, I have one which simply looks for duplicate surnames [Surname], with the same street and house numbers [Street] [House_FlatNumber]. How can I make it more complex to ensure I catch them all? i.e. same business name [BusinessName], wrong spelling of...

Hi all, this one has me stumped. I have a database with customers/orders etc. I need to create a form or something which will show if a duplicate customer is entered. I know about the duplicate records query wizard, but I also need an easy way to consolidate and delete records. When a duplicate...

Brilliant! Thankyou!

Hi all, simple question... I have a report with an unbound checkbox which has a null (greyed out value) when printed. I'm just trying to set it to false when the report opens. I have Private Sub Report_Open(Cancel As Integer) Me.CheckNotPaid = False End Sub but it just says 'Runtime Error...

Brilliant, those work great! Many thanks!

Thanks. I can show the query but there son need, it has both 'Payment Type' and 'Payment Received' fields in it. How would the IIF statements look? Something like... PaidByCard: IIf([PaymentReceived]="True" And [PaymentType]="Debit/Credit Card",True,False) PaidByCash...

No, on the report the owner wants all three payment types listed, with a checkbox next to each one. Then if payment is received the box is ticked, but obviously only for the payment type. So there are three or more checkboxes on the report (one for each) but there's actually only one payment...

Sorry, I didn't really know if this should be in the VBA, Reports or General forum. I have a field 'Payment Types' with values (Cash, Cheque, Debit/Credit Card) and a field 'Payment Received' which is Yes/No. When putting the order through the user selects the payment type and ticks a box if...

Brilliant. Thankyou to both of you! I have used Davids method and it's working perfectly. Thanks again!

Sorry for the long title. I have the following code in the On Load of a report which shows multiple records:- If Me.PaymentType Like "Debit/Credit Card" Then Me.Check94 = True Else Me.Check94 = False End If This ends up checking all check boxes in the report if any have "Debit/Credit...

Thankyou for your help Eric! The hour or so I spent with you on Skype/Teamviewer was very worthwhile, and I couldn't have done it without you! Very many thanks!

Thanks Eric, and don't worry, I might consider it soon :) I have now created a new query 'qselOrderRoutePlanner' which only holds the names and addresses of people for delivery. So no erroneous data such as delivery date, items, etc etc. Just the name and address. This I feel makes it much...

Thanks Eric, yes I've looked through a fair amount of stuff at mp2kmag and I'm starting to get an idea of how it works. Thankyou. I think its just that I'm a novice with this and whilst I can do basic VBA code I struggle with some things. I can't really work out how to get started. I mean can...

Thankyou for the replies and I'm very sorry for the slow response! My wife and I have just had a baby :) which is great. The bad news is I've got to try and get this sorted asap and I'm stuck :( I currently have a report which is based on a query. It shows the orders for a delivery, including...

Hi thanks for the reply. Yes MapPoint can generate an optimised route, I have looked into that part. We only have postcodes to use but would be more than happy with that. The part I feel I will have difficulty with will be the best option to pass those postcodes to MapPoint and how to do that...