473,385 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Closing a form causes crash

One form in my Access 2000 mdb causes a crash whenever I close it. The
crash is of the type where I get a "Please tell Microsoft about this
problem".

Easy, you think! Well, here are the things I've tried already, all to
no avail:

Followed Microsoft's advice and downloaded SR-1 and installed it.

Rebooted the computer.

Restored the system to a checkpoint I took a few days ago.

Imported a version of the form from an older mdb (where it works fine).

Started with a blank new database and imported everything into it.

Completely removed the OnClose event procedure.

Tried to recreate the problem with other forms in the same mdb.

Closed it using File > Close rather than the X. This appears to work
the first time, but when I open the form a second time, the first copy
reappears, and neither of the two gets repainted correctly.

Running out of ideas. Any more ideas I should try? Thanks.

Nov 13 '05 #1
2 3186
Di
Before you copied the objects to a new database, did you copy the code
separately and select "No" to the "Has Module" property and save the
form first?

Had this problem with a database converted from 97.

D...

Composer wrote:
One form in my Access 2000 mdb causes a crash whenever I close it. The crash is of the type where I get a "Please tell Microsoft about this
problem".

Easy, you think! Well, here are the things I've tried already, all to no avail:

Followed Microsoft's advice and downloaded SR-1 and installed it.

Rebooted the computer.

Restored the system to a checkpoint I took a few days ago.

Imported a version of the form from an older mdb (where it works fine).
Started with a blank new database and imported everything into it.

Completely removed the OnClose event procedure.

Tried to recreate the problem with other forms in the same mdb.

Closed it using File > Close rather than the X. This appears to work
the first time, but when I open the form a second time, the first copy reappears, and neither of the two gets repainted correctly.

Running out of ideas. Any more ideas I should try? Thanks.


Nov 13 '05 #2
Thanks for that, Di. After posting, I did think of eliminating all the
form's code by setting "Has Module" to No. This didn't work, but...

I delved into one of the subforms of the form. In one, a continuous
form, the VBA code instantiated a Collection object, and in its Unload
procedure it set the object to Nothing. Once I removed this (by moving
the shared Collection into the Parent), the problem stopped.

A self-inflicted wound. Sorry to have troubled you. Let all learn
from this: don't share an object among all the instances of a
continuous form. It seemed to work for a while, but suddenly it didn't
work any more.

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: ThunderMusic | last post by:
Hi, I'm trying to have a MSN Messenger like form/app closing behavior. When I click on the X button, I only want the form to disappear and when I double-click on the notify icon or right-click...
8
by: Adam Louis | last post by:
I would like help resolving this problem. I'm a novice who's been hired to query a hospital database and extract useful information, available to me only in a dynamically generated, downloadable...
2
by: Bob Cummings | last post by:
Greetings I am sure this is a simple question. But I have "googled" it to death and have only found one answer that involved a bunch of window's API calls that I did not understand. I am a...
10
by: Charles Law | last post by:
For some reason, when I click the X to close my MDI parent form, the action appears to be re-directed to one of the MDI child forms, and the parent remains open. I am then unable to close the...
5
by: Oenone | last post by:
I have a VB.NET form which I'm displaying modally using the ShowDialog() method. Within the form is a Cancel button, and I've set this button into the Form's CancelButton property so that...
10
by: John Kraft | last post by:
Hello all, I'm experiencing some, imo, strange behavior with the StreamReader object I am using in the code below. Summary is that I am downloading a file from a website and saving it to disk...
14
by: =?Utf-8?B?UHVjY2E=?= | last post by:
Hi, I'm using VS2005 and .net 2.0. I'm creating an application that has 3 forms. I want allow users to move forward and backward with the forms and retain the data users have entered. I thought...
22
by: Zytan | last post by:
I have public methods in a form. The main form calls them, to update that form's display. This form is like a real-time view of data that is changing. But, the form may not exist (it is...
0
by: Lyn | last post by:
I have a problem using the form .Filter and .FilterOn properties which causes Access to crash (as detailed in a separate post). The form operates in continuous mode, displaying matching records...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.