Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OpenRecordset error

Status
Not open for further replies.
djj55

djj55

Programmer
Feb 6, 2006
1,761
0
0
US
Hello, Access 2002
I have a table "tblTempHistory" that I ultimately want to add a new record to, but I can not get past the SET statement.
Code: 
Dim rs As Recordset
[COLOR=red]Set rs = CurrentDb.OpenRecordset("tblTempHistory", dbOpenDynaset)[/color]
I get the error
Type missmatch
Click to expand...
.
any suggestions?
Thank you,
djj
 
Sort by date Sort by votes
Thank you!!! That was the problem, although as usual MS did not mention that in their examples/help.
Thanks again,
djj
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Question
TransferSpreadsheet 3125 Error
Replies
5
Views
223
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Find error in currency feild 2
Replies
8
Views
208
Andrzejek
Andrzejek
Kim296
  • Locked
  • Question
Sending Gmail using vba Send error
Replies
6
Views
236
strongm
strongm
VicM
  • Locked
  • Question
Error when using Immediate window-recent happening 2
Replies
4
Views
111
VicM
VicM
Fino
  • Locked
  • Question
Compile error on Office 365 desktop in 64 bit
Replies
7
Views
137
Fino
Fino

Part and Inventory Search

Sponsor

Back
Top