1,105,290 Community Members

adodc -2147... (80040e21) error

Member Avatar
mklove999
Newbie Poster
4 posts since Dec 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Run-time error '-2147217887 (80040e21)'

Multiple-step operation errors. Check each status value.

===
The one highlighted was: Adodc2.Recordset.Update

Private Sub Command1_Click()

Adodc2.Recordset.AddNew
Text13.Text = Label19.Caption
Text14.Text = Label15.Caption

Label5.Caption = Text6.Text + "-" + Text7.Text
Label3.Caption = Text1.Text
Label21.Caption = Text10.Text
Text11.Text = Text6.Text

Label17.Caption = Text3.Text + ", " + Text4.Text + " y " + Text5.Text

If Option1.Value = True Then
Text2.Enabled = False
Label7.Caption = Option1.Caption
ElseIf Option2.Value = True Then
Text2.Enabled = False
Label7.Caption = Option2.Caption
ElseIf Option3.Value = True Then
Text2.Enabled = False
Label7.Caption = Option3.Caption
ElseIf Option4.Value = True Then
Text2.Enabled = False
Label7.Caption = Option4.Caption
ElseIf Option5.Value = True Then
Text2.Enabled = False
Label7.Caption = Option5.Caption
ElseIf Option6.Value = True Then
Text2.Enabled = False
Label7.Caption = Option6.Caption
ElseIf Option7.Value = True Then
Text2.Enabled = True
Label7.Caption = Option7.Caption
Label8.Caption = Text2.Text
End If

Adodc2.Recordset.Update
End Sub

====
Any opinions are appreciated, I'll just try. thanks. I'm just newbie here

Member Avatar
AndreRet
Industrious Poster
4,492 posts since Jan 2008
Reputation Points: 362 [?]
Q&As Helped to Solve: 499 [?]
Skill Endorsements: 24 [?]
 
0
 

I am presuming that your text boxes is linked to your data control?

The error is refering to incorrect data to your table in your database, i.e. if one of your fields will only accept a date or a number, but the textbox contains something else than that, the error will be raised. Make sure that the data send to your database is as requested by it in the correct formats...

Post the data that you are trying to add as well as the fields in your table.

Question Answered as of 1 Year Ago by AndreRet
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: