copy object or export object, can't open object

[laavista]

I'm using Access 2003. If I copy an object, e.g., a form, and paste it, it
won't open nor can I open it in design mode. If I export an object, e.g., a
form, to the database, it still won't open.

Any suggestions?

(Thanks, in advance, for your help!)

 

[Gina Whipp]

laavista,

Let's start with copy/paste from where to where? Is this database to
database? If it is database to database then it will only open in design
mode unless the record source is the same in both databases. Of course, I
never tried this with an .mde.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[laavista]

I'm desperate for help as I'm getting an "out of memory error" for this form
and really need to get to it and save it.

I'm using Access 2003, and it's a .mdb file.

I can't copy/paste a form within the SAME database. For instance, I tried
copying the form "f_event". I copied it and pasted it. I can open it in
design mode, but can't open the form itself. It's in the same database and
has the same source.

What I really need to do is copy the form where I'm getting the "out of
memory error" from a previous copy of the database and paste it into this
one. But if I can't get a pasted form open (even if copied/pasted within the
same database), then it does me no good.

Any suggestions?

 

[Gina Whipp]

laavista,

First of all, sounds like you have a corrupted form...

Before anything else is done, make a back-up of the database...

1. Make a back-up of the database. Okay I said that but just making sure.

2. Try creating a new form and then copy/paste the controls from the old
form to the new form. You can do that with the code also.

OR

3. Export the form as .txt (SaveAsText) and then rename the exisiting one
and then import the one you saved as text. However, I think this removes
all code behind the form.

OR

4. Rename the one that is giving you the problem. Copy the good one from
the old database, do not close the old database until you paste it into the
database you want it in.

OR

5. Decompile

"C:\Program Files\Microsoft Office 2003\OFFICE11\MSACCESS.EXE" "C:
\YourDirectory\YourDatabaseName.mdb" /decompile


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[laavista]

Thank you for taking the time to help. I will try your suggestions.

 

[Gina Whipp]

Let's just hope one of them works!

You're welcome....
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm