form save

  • Thread starter Thread starter Kurt Neumann
  • Start date Start date
K

Kurt Neumann

i'm using access2000 and xp:
i have a form with many controls. lately when i edit it, it takes an
extremely long time to save and often will "lock up" with the hourglass
showing. i have to task manager out of it and get a "not responging"
message.
thanks for any help
 
i'm using access2000 and xp:
i have a form with many controls. lately when i edit it, it takes an
extremely long time to save and often will "lock up" with the hourglass
showing. i have to task manager out of it and get a "not responging"
message.
thanks for any help
Click to expand...

Two suggestions:

1. Compact and Repair the database. This will get rid of the old
versions of (most of) your changes, and recompact the structure.

2. If that doesn't help, first back up your database. Then type Ctrl-G
to open the VBA editor; in the Immediate pane type

Application.SaveAsText acForm, "yourformname", "C:\My
Documents\yourformname.txt"

all on one line (using a valid path to a writeable directory). Then
delete the form, Compact, and go back to the Immediate window and
recreate the form with

Application.LoadFromText acForm, "yourformname", "C:\My
Documents\yourformname.txt"

This should get rid of a lot of the leftovers.

John W. Vinson[MVP]
 
I notice you're using Access 2000.
If you don't have the service packs on it, I'd highly recommend them.
The behavior you report was typical of that version when it was first
released.
 
Thanks

Got it all working again properly


John Vinson said:
Two suggestions:

1. Compact and Repair the database. This will get rid of the old
versions of (most of) your changes, and recompact the structure.

2. If that doesn't help, first back up your database. Then type Ctrl-G
to open the VBA editor; in the Immediate pane type

Application.SaveAsText acForm, "yourformname", "C:\My
Documents\yourformname.txt"

all on one line (using a valid path to a writeable directory). Then
delete the form, Compact, and go back to the Immediate window and
recreate the form with

Application.LoadFromText acForm, "yourformname", "C:\My
Documents\yourformname.txt"

This should get rid of a lot of the leftovers.

John W. Vinson[MVP]
Click to expand...
 
Back
Top