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

    Unanswered: form: onOpen error

    I have a application splitted in BE and FE; the FE play on few PC with so XP sp2, and the BE on one server within the company.

    we use this application many times without errors, but unexpected when I push a button that open a subform
     On Error GoTo Err_dettaglio_Click
        Dim stDocName As String
        Dim stLinkCriteria As String
        stDocName = "_D01_D_qua"
        stLinkCriteria = "[ID_qua]=" & ListaQuadri.Form!ID_Qua
        DoCmd.OpenForm stDocName, , , stLinkCriteria 
        Forms![_d01_d_qua].Caption = "Dettaglio: Dich. n " & Forms![_d01_d_dic]!N_dic & " del " & Forms![_d01_d_dic]!Anno_imp
        Forms![_d01_d_qua]!cod_fis = Forms![_d01_d_dic]!cod_fis
        Forms![_d01_d_dic].Visible = False
        Exit Sub
        MsgBox Err.Description
        Resume Exit_dettaglio_Click
    Access crash, with this system error:
    Faulting application msaccess.exe, version 11.0.8166.0, stamp 46437912, faulting module msjtes40.dll, version 4.0.8618.0, stamp 403430ac, debug? 0, fault address 0x00009065.

    Can anyone help me please?

    if I add
    , after
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    the error doesn't appear

    Thanks in advance, Francy

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Anything that causes Access to crash like that is usually a result of corruption. Try things like /decompile and/or create a new database and import all your objects into it.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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