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