Prev: Double click to open form
Next: netflix
From: John B. Smotherman on 19 May 2010 13:14
I'm wondering if there's an automated (ie, using VBA) method to write the VBA
code that underlies my forms and reports to a text output file, external to
the database. For example, if I have a form called frmItems that has a
module, is there a way I could create a file called "frmItems_vba.txt" that
would have the VBA code from the module associated with the form? Thanks!
From: Douglas J. Steele on 19 May 2010 13:59
Take a look at the undocumented SaveAsText method.

I talked about it in my February 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can read it online at
http://www.vb123.com/kb/200502_ds_saveas.htm or you can download the column
(and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"John B. Smotherman" <JohnBSmotherman(a)discussions.microsoft.com> wrote in
message news:EABBFCBF-FF2C-4336-B37E-D973D7049B95(a)microsoft.com...
> I'm wondering if there's an automated (ie, using VBA) method to write the
> VBA
> code that underlies my forms and reports to a text output file, external
> to
> the database. For example, if I have a form called frmItems that has a
> module, is there a way I could create a file called "frmItems_vba.txt"
> that
> would have the VBA code from the module associated with the form? Thanks!


From: John B. Smotherman on 19 May 2010 14:58
Outstanding! Thanks, Doug. I knew I'd seen something about it SOMEWHERE...

"Douglas J. Steele" wrote:

> Take a look at the undocumented SaveAsText method.
>
> I talked about it in my February 2005 "Access Answers" column in Pinnacle
> Publication's "Smart Access". You can read it online at
> http://www.vb123.com/kb/200502_ds_saveas.htm or you can download the column
> (and sample database) for free at
> http://www.accessmvp.com/djsteele/SmartAccess.html
>
> --
> Doug Steele, Microsoft Access MVP
> http://www.AccessMVP.com/DJSteele
> (no e-mails, please!)
>
> "John B. Smotherman" <JohnBSmotherman(a)discussions.microsoft.com> wrote in
> message news:EABBFCBF-FF2C-4336-B37E-D973D7049B95(a)microsoft.com...
> > I'm wondering if there's an automated (ie, using VBA) method to write the
> > VBA
> > code that underlies my forms and reports to a text output file, external
> > to
> > the database. For example, if I have a form called frmItems that has a
> > module, is there a way I could create a file called "frmItems_vba.txt"
> > that
> > would have the VBA code from the module associated with the form? Thanks!
>
>
> .
>
From: Mackster66 on 19 May 2010 15:02
You could use the built-in Documenter. Go to Tools>Analyze>Documenter. Go
to the Forms tab and select all and then click on the Options button. Select
Code on top and Nothing on the bottom and deselect the others. Go to the
Reports tab and click on the Options button. Select Code ont top and Nothing
on the bottom and deselect the others. Go to the Modules tab, select all and
then click on the Options button. Select Code and deselect the others.

Click the OK button and it will prepare the report. It may take a few
minutes if you have an extremely complex database. When it is complete,
select File>Export and export it as a .txt file.


"John B. Smotherman" wrote:

> I'm wondering if there's an automated (ie, using VBA) method to write the VBA
> code that underlies my forms and reports to a text output file, external to
> the database. For example, if I have a form called frmItems that has a
> module, is there a way I could create a file called "frmItems_vba.txt" that
> would have the VBA code from the module associated with the form? Thanks!
 | 
Pages: 1
Prev: Double click to open form
Next: netflix