Search results

  1. M

    ms access sub from value to main form

    please help to resolve the issue.
  2. M

    Display Account balance on Main form from sub form transactions

    Main form : frmMain Sub form : tblInventoryTransactionSubForm unbound box name : txtTotalQuantityinStock
  3. M

    Display Account balance on Main form from sub form transactions

    =[Forms]![frmMain]![tblInventoryTransactionSubForm].[Form]![txtTotalQuantityinStock] - getting error
  4. M

    ms access sub from value to main form

    sub form value required to be on main form only total, giving error with above. please suggest.
  5. M

    ms access sub from value to main form

    1- =[tblInventoryTransactionSubForm].[Form]![Text83] getting error on this 2- also want to know that is it possible to make like data validation in excel. if possible can create error or pop up windows on validation.
  6. M

    mabino79201

    =[tblInventoryTransactionSubForm].[Form]![Text83] getting error retrieving value from sum form in main form
  7. M

    mabino79201

    is this solve the =DSum([Qty],[tblInventoryTransaction]![ProductCode]=[ProductCode])
  8. M

    mabino79201

    have Sub Form containts product ID & Qty Want total of Qty which product selected on main form.
  9. M

    create inventory in Access

    the sample was like this
  10. M

    create inventory in Access

    in the sample there is only one table for all transactions like Purchase (+), Sale & Reserve (-) the same i took
  11. M

    create inventory in Access

    it will be same like sale, but the invoice details will added later only
  12. M

    create inventory in Access

    than can you suggest, how can i complete this
  13. M

    create inventory in Access

    have created in Report can you tell me how can i get the sum of the same products row selected from Sub Form on main form
  14. M

    create inventory in Access

    have done with below query SELECT tblProducts.*, tblVendor.VendorName, tblFolio.*, tblFolioType.*, IIf([tblFolioType]![TypeofFolio]="Purchase",[tblFolio]![Qty],-[tblFolio]![Qty]) AS ActualQty FROM tblVendor INNER JOIN (tblProducts INNER JOIN (tblFolioType INNER JOIN tblFolio ON...
  15. M

    create inventory in Access

    Yes Yes
  16. M

    create inventory in Access

    thanks for your valuable advise, have done all the changes as advised.
  17. M

    create inventory in Access

    have created the Purchase but not able to figure out to make Sale and reserve
  18. M

    create inventory in Access

    no matter who is ordering, just want to make for the stock update, how much stock is available in the stock presently. Reserved will be deducted from the current stock only, later on it will be converted into Sale.
  19. M

    create inventory in Access

    no matter who is ordering, just want to make for the stock update, how much stock is available in the stock presently. Reserved will be deducted from the current stock only, later on it will be converted into Sale.
  20. M

    create inventory in Access

    yes, i have seen that but that need more modification Input in Purchase : Date, Product Code, Qty Input in Reserve : Date, Product Code, Qty Input in Sale : Date, Product Code, Qty
Back
Top Bottom