corrupt form

R

Richard

Hi

I remembered someone posted a code to save a form to text and reimport it in
the immediate window. Appreciate if someone can show me the code as I think
one of my forms is corrupted.

Thanks in advance

Richard
 
A

Allen Browne

Undocumented, but use:
SaveAsText
LoadFromText
The arguments are obvious from there.
 
R

Richard

Thanks Allen

I tried it but an error comes up with "Expected: = "

How do I overcome this? This saves to the database itself?

Thanks again
Richard
 
A

Allen Browne

If the database is corrupt, anything can happen.

Not sure where you are trying to use SaveAsText, but try the Immediate
Window (Ctrl+G).

This does not save the whole database. It simply exports one of the objects
(e.g. a form) to a text file. You can then import that object into another
database by using LoadFromText.

For other ideas on sorting out a corrupt database, see:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
R

Richard

HI Allen

Thanks again for your patience. I did it at the immediate window and got the
error message.

I typed:

saveastext(acForm,"payment","paymenttext")

and got this
 
Top