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