1 Replies - 1494 Views - Last Post: 29 September 2010 - 03:15 AM Rate Topic: -----

#1 Guest_maris*


Reputation:

Display records upon searching

Posted 29 September 2010 - 01:15 AM

I got an issue to code the display data records (from database) upon performing record searching. Have try to use the code (as per below), however it keeps return error 3021 No Record Found:

With dbsYamal
rstAhliPersonal.Index = "PrimaryKey"
rstAhliPersonal.Seek "=", Kelas

Kelas = rstAhliPersonal.Fields("ahli_Kelas")
IC = rstAhliPersonal.Fields("ahli_IC")
Name = rstAhliPersonal.Fields("ahli_Name")
KodACT = rstAhliPersonal.Fields("ahli_KodACT")

While rstAhliPersonal
Do Until rstAhliPersonal.EOF
For Each fldAhliPersonal In rstAhliPersonal
If Kelas = rstAhliPersonal.Fields("ahli_Kelas") Then
ahli_kelas.Text = stKelas
ahli_IC.Text = stIC
ahli_name.Text = stName
ahli_kodACT.Text = stKodACT

Else
Answer = Yes
End If
Next
rstAhliPersonal.MoveNext
Loop
Wend
End With

Is This A Good Question/Topic? 0

Replies To: Display records upon searching

#2 thava  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 180
  • View blog
  • Posts: 1,606
  • Joined: 17-April 07

Re: Display records upon searching

Posted 29 September 2010 - 03:15 AM

i didn't know what you are try to do ? when you post your question please post the code section between the

tag
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1