If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problems when closing forms
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 |
#2
|
|||
|
|||
Problems when closing forms
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Closing Forms | Stan Smith | Using Forms | 2 | November 6th, 2004 07:57 PM |
Forms and Subforms Problems | DEvans | Using Forms | 1 | October 7th, 2004 05:13 PM |
Can I close all open forms? | DBS | General Discussion | 3 | October 7th, 2004 04:35 PM |
linking forms (without using sub forms) & writing a macro | Adena | Using Forms | 1 | September 27th, 2004 01:24 AM |
Problems closing Excel | Steve | Setting up and Configuration | 1 | November 13th, 2003 12:39 AM |