Search results

Thank you very much, x = [Paid_Until] as per form below.

Good morning, i need to set a date depending on weekly, monthly or yearly. is this correct, ******************************************************** =IIf([Product_ID]="4",DateAdd("ww",1,[Order_Date]),IIf([Product_ID]="5",DateAdd("m",1,[Order_Date]),DateAdd("yyyy",1,[Order_Date])))...

Thank you very much, it works perfectly. May i ask you one more question, please? i want to set the paid_until day automatically, only weekly & monthly changes, all other entries are for a full year. I used in the lost focus event of date_paid the following code...

thank you very much, so easy if you know...LOL Many thanks again Sepp PS will fix Naming Sepp

the price could change in the future Sepp

i thank you, so how can i fix it, the person entering should see the correct price again i thank you for helping me Many thanks Sepp

SORRY again, here is the file

Sorry my mistake, I will send it to you asap

Dear June7, i enclose a zip file (Mercury.dbs) and the form involved is frmPayments with sfrmPayments i am selecting a Type from tblScale into tblPayments, and want to update the correct amount also, the date is the current date, the date until is as follows "...

further to above

Dear ebs17, i thank you very much for your kind help, could you please elaborate on your last sentence? Many thanks Sepp further i an error too few parameters

I just entered the above, but, it still turns red INSERT INTO tblPayments ([Product Value]) SELECT [AMOUNT] FROM tblScale WHERE tblScale.[ID] = tblPayments.[Product ID] Thank you for your help Sepp

Thank you very much, INSERT INTO tblPayments ([Product Value]) SELECT [AMOUNT] FROM tblScale WHERE tblScale.[ID] = tblPayments.[Product ID] Is this correct? Many thanks Sepp

Private Sub Product_ID_AfterUpdate() INSERT INTO tblPayments ([Product Value]) SELECT [AMOUNT] FROM tblScale WHERE tbl.Payments.[Product ID] = tblScale.[ID] End Sub Please help with this, i have not used Access for many years. how do i write this correctly? Many thanks Sepp