How To Convert Macros To VBA

This video describes how to use
an embedded macro to open a form,
and then use the superior, VBA, code
to do the same.

video:

There is more functionality when
using VBA to do your actions.

Personally, I don’t use macros, unless I
need to.

If you want to try and convert your macros
to VBA, click and go into design view on
the form containing the macros..

In the far right of the Form Design Toolbar is
the “Convert Form’s Macros to Visual Basic”.

Click the action, and the converter will do
the job of converting your macros to VBA.

For the cases that your conversion is
not totally successful, you’ll have to do
a little tweaking yourself.

[sourcecode language=”vb”]
Option Compare Database

‘========================================================
‘DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013
‘ERIK LOEBL(713)409-7041
‘EMAIL: erik@loeblcomservices.com
‘WEB: http://loeblcomservices.com
‘========================================================

‘frmOpen:

Private Sub btnClose_Click()
DoCmd.Close acForm, Me.Name

End Sub

‘frmUseVBAToOpenForm

Private Sub btnVBA_Click()
DoCmd.OpenForm "frmOpen"

MsgBox "Now do this…"
End Sub

[/sourcecode]

Click here for the database and the code:
convert_macro_to_vba.accdb


Comments are closed.