yippie_ky_yay
Registered User.
- Local time
- Yesterday, 22:35
- Joined
- Jul 30, 2002
- Messages
- 338
Hello all,
I needed to create a table of contents like in Q131588 on the microsoft site. I had no problem creating this in the Northwind db, but I can't seem to get it to work on my own.
When I do try, I get "error 13 - Type mismatch" and it focuses on where I try to open the table:
Set toctable = db.OpenRecordset("Table Of Contents", DB_OPEN_TABLE)
The only difference I ever noticed between creating it the first time for practice and the real time was when I declared toctable as Recordset. When I wrote it in Northwind, Recordset was offered by VB once - but when I wrote it the second time, "Recordset" was offered twice in a row?!? Does this mean anything?
Thanks - I appreciate all help (even clarification on why VB would offer "Recordset" twice)
-Sean
PS when I say that VB "offered" it I'm talking about the options that pop-up as you write code.
I needed to create a table of contents like in Q131588 on the microsoft site. I had no problem creating this in the Northwind db, but I can't seem to get it to work on my own.
When I do try, I get "error 13 - Type mismatch" and it focuses on where I try to open the table:
Set toctable = db.OpenRecordset("Table Of Contents", DB_OPEN_TABLE)
The only difference I ever noticed between creating it the first time for practice and the real time was when I declared toctable as Recordset. When I wrote it in Northwind, Recordset was offered by VB once - but when I wrote it the second time, "Recordset" was offered twice in a row?!? Does this mean anything?
Thanks - I appreciate all help (even clarification on why VB would offer "Recordset" twice)
-Sean
PS when I say that VB "offered" it I'm talking about the options that pop-up as you write code.