[AccessD] Slow Forms

William Hindman wdhindman at bellsouth.net
Wed Mar 31 22:32:49 CST 2004


...dl JC's JIT sample from www.colbyconsulting.com ...it'll get you there
with bells on :)

William Hindman
ipsedixitism: something is true because I myself have said it is true ...the
philosophy of Noam Chomsky :)

----- Original Message ----- 
From: "Reuben Cummings" <reuben at gfconsultants.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, March 31, 2004 2:34 PM
Subject: RE: [AccessD] Slow Forms


> >
> > ...have you tried not loading the tabbed data until its actually
selected
>
> I've considered this option.
>
> What event is used to "see" a tab being selected?
>
> Reuben Cummings
> GFC, LLC
> phone: 812.523.1017
> email: reuben at gfconsultants.com
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of William
> > Hindman
> > Sent: Tuesday, March 30, 2004 9:27 PM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Slow Forms
> >
> >
> > ...have you tried not loading the tabbed data until its actually
selected
> > ...that should let your main form open quickly based upon the info you
> > submitted.
> >
> > William Hindman
> > ipsedixitism: something is true because I myself have said it is
> > true ...the
> > philosophy of Noam Chomsky :)
> >
> > ----- Original Message -----
> > From: "Reuben Cummings" <reuben at gfconsultants.com>
> > To: "AccessD" <accessd at databaseadvisors.com>
> > Sent: Tuesday, March 30, 2004 4:14 PM
> > Subject: [AccessD] Slow Forms
> >
> >
> > > I need help with a form that opens very slowly.
> > >
> > > Everything worked very quickly until I compacted and repaired the db.
> > After
> > > compacting, this form will open slowly one time and then open
> > quickly all
> > > other times.  It will continue to open as I would expect it to
> > until it is
> > > compacted again.
> > >
> > > However, if the app is made into an mde then it always opens slowly.
> > >
> > > The form is based on a query.  There is a tab control on it.
> > One tab has
> > > about 14 fields from the same recordsource as the main form.  The
other
> > > three tabs all have subforms based on queries.  2 of those queries
have
> > > fields that call functions to get their value.
> > >
> > > All the queries and subforms open very quickly.  And if I delete the
> > > subforms, the main form will always operate quickly.
> > >
> > > I have imported into new db's.  I have completely rebuilt the main
form.
> > >
> > > Any suggestions on where to start troubleshooting this thing?
> > >
> > > Thanks.
> > >
> > > Reuben Cummings
> > > GFC, LLC
> > > phone: 812.523.1017
> > > email: reuben at gfconsultants.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