Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    1

    Unanswered: VB "Run Time Error 3420"

    Hello guys,

    I am in a bad trouble, if some one can answer me that will be very helpful.
    I have never done VB before but i have been doing java & C programming.

    The VB software which is given to me is producing lot of run time errors.
    one of them is "Run time error 3420 , object no longer valid or set".
    On debugging it takes me to the list.Requery line.

    Here is the code

    Set list = sys.OpenRecordset(" list querry", DB_OPEN_DYNASET)

    list.Requery



    I have tried checking for errors

    if Not list Is Nothing Then

    list.Requery

    but still encountering the same run time error 3420

    I just wanna get rid of this Run time error so the rest of the system should be safely running.

    I will be very thankfull to you.

    Regards
    Yas

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Does me.list.requery help? Is "list" also refering to an actual list box or some control other than what you have - perhaps the name itself is a reserved word (I think it is) and giving you problems. Does the name have to be list or can you use another name like List1?
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •