Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Tue Feb 16 10:09:21 CST 2010
Hi Ken -- OK. Yes, that would have been A2K, which wasn't able to handle the issue - I was also quite a bit disappointed with it keeping some bugs coming from Access 97... Thank you. -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kenneth Ismert Sent: Monday, February 15, 2010 11:55 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] AccessD Digest, Vol 84, Issue 23 > Shamil Salakhetdinov: > Hi Ken -- > <<< > SaveAsText/LoadFromText does NOT: > b) Reset the form lifetime control count limit > >>> > Are you talking about ItemSuffix property value? > > Version =20 > VersionRequired =20 > Checksum =97318316 > Begin Form > DividingLines = NotDefault > AllowDesignChanges = NotDefault > DefaultView =0 > .... > ItemSuffix =1 > ... > > I have just played with it (user backup/restore of Access.PowerTools.Add-In > + manual edit of ItemSuffix back and force etc.) - it can be set to any > value for MS Access 2007 (Access 2003 db format) forms- and MS Access > gracefully skips (increases) ItemSuffix value if is already occupied.. > > Am I missing something? > Do you mean there exists another counter? > Shamil, That's the one. I'm glad to hear the manual reset and control suffixing work well in A2007. My experience in A2K was not positive, but it was with a gigantic form that has probably been around since Access 95. The ItemSuffix reset would be a nice addition to EatBloat. But, I would suggest making it optional. If people have problems with the result, allow them to run it without. -Ken -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4869 (20100215) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru __________ Information from ESET NOD32 Antivirus, version of virus signature database 4871 (20100216) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru