R
Rich Mogy
I have created a report takes a report form template and creates an .snp
file for each timekeeper. I get my timekeeper list using the following
snippet of code
Dim strSQL, conn1, lstRptName As String
Dim db As Database
Dim rst, oRS As Recordset
Set db = CurrentDb
strSubject = "Stripped Down Countdown"
Set rst = db.OpenRecordset("select distinct head1 as mbillaty from
dbo_prj_cash_base, dbo_matter, timekeep, dbo_client where clnum=mclient and
mbillaty=tkinit and mmatter=matter and mprac< 1000 group by head1 having
sum(togo_fees)> 49")
This worked fine last year, when created, but this year when I run it, it
stops with an error message "User-type not defined and highlights the "db as
database" part of the dim statement.
I checked all my references and they appear to be unchanged and there are no
missing references. But apparently I am missing something. Please help.
Thanks in advance
Rich
file for each timekeeper. I get my timekeeper list using the following
snippet of code
Dim strSQL, conn1, lstRptName As String
Dim db As Database
Dim rst, oRS As Recordset
Set db = CurrentDb
strSubject = "Stripped Down Countdown"
Set rst = db.OpenRecordset("select distinct head1 as mbillaty from
dbo_prj_cash_base, dbo_matter, timekeep, dbo_client where clnum=mclient and
mbillaty=tkinit and mmatter=matter and mprac< 1000 group by head1 having
sum(togo_fees)> 49")
This worked fine last year, when created, but this year when I run it, it
stops with an error message "User-type not defined and highlights the "db as
database" part of the dim statement.
I checked all my references and they appear to be unchanged and there are no
missing references. But apparently I am missing something. Please help.
Thanks in advance
Rich