Is there any way to export a forms definition to a text file, built into
Access 2003 (similiar to the VB6 form files)?
I can probably write a relatively simple routine to select a form, write all
of its properties to a text file, then loop through its controls, and write
all of their properties to a text file. Then write the code to read that
data back in and create a form from it.
However, before I go to all of that trouble, I just wanted to check to see
whether that functionality already exists. Or if someone has written that
code as free tool.
I've been working in a classified environment, and am unable to move my
Access application from the classified environment to the unclassified
environment, except as text files. The tools I have available to me to
declassify the information, corrupt the mdb file if I save it as text. So I
am left with exporting the application to text files, running it through the
tools that allow me to declassify the "text", then recreate the application.
I know I can export the code behind the forms as well as the code modules,
but am wondering about the forms themselves.
Dale

Signature
email address is invalid
Please reply to newsgroup only.
Douglas J. Steele - 24 Mar 2008 19:06 GMT
There's a built-in (albeit undocumented) SaveAsText method.
See my February, 2005 "Access Answers" column in Pinnacle Publication's
"Smart Access". You can download the column (and sample database) for free
at http://www.accessmvp.com/DJSteele/SmartAccess.html

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Is there any way to export a forms definition to a text file, built into
> Access 2003 (similiar to the VB6 form files)?
>
> However, before I go to all of that trouble, I just wanted to check to see
> whether that functionality already exists. Or if someone has written that
> code as free tool.
Dale Fye - 24 Mar 2008 20:32 GMT
Thanks, Doug.
That answered both this question, and the orphaned code question I posted a
couple of minutes earlier.

Signature
Don''t forget to rate the post if it was helpful!
email address is invalid
Please reply to newsgroup only.
> There's a built-in (albeit undocumented) SaveAsText method.
>
[quoted text clipped - 8 lines]
> > whether that functionality already exists. Or if someone has written that
> > code as free tool.
Douglas J. Steele - 24 Mar 2008 20:57 GMT
Actually, I answered your orphaned code question (or are you saying that you
found the other column when you were looking for the SaveAsText one?)

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Thanks, Doug.
>
[quoted text clipped - 18 lines]
>> > that
>> > code as free tool.
Dale Fye - 24 Mar 2008 21:28 GMT
Saw this response, and while I was looking through the SmartAccess.html file
I noticed that answer to the orphaned code among the articles.

Signature
Don''t forget to rate the post if it was helpful!
email address is invalid
Please reply to newsgroup only.
> Actually, I answered your orphaned code question (or are you saying that you
> found the other column when you were looking for the SaveAsText one?)
[quoted text clipped - 21 lines]
> >> > that
> >> > code as free tool.
fredg - 24 Mar 2008 20:28 GMT
> Is there any way to export a forms definition to a text file, built into
> Access 2003 (similiar to the VB6 form files)?
[quoted text clipped - 18 lines]
>
> Dale
I think you want
Tools + Analyze + Documenter
Check the options available so you don't get more information than you
want.

Signature
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail