-
Run time error 91...
I get a runtime 91 error from these lines of code:
------------------------------------------------------------
Option Explicit
Private Sub ComAddRecord_Click()
Adodc1.Recordset.AddNew <-----------------------
End Sub
Private Sub ComDeleteRecord_Click()
Adodc1.Recordset.Delete <---------------------
Adodc1.Recordset.MoveNext
End Sub
Private Sub ComNextComic_Click()
If Not Adodc1.Recordset.EOF Then <--------------------
Adodc1.Recordset.MoveNext
End If
End Sub
Private Sub ComPreviousComic_Click()
If Adodc1.Recordset.BOF Then <------------------
Adodc1.Recordset.MovePrevious
End If
End Sub
I left my adodc1 as its "stock" name.
I took this code from a working project, and yes this was all the code except
for some code that added up some totals.
I dont ahave access to that progie now tho...
HERE IS LISTED ERROR:
Object variable or With block variable not set (Error 91)
My database (access2000) seems to be fine, and when I test for connection
it says it passed. That is my whole code... wanted to start with something
small.
ADODC1 settings:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Comics.mdb;Persist Security
Info=False
rescource type
2. command type: adcmdtable
table or stored proceedure name:
comics <----- databases table name
If you need anymore info... let me know...thanks!(Yes, I am a student JUST
starting out!!!)
Any help would be greatly apreciated!
Lobo
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks