Search results

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

the Error at last Row ...when No rcord

Hi Expert when Im trying to renumber of sub_form for every new invoice ..i used this for control source of unbound textbox =IIf(IsNull([ItemCode]);Null;Nz(DCount("ItemCode";"SalesOrderDetailsT";"SaleID=" & [SaleID] & "AND SaleOrder <" & [SaleOrder]);0)+1) its work good..but I Get Error at the...

Thank you very much for the quick response Yes, this is exactly what I want..I knew how to get customer data by querying..My problem was with adding the address or phone number..I used the RunSQL method. But it works wrong . DoCmd.RunSQL "INSERT INTO CustomerT ([Address] )VALUES (" & txtAddress...

Hi Expert.. I have a sales form..when I type the customer's name..it brings me the address and mobile number automatically And when its not exit...I will enter the address and mobile phone in their respective text boxes and they are added to the customers table Any Advice

yes.. that what I want thanks arnelgp You did a good job for me..and I thank you very much How do I hide the empty fields?