Heenan, Lambert
Lambert.Heenan at AIG.com
Mon Jan 26 14:54:41 CST 2004
Fame at last!!! :-) > -----Original Message----- > From: Dan Waters [SMTP:dwaters at usinternet.com] > Sent: Monday, January 26, 2004 12:04 PM > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] Annoying Feature of Access 2002 > > Yahoo! > > I'm going to title this button as the Lambert Wizard! > > Thanks! > Dan Waters > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert > Sent: Monday, January 26, 2004 10:24 AM > To: Access-D Email (accessd at databaseadvisors.com); ACCESS-L Email > (ACCESS-L at PEACH.EASE.LSOFT.COM) > Subject: [AccessD] Annoying Feature of Access 2002 > > A few weeks ago I complained about the fact that when you change one > module > in Outlook 2002 all the other modules then show the same modified time as > the one you just changed. This can make it a tad difficult to keep track > of > what you just worked on. > > Assuming I'm not the only one that finds this annoying, and that we're not > all working with Visual Source Safe, here's a simple work around. Just > create a query with this SQL... > > SELECT MSysObjects.Name, MSysObjects.DateCreate, MSysObjects.DateUpdate > FROM MSysObjects > WHERE (((MSysObjects.Type)=-32761)); > > and then attach this query to a macro which you can then associate with a > toolbar button. You will then have a one click way to find out what really > got changed in module land. > > HTH :-) > > Lambert > > _______________________________________________ > 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