3 Replies - 1544 Views - Last Post: 20 July 2011 - 06:52 AM Rate Topic: -----

#1 dongodu   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 64
  • Joined: 30-March 09

Run time Error'3201'

Posted 20 July 2011 - 01:40 AM

Private Sub lau()
Dim cnuser As New ADODB.connection
Dim rsupdate As New ADODB.Recordset
Dim reply As String

  
    Call connection(cnuser, App.Path & "\Medrar.mdb", "endromida")
    'Call connection(cnuser, "\\mika\medrar\Medrar.mdb", "endromida")
    Call Recordset(rsupdate, cnuser, "SELECT condi,vali FROM reser where condi = 'محجوز' and vali = #" & Date & "#")
       
  
    With rsupdate
    Call ex
    .Fields!condi = txtExp.Text
    .Update
   
Set cnuser = Nothing
Set rsupdate = Nothing
End With
End Sub


EOF or BOF

Is This A Good Question/Topic? 0
  • +

Replies To: Run time Error'3201'

#2 raziel_   User is offline

  • Like a lollipop
  • member icon

Reputation: 469
  • View blog
  • Posts: 4,281
  • Joined: 25-March 09

Re: Run time Error'3201'

Posted 20 July 2011 - 06:05 AM

what this even means? change this lines
With rsupdate
Call ex
While Not .EOF
.Fields!condi = txtExp.Text
.Update
.MoveNext
Wend
End With
Set cnuser = Nothing
Set rsupdate = Nothing
End Sub


also you should loop your records. what ex do can this error show up in the ex function at what line is the error if its not in the ex function

This post has been edited by NoBrain: 20 July 2011 - 06:08 AM

Was This Post Helpful? 0
  • +
  • -

#3 dongodu   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 64
  • Joined: 30-March 09

Re: Run time Error'3201'

Posted 20 July 2011 - 06:30 AM

Not Updating Records in DB...when add While not .eof, just jump to another function
Was This Post Helpful? 0
  • +
  • -

#4 dongodu   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 64
  • Joined: 30-March 09

Re: Run time Error'3201'

Posted 20 July 2011 - 06:52 AM

Getting this Error now
http://www.dreaminco...run-time-error/
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1