Search results

  1. M

    creating BOM

    Dear all I need to create a Bill Of Material (BOM) in MS access but there is some issue want to discuss first. The product will be created with an Assembly of 5 accessories, there will be two branches with the same product code but when we stock out or send it to manufacturing the stock...
  2. M

    MS ACCESS DB FOR TOURNAMENT MANAGEMENT

    i need to make a database to manage tournament of Tenis, please suggest if the below will work, found on google.
  3. M

    search description txtbox not showing all items

    SELECT tblInventoryTransaction.ProductCode, Sum(tblInventoryTransaction.ActualQty) AS SumOfActualQty, tblTransactionType.TransactionType, tblInventoryTransaction.Ref_no, tblInventoryTransaction.DateofTransaction, tblInventoryTransaction.ProductCode, tblInventoryTransaction.Qty...
  4. M

    if Qty Value is zero or less than

    is there a way to do if Qty Value is zero or less than, the row from the report should be deleted or hide.
  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

    create inventory in Access

    Dear All, Thanks for all the support given. i need to create an Access database where i can do as follow :- Products - can be purchased than make reserved for some project & if required to sale will be deducted from the stock. Current Stock Qty = Purchase - Reserved (too deducted from...
  7. M

    mabino79201

    adding two query in one but getting duplicate records. SELECT [qryReserveFolio Query].Product, [qryReserveFolio Query].Qty, qrySalesFolio.Qty FROM [qryReserveFolio Query], qrySalesFolio; can anyone help, as its showing duplicate values/ rows
Top Bottom