[AccessD] Access Won't Close

Rocky Smolin rockysmolin at bchacc.com
Thu Aug 30 08:59:51 CDT 2012


How about open objects to make it easier to track down where you forgot
close/set to nothing?

Rocky


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

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

 That's interesting and sure sounds like it.  Never knew there was a
distinction between DoCmd.Quit and Application.Quit (there really shouldn't
be either).

 Which brings to mind a feature which I always wish Access had; a way to
inspect the open reference count and list them.  That would be really
interesting to look at.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Thursday, August 30, 2012 09:05 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Won't Close

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

--
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