[AccessD] AccessD Digest, Vol 84, Issue 23

Kenneth Ismert kismert at gmail.com
Mon Feb 15 14:54:44 CST 2010


> 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



More information about the AccessD mailing list