Form in the "Lost and Found' . . . ?

[יריב החביב]

Hello,

I worked on a form and when i wanted to bring it to a 'form view'

i got a message that there is not enough memory and after that access was

forced to close.

Now when i am trying to open this form, there is not response.

Where is my form ?

Thank's

 

[Allen Browne]

Sounds like the form has gone bad.
You may be able to rescue it like this.

1. Make a backup copy of your database (so you get multiple chances at
rescuing it.)

2. Open the Immediate window (Ctrl+G), and enter something like this:
SaveAsText acForm, "Form1", "C:\MyFolder\Form1.txt"

3. Verify that the file was created in your folder.

4. Delete the form.

5. Compact the database.

6. Open the Immediate window, and enter:
LoadFromText acForm, "Form1", "C:\MyFolder\Form1.txt"

 

[יריב החביב]

Thank you,

The main form as come back to life with your instruction's.

In this form there is Subform and when i am trying to bring it back

in the same way, i got run time error 2285 - "...can't create the output file"

Can i do somthing more ?

THANK'S

 

[hor vannara]

Hello,

I worked on a form and when i wanted to bring it to a 'form view'

i got a message that there is not enough memory and after that access was

forced to close.

Now when i am trying to open this form, there is not response.

Where is my form ?

Thank's

 

[Allen Browne]

Assuming the output file name is valid (omit any special characters such as
spaces), this other form might be too hosed to recreated this way, so you
will need to recreate it manually or import it from an old backup.

 

[יריב החביב]

Thank You
--
תודה רבה

Assuming the output file name is valid (omit any special characters such as
spaces), this other form might be too hosed to recreated this way, so you
will need to recreate it manually or import it from an old backup.