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

    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
    Code:
     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_dettaglio_Click:
        Exit Sub
    
    Err_dettaglio_Click:
        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?

    P.s.
    if I add
    Code:
    Doevents
    , after
    Code:
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    the error doesn't appear


    Thanks in advance, Francy

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    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
  •