Search results

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 ?

i could not give the same control subform for more than one subform on that same Mainform .... could you gives me some example ?

Coul Could you explain step 1 or change my code to meet my request

hii all i have a main form with a tab , 9 sub forms i notice navigation between records become slow , then i search for a solution , i find this code : Private Sub ps_Change() Select Case ps.Pages.Item(ps.Value).Name Case "pg1" ' Where sfrm1 is the name of the subform on page 1 If...