[AccessD] Problems closing XP - Bizarre Behavior

I use docmd.quit without problem... But there's a whole load of other
weird stuff going on... Tab controls that grow, list views that draw
their contents in strange places and subform objects that keep setting
themselves to different control source (I have 4 on one form and if I
edit any by clicking them from the main form in design view then all
four use the same subform - xp rocks... It even closes down all by iself
someimes... Usually when I click save, you need to really be on your
toes with this one :@)

Good luck...

Mark

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paula Wright
Sent: 18 November 2003 18:22
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Problems closing XP - Bizarre Behavior


Okay, I went into my closing action and changed docmd.quit to
application.quit and got all excited because the application shut down
and then it reopened!!!
 
I tried it again, leaving the Windows Task Manager where I could see
what was happening and it literally closed and reopened.
 
What's that all about????

	-----Original Message----- 
	From: accessd-bounces at databaseadvisors.com on behalf of Paula
Wright 
	Sent: Tue 11/18/2003 1:05 PM 
	To: Access Developers discussion and problem solving 
	Cc: 
	Subject: RE: [AccessD] Problems closing XP
	
	

	I've tried taking the ocx out of the subform so that it is no
longer embedded
	and using the Dim/Set statements, setting crR to nothing on
closing the main
	form and still have the error.
	
	I tried calling it from the main form and still have the error. 
	
	There are a few things that are very strange to me.  There are
several
	reports that I call from this subform.  There is one set where
only one of
	the reports causes the error.  There is nothing different in the
code that
	calls the reports.  There are queries that run before opening
the subform to
	compile the data for the reports.  I have gone through and made
sure all the
	Set db and Set rs are set to nothing so I don't think it's a
data issue. 
	
	The other thing is that Access acts like it is going to close -
goes through
	the compact and appears to be shutting down but then maximizes.
It's not
	frozen.  I can reopen the database, I just can't shut the Access
window down.
	
	
	        
	
	


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003