[AccessD] Access Won't Close

Heenan, Lambert Lambert.Heenan at chartisinsurance.com
Thu Aug 30 08:05:06 CDT 2012


Best guess, invoking DoCmd creates an object behind the scenes?

DoCmd is a property of the Application object, and if you look at Help it says:

"You can use the DoCmd property to access the read-only DoCmd object and its related methods."

So when you invoke Docmd.Quit you have created another Application object on the fly. Whereas with Application.Quit you are using the existing Application object.

Something like that anyway!

Lambert


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, August 29, 2012 5:52 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access Won't Close

Brian and Lambert:

So I substituted Application.Quit for DoCmd.Quit and that solved it.  Go figure...

Thanks

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Tuesday, August 28, 2012 10:03 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access Won't Close

Rocky,

 make sure any object you open is closed and it's variable set to nothing.

 Access has no idea if it's been called as an automation server or not.
When it goes to close, if it sees an open reference, it minimizes to the task bar assuming that another program is not finished with it yet.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Tuesday, August 28, 2012 12:55 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Access Won't Close

Dear List:
 
My client wanted an email function in his app.  No problem - they use Outlook and I had the code already I could crib from another app.
 
However, now when I exit the app, Access doesn't close - can't close it from the X, have to use the Task Manager.
 
This happens if I just start the app and click exit from the opening splash screen.
 
I'm pretty sure it has to do with Outlook (which is open all the time on my box).
 
And I remember reading about this on the list years ago.
 
Does anybody know the problem/solution?

MTIA
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/>
Skype: rocky.smolin
 
 
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list