Search results for query: *

I have found the solution myself. The problem being that the execution ran too fast and that the previous steps cannot be committed before the next steps kick in. I have tried using a timer to pause the execution for 5 second and use the DoEvents to allow the procedures in the memory to be...

Yes, of the 2000 records, only 200 records were published to the worksheet successfully. The program continue to run but only empty worksheets were created. The program is very long but basically, it just use ado recordset to fetch records from a query and then put data in each record onto an...

I used ado recordsets to fetch data from an access 2003 queries into excel spreadsheets. The module will automatically open a Excel template and populate the data from Access onto 3 different spreadsheets and then print the workbook directly to adobe pdf file. The program only successfully...

Thank you so much. I will give it a try.

Hi, My query is trying to update the information for those employee who are on leave in the past but change back to "Active" now. I have all the old records for all the employee in the same table and when the new records come in, I need to update the old records by changing the ToDate field...

Hi, I have an update query which update the date field with the current system date but the query returns zero. Can somebody please see if there is anything wrong with my code? UPDATE tblEmpChange SET tblEmpChange.ToDate = Date() WHERE tblEmpChange.[cur_Status] Like '*Leave' and...