Closing form

  • When closing some forms in MSAccess 2003 Access is crashed (Microsoft Office

    Access has encounteres a problem and needs to close. We are sorry .......).

    If I close form without changes work OK, but when I change and save the form

    then access is crashed, but not always, in 10% working OK. I hawe ower 150

    forms but only a few forms make me trouble, one forms (Continuous Form) have

    link SQL tables as a recordset, one have RO passthrough query as recordset

    (also Continuous Form),.... I make new form (manualy) like problematicaly

    and old forms is deleted but problem rise again. I try decompile, compact,

    repair, I copy all object into new mdb file, but nothing helps.

    Anybody know the solution for this bug ....

    Thanks

  • there has recently been another thread on fixing problems with access databases, you might liek to check that out

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=227550&p=1

     

    martin

  • Thanks for suggestions.

    In my analyzing the problem I found that form work fine if I delete statement Me.Requery from Form event OnOpen. I don't know what happened on that ewent when I close form?

    In that form I initialize record source query (on Open event) and after that I must requery the form to see the result. Now I initialize query in a single function and in the last line with Docmd.Openform open form. Work fine, but I'm not satisfied becouse I don't know what happend on closing form and why that statement 'Me.Requery' crashed MSAccess.

    Uros

  • Try setting the recordsource property in the OnLoad event instead of OnOpen. You should not have to execute the statement Me.Requery. Also, make certain your RecordSource is empty in the properties window the last time you save the form.

    Bill

    Chattanooga, TN

  • Thanks Bill, work fine.

    Solution is better then my becouse I don't need function and I have all code in one place.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply