Search results

It works! Your a star. I had done this last night but the relationship had stayed as 'one to one' so i just deleted it, created a new one and bobs your uncle. Many thanks for your help. Just for future reference what was causing the problem?

tblPublicationDetail is no longer part of the relationship and it is still giving the error!

CustRef is indexed in Tbl_Customers and is set as an autonumber. Is this right?

the relationships are all now one to many (see pic1) but it is still giving me the same bloody error (pic 2)

updated relationship pic attached - many thanks for all your time and effort on this

2 of the tables i cant change from one to one - how do i change it to 'one to many'?

i have taken on what have both said - created new primary key as [billing_id] and in the relationship set it to 'custref' to 'custref' as one to many but still get the error. Aaargghh!

could it be an issue with my relationships? Picture attached

with the stripped down it works on mine so it must be conflicting with another sub form - which i had to remove from the stripped attached version.

here it is - the main one is the 'Frm_Customers' in this is the sub form for marking payment date which springs the error.

i have tried it with no primary keys - and setting all to allow duplicates but still getting the error! its driving me crazy

It is [CustRef] - which is a 'many to one' linked to the main table of Customers.

i have a sub form which on the click of a button sets 4 fields Private Sub Command8_Click() LastPaymentDate.Value = Date NextPaymentDate.Value = Date + 7 AmountPaid.Value = [Form_Frm_Customer]![Payments] [Form_Frm_Customer]![Payments Due By].Value = Date + 7 End Sub It updates all the fields...

Hope this explains hi I have attached a screenshot of the main customer screen. You will see 2 sub forms. 1 shows each publication for that customer - which day they want delivery and how many and the other shows if they have a holiday and where the date is inputted. Now if only a single...

Hi Im currently building a database which holds customer delivery options, quantities, unit and delivery price and so on. It has all been going fine until now...! I am trying to setup the billing aspect. My main headache is that each customer could have a delivery every day, of different...

hi one thing i have done is make my sub form into a query with the query doing the calculation for me - i then made a form with the query. You should be able to add the 2 sub forms together ok this way

I have a main customer form that displays all information for that current customer - There is a button for add new record which then gives the blank screen with all the fields empty. What i want t to do is when the add new record button is clicked various input box pops up asking for name...

works fine now many thanks for your help

ok mate - ill give it a go and let you know how i get on

hi tried that but: If the addresses were 12 bedford 13 bedford 7 beresford It would put the beresford address in the middle of the 2 which isn't right. Is there any other to make it order on exact match or something cheers for your help