[AccessD] Form corruption?

Mon Mar 9 14:16:00 CDT 2015

If there are common sets of controls that need to be hidden and 
unhidden, I would use a tab control, selecting the tab to "unhide" the 
set of controls on that tab.

John W. Colby

On 3/9/2015 3:12 PM, Janet Erbach wrote:
> Jim -
>
> The form is being saved each time after the objects are drawn.  The next
> time the app loads, all of the 'on-the-fly' objects are deleted, and then
> re-drawn.
>
> I think I'm going to go with the unhide/hide method - I'd like this app to
> be as straightforward as possible.
>
> On Mon, Mar 9, 2015 at 2:04 PM, Jim Dettman <jimdettman at verizon.net> wrote:
>
>>   That's the number I remember from a few years back as well for the last
>> couple of releases.  The number does seem to float a bit, but it's always
>> right around the same number.
>>
>>   I've never seen numbers along the lines Janet is seeing and the question I
>> have there; Janet are you saving the form each time or no?
>>
>>   And keep in mind that there are two basic work arounds for this:
>>
>> 1. Create the form from scratch each time.
>>
>> 2. Create all the controls you need, then unhide/hide as needed.
>>
>>   Either may allow you to get the job done without a significant amount of
>> re-writing.
>>
>>
>> Jim.
>>
>> -----Original Message-----
>> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>> John W. Colby
>> Sent: Monday, March 09, 2015 01:31 PM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Form corruption?
>>
>> nope.  I just got that same 1040 number when programmatically creating
>> recordset objects.
>>
>> John W. Colby
>>
>> On 3/9/2015 12:58 PM, Janet Erbach wrote:
>>> Not in this test - I just made it very basic.  Are you thinking I'll get
>>> different results if I put heftier objects in?
>>>
>>> On Mon, Mar 9, 2015 at 11:51 AM, John W. Colby <jwcolby at gmail.com>
>> wrote:
>>>> So these are not text box, combo box, list, radio button or check box
>>>> controls?
>>>>
>>>> John W. Colby
>>>>
>>>>
>>>> On 3/9/2015 12:43 PM, Janet Erbach wrote:
>>>>
>>>>> Garbage collectors, eh?  Then why didn't they come for this app the
>> moment
>>>>> it hit the floor??  :)
>>>>>
>>>>> None of the objects I'm drawing are bound to anything in this test -
>> just
>>>>> rectangles with labels.  And I just got as high as 30,159.  But it
>> doesn't
>>>>> really matter;  I can still make my point that this is an unstable
>>>>> approach.
>>>>>
>>>>> On Mon, Mar 9, 2015 at 11:34 AM, John W. Colby <jwcolby at gmail.com>
>> wrote:
>>>>>    Thanks for doing that Janet.
>>>>>> I suspect that this has to do with instances of DAO recordsets.  I
>> have
>>>>>> never tested controls per se but I did once test DAO recordsets and
>> came
>>>>>> up
>>>>>> with that same number.  I would bet that if you tested with non data
>>>>>> aware
>>>>>> controls you would find entirely (and larger) numbers.  Things like
>>>>>> labels
>>>>>> and lines etc.
>>>>>>
>>>>>> I am guessing that there is some sort of garbage collection process
>> that
>>>>>> is scavenging the dao pointers, which allows the different numbers you
>>>>>> are
>>>>>> seeing.
>>>>>>
>>>>>> John W. Colby
>>>>>>
>>>>>>
>>>>>> On 3/9/2015 11:29 AM, Janet Erbach wrote:
>>>>>>
>>>>>>    And I am doing that very test right now.  With interesting results,
>> too
>>>>>>> -
>>>>>>> inconsistent ones.
>>>>>>>
>>>>>>> 1)  When I run the test to draw objects on the form one right after
>>>>>>> another, Access consistently chokes at object 1040.
>>>>>>>
>>>>>>> 2)  After I delete those 1040 objects and start drawing again, Access
>>>>>>> will
>>>>>>> add another 1040 - a total of 2080 having been drawn to the form in
>> all
>>>>>>> -
>>>>>>> before it chokes.
>>>>>>>
>>>>>>> 3)  If I draw in 'batches' - add 500, delete 500, add 500 more - I
>> can
>>>>>>> keep
>>>>>>> going for a long time.  (This is with saving the form, closing it
>> down,
>>>>>>> and
>>>>>>> re-opening it after each batch.)  I got up to a total count 20,000
>> some
>>>>>>> objects that had been drawn to the form over it's 'life time' before
>>>>>>> access
>>>>>>> gave up.
>>>>>>>
>>>>>>> 4)  I started playing with drawing objects in different batch sizes.
>> I
>>>>>>> just now ran a few batches of 500, then ran one of 2,000, then upped
>> it
>>>>>>> to
>>>>>>> 5,000 .  Access choked  after drawing a total of 6120 objects.
>>>>>>>
>>>>>>> So it seems that Access is inconsistent in it's response to how many
>>>>>>> objects have been drawn, deleted, and re-drawn on the form over the
>>>>>>> course
>>>>>>> of it's lifetime.  Which is the ammo I need to bring to my boss when
>> I
>>>>>>> tell
>>>>>>> him the whole form handling routine has to be re-written.
>>>>>>>
>>>>>>> Janet
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Mar 3, 2015 at 6:38 PM, John W. Colby <jwcolby at gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>     It sounds like it's time for Janet to do a test!
>>>>>>>
>>>>>>>> ;)
>>>>>>>>
>>>>>>>> John W. Colby
>>>>>>>>
>>>>>>>> On 3/3/2015 7:35 PM, Jim Dettman wrote:
>>>>>>>>
>>>>>>>>     The number given has always been 754,  but that has drifted
>> upwards
>>>>>>>> to
>>>>>>>>
>>>>>>>>> over 1,000 in later versions.   I posted all the counts a few years
>>>>>>>>> back.
>>>>>>>>>
>>>>>>>>> Jim
>>>>>>>>>
>>>>>>>>> Sent from my iPhone
>>>>>>>>>
>>>>>>>>>      On Mar 3, 2015, at 6:45 PM, Charlotte Foust <
>>>>>>>>> charlotte.foust at gmail.com>
>>>>>>>>>
>>>>>>>>>    wrote:
>>>>>>>>>> It used to be in the documentation, but I haven't looked it up
>>>>>>>>>> recently
>>>>>>>>>> because it became moot after they introduced tab controls.
>>>>>>>>>>
>>>>>>>>>> Charlotte
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>     --
>>>>>>>>>>
>>>>>>>>> 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
>>>>>>
>>>>>>
>>>> --
>>>> 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
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>