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

    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)


    I have tried checking for errors

    if Not list Is Nothing Then


    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.


  2. #2
    Join Date
    Dec 2004
    Madison, WI
    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