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

Bill Benson bensonforums at gmail.com
Tue Mar 24 21:51:45 CDT 2015


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
>


More information about the AccessD mailing list