Form doesn't open

[CenturionX]

Hello everybody,

I have a little odd problem trying to open a form with MS Access 2002:
I use the DoCmd.OpenForm command like this: DoCmd.OpenForm
"frm_Salespersons".
and in return the error i got everytime is:

Run-time error '2004'
There isn't enough memory to perform this operation. Close unnedeed
programs and try the operation again.

Believe me. there is nothing else running in my PC.

Somebody has some idea of what to do????

Thanks.

[CenturionX]

Well, i did it in fact.
But the error comes after the form loads.
I tried putting breaks in the code in the open and load events with no
success.

It happens when i add another control (a button in this case) to the
form.

[Larry Linson]

"CenturionX" <da************@gmail.comwrote

Well, i did it in fact.
But the error comes after the form loads.
I tried putting breaks in the code in the open and load events with no
success.

It happens when i add another control (a button in
this case) to the form.

Because adding a control and opening the form are two separate actions "when
I add another control" does not make much sense to me. Could you clarify
with more details?

From what you did say, it does sound as if something is corrupted in your
database... is there any text associated with the error number? Is that a
system error message, or an application error message? It is certainly not
"normal operation" of a DoCmd.OpenForm "yourformname".

Larry Linson
Microsoft Office Access MVP

[CenturionX]

The only error i get is
Run-time error '2004'
There isn't enough memory to perform this operation. Close unnedeed
programs and try the operation again.

Nothing else.

It's something i can't understand.

[Bruce]

On May 1, 2:11 pm, CenturionX <[e-mail]:

The only error i get is
Run-time error '2004'
There isn't enough memory to perform this operation. Close unnedeed
programs and try the operation again.

Nothing else.

It's something i can't understand.

Just to be sure I've got this correct: You created a form which at
one time worked correctly. Then you added a new command button and
saved the form and now when you open it you get the error message
above.

If you now remove that command button and save the form, do you still
get the error when it is opened?

Have you tried creating a copy of this form with a different name and
opening the copy? If this works without error, delete the original
form and rename the copy to match the original.

Have you tried creating a new empty database, importing all of the
objects from your current database, and then opening the form from the
new database?

Bruce

[paylo]

Whenever you compact any database, just split database in front end and back
end. Front end includes application, queries, reports, macros and modules and
Back-end should contain table and relation. Backend must be on server. In
compact operation you should repair only back-end. To fix this error, you
import database table and forms in new blank database or you can use Stellar
Phoenix Access Repair Software. http://www-repair-access-file.com

CenturionX wrote:

>Hello everybody,

I have a little odd problem trying to open a form with MS Access 2002:
I use the DoCmd.OpenForm command like this: DoCmd.OpenForm
"frm_Salespersons".
and in return the error i got everytime is:

Run-time error '2004'
There isn't enough memory to perform this operation. Close unnedeed
programs and try the operation again.

Believe me. there is nothing else running in my PC.

Somebody has some idea of what to do????

Thanks.