How to get a form's control's properies to a textfile

  • Thread starter Thread starter Ann-Sofie Karlsson
  • Start date Start date
A

Ann-Sofie Karlsson

When using docmd.outputTo to print a form's module to a text file you don't
get the properties for the form's controls. How do you get them?

I'am using the code

DoCmd.OutputTo acOutputModule, Me.Module, acFormatTXT, "C:\Junk.txt"

But I don't get any controls in the text file

Fia
 
You can use the built in documenter to report out all the control and form
properties. Running the documenter places all the information into a table
that you can link to and create your own reports or queries.

In the past, I have taken the output from the documenter and used it in a
maketable query. Once I had the new table, I made a few modifications to
some values. I then wrote some code that would dynamically re-create the
form and its controls.
 
There is a command called SaveAsText which is included with Access but
Microsoft don't provide any documentation on it and do not offer any support
regarding it. (It was implemented for integration into another MS
application - it was never intended for use by users).

Using SaveAsText you will get the form controls and properties and the class
module source code all listed in one text file. Call it as follows;

Application.SaveAsText acForm,"MyFormName", "C:\FullFilePath.txt"

Another function you may be interested in is LoadFromText which does the
exact opposite - it takes a text file created by SaveAsText and re-creates
the object in your database. Call it as follows;

Application.LoadFromText acForm,"MyImportedFormName", "C:\FullFilePath.txt"

In general these functions work well, however there are a few quirks such as
not supporting Unicode (doesn't bother most people).
If you don't fancy using this 'unsupported' approach you could write some
VBA code that enumerates through the controls of a form and then enumerates
through each controls properties whilst outputting everything to a text file
in a format you've chosen. This requires a bit more work... Let me know if
you want help with this.

Regards,

Wayne Phillips
http://www.everythingaccess.com - Professional Access Database Repair
 
Back
Top