[AccessD] Problems closing XP - Bizarre Behavior

Paula Wright paulawright at boddienoell.com
Tue Nov 18 12:21:59 CST 2003


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.
	
	
	        
	
	



More information about the AccessD mailing list