Search results

  1. 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...
  2. 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)...
  3. 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
  4. 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
  5. P

    Code to change value in table

    Hello , I have a database name "sales". In my database , when i am doing any sale of product i want to update the stock value in table "product" by quantity which sale. Any ideas about updating these values? Table product has (IDProduct , ProductDescription , Price , Stock1 , Stock2 ). Thanks
Top Bottom