A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Problems when closing forms



 
 
Thread Tools Display Modes
  #1  
Old October 20th, 2005, 08:27 PM
Uros
external usenet poster
 
Posts: n/a
Default 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  
Old October 21st, 2005, 10:59 AM
Uros
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 06:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.