Konverting macro to vba code...

J

Jan T

Is there an easy way to convert Access 2003 macros to vba-code?

Thank you in advance.

Regards
Jan T.
 
A

Allen Browne

Try:
Tools | Macros | Convert to code

It's not the same as writing decent code, but it is essentially equivalent
to executing the macro.
 
J

Jan T

Try:
Tools | Macros | Convert to code

It's not the same as writing decent code, but it is essentially equivalent
to executing the macro.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html







- Vis sitert tekst -
Click to expand...

Right. The database I am thinking of, do have a lot of macros
already.
But, is there a way to push a button or a menu item to change
or convert the macro's to vba-code?

Like Tools/ DatabaseTools/ compress ... or something similar....

I think I remember having that done, but I am not sure and can't
figure out what
I did.
Any idéa?

Regards
Jan
 
U

UpRider

Jan, communicatons problem.
Allen's instructions will convert macros to VBA code. What he was saying is
that the conversion will not necessarily result in well written code. The
converter is clumsy and literal, sometimes humorous, but it works.

UpRider

Try:
Tools | Macros | Convert to code

It's not the same as writing decent code, but it is essentially equivalent
to executing the macro.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org."Jan T"







- Vis sitert tekst -
Click to expand...

Right. The database I am thinking of, do have a lot of macros
already.
But, is there a way to push a button or a menu item to change
or convert the macro's to vba-code?

Like Tools/ DatabaseTools/ compress ... or something similar....

I think I remember having that done, but I am not sure and can't
figure out what
I did.
Any idéa?

Regards
Jan
 
Top