Search results

Memory issue is what I'm guessing! I believe there's no data (type) error, since every time the program failed, if I closed the files and resumed the procedure from the last record, it worked alright and continued to add additional entries to the mdb output file. For the stand alone...

Thanks for your advice. The error always occurs at the same point, when the program tries to add new entry to the 'tbl_supercalc_output' file. Set rstUpdate = New ADODB.Recordset With rstUpdate Set .ActiveConnection = CurrentProject.Connection .CursorType = adOpenKeyset .LockType =...

The whole code is as below, thanks! Option Compare Database Sub RunSupercalc() Dim Path As String, WorkbookName As String, WorksheetName As String, strWorkbookName As String Path = CurrentProject.Path strWorkbookName = Path & "\SUPERCALC Actual.xlsm" Dim objActiveWkbk As Object...

Hello, I have an mdb file that acts like a focal point, which links 7 mdb files, including 6 input files, and 1 output file. The focal mdb file has this code that pulls one row at a time from each of the 6 input files, and feeds the data into an excel model. The excel model then creates one row...