Recent content by FahadTiger

I Know that to use docmd.RunSQL " UPDATE..." thanks for your response

Hi my Expert.. I have button to select or deselect all OptionButton in continuous form and change its caption ...but its select just first OptionButton ..not all OptionButton Private Sub cmdSelectAll_Click() ' Toggle the state of OptionButton1 Me.OptionButton1.Value = Not...

the user enter any new item from the combobox in the sub form and after update event I used function Dlookup to get me last price from the Query that you are did it for me..if new item i get value zero in the textbox of last price

thank you ..its fixed from @June7

i did that and enter a new item in subform and give the last price=0 ..and that what I need ..thank you

thank you so much @June7 ..its working perfect

Hello My Expert I have tblPurchase with PurchaseID AS primary key and purchaseDate and tblPurchaseDetail with PDID AS primary key and PurchaseID as number and ItemID AS number and purchasePrice as currency...what I want the latest purchasePrice for each Item according to latest purchaseDate any...

Thank you All for response ...I dont Know why Im not use NZ Its perfect Now

this is my sample.. when No currency type in Euro gave me Error

Hi Expert.. I used module to sum Amount according to CustomerNumber And CurrencyType its working Good and give me the Result im main form of saleInvoice but..when there are No Records in the table give me Error "invalid use of null".. in "TotalAmount = rs!TotalAmount" How can I FIX that...

I think I was stupid in explaining this... I wanted to count from the one in each invoice .. I was wrong in relying on the itemcod because it bears the number zero and is not null

i did...but its not working...thank you It was my mistake because I used a field equal to zero and not Null

its perfect ...thank you

Sir part hartman ... All I want is a new numbering for each sub-invoice starting from the one