Run-time error '3265'

" Item cannot be found in collection corresponding to  the requested name or ordinal "

Hello Guys,if  this error will came out when  youre running your program, the cause of this
problem is on your database or on your procedure on how you to fetch the data from the
database,here a sample procedure that makes error when fetching data from database:

        With Lv1
        .ListItems.Clear
            Do While Not rs.EOF
                Set Panoy = .ListItems.Add()
                    Panoy.SubItems(1) = rs!L_Name
                    Panoy.SubItems(2) = rs!FName
                    Panoy.SubItems(2) = rs!Course
                   rs.MoveNext
            Loop
        End With

and some cause of this is,if you mis-spelled the

column name,on the example above i got the error on line 6 where Panoy.SubItems(2) =
rs!FName, instead of rs!F_Name i forgot to put a underscore, then i run the program,this is
error is my award,after analyzing the problem i found out this reasons.

  Note: Make sure when you are typing or declaring
variables,procedures and statement,make sure that you
type their correct syntax:

Happy Coding ^_^
The Hardest Thing to DO is to Do Nothing  ^_^
These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • Furl
  • Reddit
  • Spurl
  • StumbleUpon
  • Technorati

Leave a comment

Copyright @ Codes-47.Blogspot.Com. Powered by Blogger.