I made a database project. when I run it another pc and press the
Add New button (in my project) it show this msg.
Run time error - 91
Object variable or with block variable not set.
I connect the backend database by data sources(ODBC)> system DSN.
I write code in Add New button, "adodc1.recordset.addnew"
anybody help me.

another error:
when I select a date from dtpicker and then press a button for show
report then show this error.
run-time error 713
Application-defined or object-defined error

Recommended Answers

All 12 Replies

have you created the DSN in the target system to connect to database ?

ya I did.

anybody help me please

Plz post the procedure u have coded for the AddNew button.

and for the other error also for the Show button

I dont understand your ......... I think I told it. or please make me understand

I asked to post your code here which u have written for Addnew Button. and also the rror u get for ur show button.

just copy the vb code and paste it here in the reply to the thread.

>>for 1st error
Private Sub chameleonButton1_Click(Index As Integer)
Adodc1.Recordset.AddNew
End Sub

>>for 2nd error
Private Sub chameleonButton11_Click(Index As Integer)
Load DataEnvironment1
With DataEnvironment1
If .rsCommand1.State <> 0 Then .rsCommand1.Close
.Command1 Format(DTFr.Value, "dd-mm-yyyy"), Format(DTTo.Value, "dd-mm-yyyy")
End With
DataReport1.Show
End Sub

u didn't post the error msg. plz post the error msg also.

I write it above. in 1st post I think I write. Please

1st error
Run time error - 91
Object variable or with block variable not set.

2nd error:

run-time error 713
Application-defined or object-defined error

any body can help me please

help me.........

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.