How to convert embedded macros to VBA code in 2007 forms

M

M Skabialka

I downloaded an Access 2007 sample database from Microsoft because I liked
the layout of the forms. However I am finding that many of the form
functions (e.g.Close form) are embedded macros. I have used Access to
convert database macros to VBA code before when they were part of the
database itself, not embedded into a form. Is there a way to convert these
macros into code so I can use what they do, but remove all macros (which I
thought were really obsolete)? Macros baffle me - I never use them.
e.g.
On error Next,
SendObject , , , =[Contact Name] & IIf(Nz([E-mail Address])<>""," [" &
[E-mail Address] & "]"), , , , , Yes,
[MacroError].[Number]<>0 MsgBox =[MacroError].[Description], Yes,
None,

Thanks,
Mich
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top