Export form definition

[Dale Fye]

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

 

[Douglas J. Steele]

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

 

[fredg]

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

I think you want
Tools + Analyze + Documenter
Check the options available so you don't get more information than you
want.

 

[Dale Fye]

Thanks, Doug.

That answered both this question, and the orphaned code question I posted a
couple of minutes earlier.

--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Douglas J. Steele]

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

 

[Dale Fye]

Saw this response, and while I was looking through the SmartAccess.html file
I noticed that answer to the orphaned code among the articles.


--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.