[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