[AccessD] Slow Forms

You need to use the tab Control's Change event. If you reference the tab
control's Value property you will get the index number of the tab in
question.

> -----Original Message-----
> From:	Reuben Cummings [SMTP:reuben at gfconsultants.com]
> Sent:	Wednesday, March 31, 2004 2:35 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
> 
> 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