corrupt form

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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard" wrote in message
...

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


"Allen Browne" wrote in message
...
Undocumented, but use:
SaveAsText
LoadFromText
The arguments are obvious from there.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard" wrote in message
...

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.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard" wrote in message
...
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


"Allen Browne" wrote in message
...
Undocumented, but use:
SaveAsText
LoadFromText
The arguments are obvious from there.


"Richard" wrote in message
...

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.

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

---------------------------
Microsoft Visual Basic
---------------------------
Compile error:

Expected: =
---------------------------
OK Help
---------------------------

Regards
Richard


"Allen Browne" wrote in message
...
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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard" wrote in message
...
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


"Allen Browne" wrote in message
...
Undocumented, but use:
SaveAsText
LoadFromText
The arguments are obvious from there.


"Richard" wrote in message
...

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.

Drop the brackets, or use Call in front of the sub.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard" wrote in message
...
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

---------------------------
Microsoft Visual Basic
---------------------------
Compile error:

Expected: =
---------------------------
OK Help
---------------------------

Regards
Richard

Thanks Allen

Managed to do it...

Richard


"Allen Browne" wrote in message
...
Drop the brackets, or use Call in front of the sub.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard" wrote in message
...
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

---------------------------
Microsoft Visual Basic
---------------------------
Compile error:

Expected: =
---------------------------
OK Help
---------------------------

Regards
Richard