[AccessD] Access Won't Close

Tina Norris Fields tinanfields at torchlake.com
Tue Sep 4 14:09:38 CDT 2012


JC,
Didn't you build one for your framework?  Or, did I misremember?
T

Tina Norris Fields
tinanfields at torchlake.com
231-322-2787

On 8/30/2012 10:25 AM, jwcolby wrote:
> How about a garbage collector that works?
>
> ;)
>
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
> On 8/30/2012 9:59 AM, Rocky Smolin wrote:
>> 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