Search results

  1. C

    open dialogbox to select excel file to import to mdb

    i have this small code to import excel data into mdb file: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _ "datapub", "D:\datapubcolumnar.xls", True, "datapubcolumnar!" But I want to improve by call a dialog box for user to choose excel file. Could anyone can write this code...
  2. C

    maximum number of records

    hi all, This is general question only. How many number of records that Access can handle as a maximum records? Or it only depend on size limit (4GB)??? thanks
  3. C

    .requery qustions

    I have two simple questions: 1) Force a control in the subform of mainform to recaculate: I have a mainform named "products" and 04 subforms inside named: "InventorySubform" subform of the table "Inventory summary" "SubDelivery" subform of the table "delivery control" "Stockout Subform"...
  4. C

    newbie:enter an expression that has no value

    I have "limit" control on the mainform and "currentremainedsubform" subform that have a source is "currentremainedquantity" query. On current event: I added below codes: Private Sub Form_Current() If Forms!products!currentremainedSubform.Form!Remaine d > Me.limit Then With Me.ALERT .Visible =...
  5. C

    newbie: calculation related mainform and subform only on current month

    I have a stock control database. I created a query to find out total remained quantity of each product on only current month by using the delivered quantity on current month to subtract the quantity took out from the stock on current month. It works fine as I want. But now I want one more...
  6. C

    how to display quantity of those records are only on current month

    I have a form "delivery control" with 3 fields: 1. productid 2. date delivered 3.deliveryquantity I create an unbound field in its footer and set it by =Sum([deliveryquantity]). And the total quantity of all products in all time is displays. But I want it to display sum quantity of those...
  7. C

    newbie question: query only the records are in current month

    I've tried out in query's criteria of date filed: "month(now())", but it not works. Could you guide me how to query only the records of current month? For example: In case of this month: I only want the record for August. But in case of next month, I only want the records for September. many...
  8. C

    newbie question: multiple and deduct data retrieved from subform

    Hi, I have a main form named product with 3 subform: Initialstock, take in, take out I created a text box named "remained" in mainform and want to sum the Initialstock with take in, and then deduct the take out by this: =InventorySubform!initialstock+SubDelivery!shiped-[Stockout Subform]!out...
Back
Top Bottom