Recent content by parara

  1. P

    query problem

    OK. I have 3 tables because , i have 1 order. For this order i must pay my supplier , the driver , and the person who make the sale. So , i am using 1 table for supplier payment , 1 table for drivers and 1 for sales-man. When i pay , i use different bank-account . Each bank-account can be pay a...
  2. P

    query problem

    Hi to anybody , here is my problem. I have 3 tables , t1 with fields (t1ID , orderID , custID , date , amount , logID) t2 with fields (t2ID , orderID , mesiID , date , amount , logID) t3 with fields (t3ID , orderID , driveID , date , amount , logID) I am trying to create a query with following...
  3. P

    Record count in SubForm and how i can ....

    To ajetrumbet IN SUBFORM In first record i select a product and then put value in field "Quantity" . If cursor stay in this field the code works. The "Quantity" value saved in a table , and also increase the "StockRoom1" field in another table. Now , when i change record (in subform) and dont...
  4. P

    Record count in SubForm and how i can ....

    Hellos , Yesterday i test your code. Works greate. Thank you very much. Just a small problem. In a row (a record in subform) i have 5 fields. When i put value in fields and the cursor is on the last fields , the code works correct and the value stored. When i put value in last field and then...
  5. P

    Record count in SubForm and how i can ....

    Hello , The method i used is If Forms!Purchase.PurchaseDetails!Quantity <= 0 Then Forms!Purchase.PurchaseDetails!StockRoom1 = Forms!Purchase.PurchaseDetails! StockRoom1 Else Forms!Purchase.PurchaseDetails!StockRoom1 = Forms!Purchase.PurchaseDetails!StockRoom1 +...
  6. P

    Record count in SubForm and how i can ....

    Ok , In SubForm i have the fields IDProcuct , Product , Quantity (these fields from table "PurchaseDetails"). When i have one record (one row) with these information and save this record , i take the number in Field Quantity and save it in another table. This i can do it. NOW , how can take the...
  7. P

    Record count in SubForm and how i can ....

    Hi , Each record in subform has information (IDProduct , Product , Quantity ) I want to store the Quantity for each IDProduct (each record) in a table. I can do it for one record , but what i have to do when records are more. When i take information from first record , i must moved to next...
  8. P

    Record count in SubForm and how i can ....

    Hello , I have a subform "PurchaseDetails" into a form "Purchase" How i can count the records (how many) are in subform. (i am using i = Forms![Purchase]![PurchaseDetails].Form.RecordsetClone.RecordCount) Is this correct? And how can reffering into one of the record (from the begin to end)...
  9. P

    Code to UPDATE table

    Hi again and thanks for your reply. I try it again and i take message " Ms Access can't found the field name 'SalesDetails'. Bat in my Database 'SalesDetails' is the subform name. Dim SQL As String Dim intNewQtyTest as integer Dim intProdIDTest as integer intNewQtyTest =...
  10. P

    Code to UPDATE table

    Hi, the field 'NewQuantity' is in a subform and has an integer. This value i want to store it in table 'products' , field 'StockRoom1'. I have try with following: Dim SQL As String DoCmd.OpenForm "SalesDetails", , , , acFormReadOnly SQL = " UPDATE Products " & _ "...
  11. P

    Code to change value in table

    Hello , i have an open form (sale) , with subform (salesDetails). In subform i have a field (NewQuantity). How i can store the value of field "NewQuantity" , in table "Products" , field "StockRoom1". Can i do that with UPDATE and how? Thanks
  12. P

    Code to UPDATE table

    Hello , i have an open form (sale) , with subform (salesDetails). In subform i have a field (NewQuantity). How i can store the value of field "NewQuantity" , in table "Products" , field "StockRoom1". Thanks
  13. P

    Code to change value in table

    This is my database , take a look. Thanks
  14. P

    Code to change value in table

    No its not working. The 'sale' form has the following fields (CodeProduct , Description , Quantity , Price ). When i am sale a product , the Quantity must decrease the number in field Stock1 on table Product. In the same form 'sale' can be one or more records. Each recordset Quantity must...
  15. P

    Code to change value in table

    Hi , I know this method bat i dont want to see the message which displayed when the UPDATE QUERY execute
Top Bottom