Form is not closing

[Ayo]

I just created a form but I can't close it. Even after I have saved it.
Access ask me if I want to save the form, I click yes and nothing happens.
When I click on save and then try to close the form, I get the "Do you want
to save changes to the design of the form 'Form'?", when I ckick on yes
nothing happens. But when I click No, the form closes. What does this mean?

 

[Tom Wickerath]

Hi Ayo,

Have you tried compacting your database lately? In Access 2003 and lower
versions, use Tools | Database Utilities | Compact and repair database. In
Access 2007, click on the Office button thingy, then select Manage, followed
by Compact and repair database.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Ayo]

I don't think that is the issue. I just made a lot of changes and none of it
is applied. Everytime I make changes to the form, it looks like the change as
been applied but when I close the form and open it again, all the changes are
gone.

 

[Ayo]

It looks like I can't make any changes to the form. Everything I do don't get
applied.

 

[Tom Wickerath]

Is this a shared database on a network? If so, someone else likely has the DB
open, so you do not have the exclusive rights you would need to save design
changes. The database should be split, with each user having their open copy
of the FE application, so that no two users are ever opening the same FE
file. More information here, if this applies in your case (see 2nd paragraph):

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm

If the database is local to your computer, such that no one else could
possibly have it open, then it soulnds to me like you have a corrupt form
and/or database.

Did you try the compact and repair?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Ayo]

No it is not on the network. I am still designing it on my computer. Earlier
I was get a message saying something about having too many controls on the
form. Could this have anything to do with this problem I am having now? And
if so how can this be fixed?

 

[Tom Wickerath]

I very strongly suspect that your current problems may be related to having
too many controls. I *think* the limit is something like 754 ??? controls on
a form or report, during the lifetime of the form or report. In other words,
if you add 200 controls, then delete 100, you have 554 before reaching your
upper limit (not 654). I once had lots of trouble with a report in a database
that another person had sent to me. They had a TON of check box controls.

if so how can this be fixed?

Usually, this type of design is a sign of an improperly normalized database,
for example repeating groups of fields. What can you tell me about the design
of your tables? If you have not read the two Michael Hernandez DB design
papers, available on the Access Junkie's web site, I highly recommend that
you read them. These are the first two papers available here:

http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101

"Fields are expensive, Records are cheap."

Is your current design using several fields to track similar data?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________