[AccessD] Slow Forms

Hi Reuben
I don't stuff about with these sort of things any more
I rename the Original form that is causing me dramas to Whatever_Original
The create a new form from scratch. Import all the objects from the original form 
(open it in design view then Edit|Selectall|Edit|Copy)
then paste all the objects to the new form then do same with the code from the original.
Copy it all then pastes it all behind the new form
Change all the form settings like Modal = true etc to match the old one 
Then save the new form with the Original form's name.
That does it for me in most cases

Hope this helps

Darren


----- Original Message ----- 
From: "Reuben Cummings" <reuben at gfconsultants.com>
To: "AccessD" <accessd at databaseadvisors.com>
Sent: Wednesday, March 31, 2004 7:14 AM
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