[AccessD] Add-In Express 2009 for Office and .NET

Max Wanadoo max.wanadoo at gmail.com
Thu Feb 11 16:41:03 CST 2010


Strange.  Obviously a reason but not quite transparent.  Probably an
amalgamation of the count  of  objects summing up to 1024 etc.  Who  knows?

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: 11 February 2010 22:29
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Add-In Express 2009 for Office and .NET

It's been that way since Access first came out.  They had to introduce
subforms and subreports to get around it.  There's also a limit on the
overall length of a form or report in design view.  

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Thursday, February 11, 2010 1:11 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Add-In Express 2009 for Office and .NET

That doesn't make any sense. It is not as if it  is going to UNDO 754
changes!

Wonder what the  logic there was?

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: 11 February 2010 20:47
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Add-In Express 2009 for Office and .NET

Max,

  Access has a limit of creating 754 controls over the lifetime of a form.
Once you hit that limit, that's it.  You need to re-create the form.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max (MGA)
Sent: Thursday, February 11, 2010 3:35 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Add-In Express 2009 for Office and .NET

> . It also reset the lifetime control count,

What is this Ken?

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kenneth Ismert
Sent: 11 February 2010 20:28
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Add-In Express 2009 for Office and .NET

> > Shamil:
> > What I plan to do is a "lightweight" version of "EatBloat" within
> > Access Developer Assistant add-in ... And it will need
> > .NET Framework 3.0/3.5 installed on target system.
> >
> Ken:
> Just so I'm clear, are you going to automate the EatBloat function using
> only .NET, or will you be calling the existing VBA code from .NET?
>
> Shamil:
> Just using .NET, Ken.
>
> A COM-Add-In developed using C# and "Add-In Express for Office and .NET"
> ...
>

That sounds like a good idea.

I bumped into the limitations of VBA when I developed an Access Rebuild
application which rebuilt Forms and Reports control-by-control,
property-by-property.

The motivation for this was a monster frontend (almost 40Mb in mde format)
with persistent corruption problems that not even SaveAsText/LoadFromText
could fix.

The program, while time-consuming to run, was remarkably effective in giving
the frontend a 'new lease on life'. Several huge forms, with almost a decade
of development history, could now be edited without aggressive bloat. It
also reset the lifetime control count, which allowed extending forms which
had long since run into this limit.

I often thought that redoing the code in C# or VB.NET would have allowed a
lot of extra flexibility in handling the coding issues that arose when
tackling this problem.

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




More information about the AccessD mailing list