[AccessD] AccessD Digest, Vol 84, Issue 23

Hi William --

I suppose I can add that feature as an option in the new release.

For the current release version I have just played with it in Access 2007
and test mdb:

- open test mdb;
- create a new form;
- throw a few controls on form;
- save form;
- run Access.PowerTools backup to get form's text definition;
- edit form's text definition and change ItemSuffix to any value, say 1 or
300 or 1503;
- save edited text;
- run Access.PowerTools restore to get edited form's text definition loaded;
- open form in design mode;
- throw new control on form;
- see how Access 2007 (and Access2003?) smoothly handles control name
default suffix; 

The same as above steps sequence works for existing forms.

I have added this feature to the project Issue Tracker area:

http://accesspowertools.codeplex.com/WorkItem/View.aspx?WorkItemId=15 

Thank you.

--
Shamil

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: Tuesday, February 16, 2010 7:30 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] AccessD Digest, Vol 84, Issue 23

Shamil

...am I correctly reading this to mean you can reset the lifetime form 
controls limit in the Access Power Tools addin?
...if so, will you do this automatically or as an option?

William

--------------------------------------------------
From: "Shamil Salakhetdinov" <shamil at smsconsulting.spb.ru>
Sent: Tuesday, February 16, 2010 11:09 AM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] AccessD Digest, Vol 84, Issue 23

> 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
>
>
> -- 
> 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

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4871 (20100216) __________

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