Search results

Hii all dears I have a store db , tblInvoic : -InvoiceID -InvoiceDate -CustomerID -DiscountAmount (Long data-type) tblInvoiceDetails -InvoiceNo -ItemID -ItemPrice -Quantity -ItemDiscount (Percentage) of (ItemPrice multiplied by Quantity). some sellers offer a discount on the total value...

of course .... yes

i try all this way but it can't update the textbox on the main form without move the record pointer to the first ......

Yes, I forgot, it was more than 7 years ago. Greetings to you

very thanks , it sloved

My dates formula is dd,mm,yyyy

it gives me wrong results what the correct expression?

hii al dears i have this expression : PersonA: CLng(nz(Dcount("OrderID";"Q105";"InsurCmpName=13" & " AND [OrderDate]>= #" [FirstDayVal] & "# AND [OrderDate] <=" # [LastDayVal]);0)) Can you hlep me to correct this expression ?

the problem of requery and recalc is when user insert new record on the sub form it jumps to the first record on that subform ....

???? Help please

wait , the subform is continuous , and i use keyboard arrows to move between its records , on that subfrm there combobox cboItemNo , i move to tha new record by using keybord arrows down to insert new record , when i use requery or recalc it jumps to the first record on that subform .

plz understand me . the txtT2 textbox is on the main form to gives me the total of a PriceService field on the subform . what this code and under which event ?

txtT2 textbox is bound to this expression : =CLng(nz(DSum("PriceOFSer";"OrderDetailTbl";"OrderNo=" & [OrderID] & " AND TitleServi=" & 2);0))

yes of course .

i try it , but it return to the firsr record on that sub form

under which event ?

yes txt2 on the mainform , bound to an expression

i try that code under the itemid after update , then under the subform after update but it didn't update the txt2 textbox .

hii dears on main form a textbox ( txt2 ) to gives me the total of subform some field how to requery that textbox ( txt2 ) after user add new item on the sub form without return to the first record on the subform ?