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
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