Slow to open form in design view

[Infocore]

I have a form in my database that has a good deal going on with it.
Its built on a simple query but has a few sub forms on it.

What I don't understand is why it takes so long to open the form in
design view? It never used to take this long. Its gotten slower over
time. It also takes a long time to save the form and often after
changes will get corrupted. When I'm in the form vba code and
compile, the screen flashes like a strobe for a few seconds before its
done. It doesn't do this on other forms.

Does any of this sound familiar to anyone? Any ideas what could be
wrong or is this normal?

Rob Buonocore

 

[Rob Buonocore]

I forgot one thing...it also is so slow to just copy and paste the
form.

 

[Steven Young]

I was pulling my hair out over the same problem.
What seems to have work for me is in:


http://bytes.com/topic/access/answers/869122-forms-slow-save-go-into-design-view#post3511902

Hope if works for you.



Infocore wrote:

Slow to open form in design view
14-Sep-09

I have a form in my database that has a good deal going on with it
Its built on a simple query but has a few sub forms on it

What I do not understand is why it takes so long to open the form i
design view? It never used to take this long. Its gotten slower ove
time. It also takes a long time to save the form and often afte
changes will get corrupted. When I am in the form vba code an
compile, the screen flashes like a strobe for a few seconds before it
done. It does not do this on other forms

Does any of this sound familiar to anyone? Any ideas what could b
wrong or is this normal

Rob Buonocore

Previous Posts In This Thread:

Slow to open form in design view
I have a form in my database that has a good deal going on with it
Its built on a simple query but has a few sub forms on it

What I do not understand is why it takes so long to open the form i
design view? It never used to take this long. Its gotten slower ove
time. It also takes a long time to save the form and often afte
changes will get corrupted. When I am in the form vba code an
compile, the screen flashes like a strobe for a few seconds before it
done. It does not do this on other forms

Does any of this sound familiar to anyone? Any ideas what could b
wrong or is this normal

Rob Buonocore

I forgot one thing...it also is so slow to just copy and paste theform.
I forgot one thing...it also is so slow to just copy and paste th
form

r


Submitted via EggHeadCafe - Software Developer Portal of Choice
Select Subset of Rows in ADO.NET DataTable
http://www.eggheadcafe.com/tutorial...15-185933676c4f/select-subset-of-rows-in.aspx

 

[Steven Young]

does the db operates normally when you run it on your local computer? If it is just slow on the network - then talk your IT into defrag the network drive:

See:
http://www.access-programmers.co.uk/forums/showthread.php?t=31894
Post #5





Steven Young wrote:

Slow to open form in Design View
30-Nov-09

I was pulling my hair out over the same problem.
What seems to have work for me is in:


http://bytes.com/topic/access/answers/869122-forms-slow-save-go-into-design-view#post3511902

Hope if works for you.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
VIsual Studio.NET 2005 / SQL 2005 Resources
http://www.eggheadcafe.com/tutorial...9d71-a183e5a510ce/visual-studionet-2005-.aspx