Search results for query: *

Originally I did have dbOpenSnapshot Thanks for your help

Public Function ProcessReportInfo(StrEmpNum, StrLast, StrFirst) Dim StrDeptAbs As String Dim StrDeptTot As String Dim RstDeptVac As Recordset Dim RstDeptAbs As Recordset Dim RstDeptTot As Recordset Dim StrDeptNum As String Dim StrDeptDate As String Dim DeptCount As Integer Dim VacCount As...

one thing I forgot to mention is that when I step through the code it processs 3 records, the first 2 dont require the insert into temp table, so it go through both sets of loops twice. On the third record it requires and insert and then when it returns to the first module it gives me the...

This is the process of my code sql1 = select employeeID from employees where dept = 34 Set recordset1 = workspace.OpenRecordset(Sql1,dbOpendynamic) recordset1.Movefirst Do while not recordset.BOF and Not recordset.EOF call processInfo recordset1.MoveNext...

I am trying to build a report that gets info from one table to get a ID number and then looks at another table to get totals, and then looks at a third to get info to calculate using the totals from table 2. I have built the nested If then else statements and when I step through the code it...