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!)

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" <(E-Mail Removed)> wrote in message
news:62D2C687-1332-4DA9-837B-(E-Mail Removed)...
> 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!)

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" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:62D2C687-1332-4DA9-837B-(E-Mail Removed)...
> > 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!)
>
>
>

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" <(E-Mail Removed)> wrote in message
news:EEDA52EF-C953-4C6A-8D52-(E-Mail Removed)...
> 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" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:62D2C687-1332-4DA9-837B-(E-Mail Removed)...
>> > 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!)
>>
>>
>>

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

"Gina Whipp" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:EEDA52EF-C953-4C6A-8D52-(E-Mail Removed)...
> > 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" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> news:62D2C687-1332-4DA9-837B-(E-Mail Removed)...
> >> > 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!)
> >>
> >>
> >>
>
>
>

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

"laavista" <(E-Mail Removed)> wrote in message
news67A3837-5C3A-454A-8CCD-(E-Mail Removed)...
> Thank you for taking the time to help. I will try your suggestions.
>
> "Gina Whipp" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:EEDA52EF-C953-4C6A-8D52-(E-Mail Removed)...
>> > 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" wrote:
>> >
>> >> 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" <(E-Mail Removed)> wrote in message
>> >> news:62D2C687-1332-4DA9-837B-(E-Mail Removed)...
>> >> > 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!)
>> >>
>> >>
>> >>
>>
>>
>>