Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Run-time error '3265' (Access 2000 ( 9.0.6926 SP-3 ).)

    Up until today, because it's really important that it works today, I've used a program called QBF.mdb that was created by Ken Getz a number of years ago. It takes a form and sets it up under a new name so that it can be used for searching purposes.

    When I attempted to use it this time, I got the message:

    Run-time error '3265':
    Item not found in this collection

    This error occurs within all databases within my system including Ken's original sample database. I'm using
    Access 2000 ( 9.0.6926 SP-3 ).

    The following is the code and it hangs on the line:

    strName = docs(strName).Name

    Where am I going wrong? Would appreciate any help.

    Do While True
    strName = docs(strName).Name
    ' If there was no error, that means there's already
    ' a form by that name. Keep looking.
    If Err.Number = 0 Then
    intI = intI + 1
    strName = strFormName & conQBFSuffix & intI
    Else
    Exit Do
    End If
    Cheers,
    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Run-time error '3265' (Access 2000 ( 9.0.6926 SP-3 ).)

    Have you changed the way VBA errors are handled?
    - Activate the Visual Basic Editor.
    - Select Tools | Options...
    - Activate the General tab.
    - Make sure that Error Trapping is NOT set to "Break on All Errors". The 3rd option (encircled in the screenshot below) is the preferred setting.
    Attached Images Attached Images
    • File Type: png x.png (14.2 KB, 0 views)

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Run-time error '3265' (Access 2000 ( 9.0.6926 SP-3 ).)

    Hans, Hans, Hans,

    What can I tell you? You have once more enabled me to remove coding egg from my face. Thanks so much,

    Andy
    Cheers,
    Andy

Posting Permissions

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