Recent content by cuongvt

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...

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

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"...

It works, but new problem ocurred thanks. It works. But new problem occured: when I went to last record, and then go to new record (newly created and have nothing inside record) error massage occureds. Could you see my attached jpg zip file and guide me how can I do to solve? thanks

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 =...

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...

I set total field of that form to: Sum([deliveryquantity]) Between DateSerial(Year(Date()),Month(Date()),1) And Date() but it don't work. I'm sorry, could you describe how to do it in detail, I'm new to access. (note that it is a form, not a query) many thanks

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...

thank you, but I found the solution: use: dateadd("m",-1,date()) in criteria of date field. thanks anyway.

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...

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...