[AccessD] Sample vba to get code (event procedure code) behindform/controls

[Stuart McLachlan]

Yep, it gets the whole form as well as its code module.

On 24 Mar 2015 at 22:51, Bill Benson wrote:

> That gets a lot more than code right?
> On Mar 24, 2015 9:11 PM, "jack drawbridge" <jackandpat.d at gmail.com>
> wrote:
> 
> > Thanks Stuart and Bill,
> >
> > Yes SaveAsText/LoadAsText are probably best suited (easiest).
> >
> > Thanks for the quick response.
> > jack
> >
> > On Tue, Mar 24, 2015 at 8:55 PM, Bill Patten
> > <bill_patten at embarqmail.com> wrote:
> >
> > > Jack,
> > >
> > > I'm not sure I understand the question but If you want to export
> > > the code and controls behind a form use SaveAsText SaveAsText
> > > acForm, FormName as String, FileName as String
> > >
> > > Example SaveAsText "frmMain", "C:\FrmMain.txt"  to save the form
> > > in your
> > c:
> > > directory.
> > >
> > > Bill
> > >
> > > -----Original Message-----
> > > From: jack drawbridge
> > > Sent: Tuesday, March 24, 2015 5:30 PM
> > > To: Access Developers discussion and problem solving
> > > Subject: [AccessD] Sample vba to get code (event procedure code)
> > > behindform/controls
> > >
> > > Does anyone have some sample code showing how, using vba, to get
> > > the code behind a form and its controls? I have code to get
> > > standard module/procedure lines, but have been unable to find any
> > > code (or any
> > real
> > > info really) on how to get that code.
> > >
> > > Any advice and guidance  most appreciated.
> > >
> > > Thanks in advance,
> > > jack
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>