Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2008

Tip: Looking for answers? Try searching our database.

Export form definition

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dale Fye - 24 Mar 2008 18:21 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.