[AccessD] Access Won't Close

Charlotte Foust charlotte.foust at gmail.com
Thu Aug 30 09:26:20 CDT 2012


Well, for built in objects, you can get a count of any currently open using
something like Application.Forms.Count, although that doesn't include
subforms, IIRC.

Charlotte

On Thu, Aug 30, 2012 at 6:59 AM, Rocky Smolin <rockysmolin at bchacc.com>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
>
>
>
> --
> 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