Shamil Salakhetdinov
shamil at users.mns.ru
Thu Oct 26 16:01:38 CDT 2006
Martin, I have here commercial software, which I did program in the past for one customer. Unfortunately this software wasn't finished / published - I did use it to dig out information about new properties... In principle there is nothing complicated here but it needs quite some coding to do that from scratch - just make a sample database with different objects and iterate all .Properties collections of every sample object and its children objects... BTW, this software was originally programmed for MS Access 97 and yesterday I had to convert it to MS Access 2003 and then to MS Access 2007. The VBA code is rather advanced and it does do a lot of "massaging" of MS Access objects and it does use several backend databases and its does put quite some data into tables etc. - all worked rather well, with one exception that using Autonumber GUIDs in some places was resulting in MS Access 2003 to GPF. This was when GUID was obtained as value of a listbox and then passed as variant to a function, which passed it as variant to another function. When I did add converting GUID to string in between all started to work OK. Just wanted to note that an advanced VBA coding originally developed for MS Access 97 works without almost any issues in MS Access 2003 and MS Access 2007... -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Friday, October 27, 2006 12:30 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] MS Access 2007 - where may one have a look atthe fulllist of the new objects, properties, methods, ... Shamil Out of interest how did you dig them out? Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of Shamil Salakhetdinov Sent: Thu 26/10/2006 21:07 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] MS Access 2007 - where may one have a look atthe full list of the new objects, properties, methods, ... Jim, Here is the reference on the HTML page with the list of 307 properties I have dug out so far: http://smsconsulting.spb.ru/info/acc2007/newPrpsInAccess2007.htm This is XML source of this list: http://smsconsulting.spb.ru/info/acc2007/newPrpsInAccess2007.xml