Hi -
I've used this code hundreds of time w/o a problem, but today is a new day. I keep getting a Type Mismatch error when I run:
Dim CurDb As Database
Dim rTmpNotes As Recordset
Dim sSQL As String
Set CurDb = DBEngine.Workspaces(0).Databases(0)
'open Temp Ship notes table
sSQL = "SELECT * FROM _TmpShipNotes"
Set rTmpNotes = CurDb.OpenRecordset(sSQL, dbOpenDynaset)
The error occurs on the last line.
Any suggestions would be WONDERFUL!
Thanks
I've used this code hundreds of time w/o a problem, but today is a new day. I keep getting a Type Mismatch error when I run:
Dim CurDb As Database
Dim rTmpNotes As Recordset
Dim sSQL As String
Set CurDb = DBEngine.Workspaces(0).Databases(0)
'open Temp Ship notes table
sSQL = "SELECT * FROM _TmpShipNotes"
Set rTmpNotes = CurDb.OpenRecordset(sSQL, dbOpenDynaset)
The error occurs on the last line.
Any suggestions would be WONDERFUL!
Thanks