[AccessD] Converting Macros - Access XP

John Colby jcolby at colbyconsulting.com
Tue Oct 7 18:34:24 CDT 2003


Well... that runs IF you are in the macro window (command not available
otherwise) and converts the SINGLE macro that is currently selected.

There are ~50 different macros in the macro window.  I am trying to convert
ALL of them at once.  Sounds like I need to bracket that with code that
selects each macro in turn and then runs that line.  I was hoping someone
had done this already.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Tuesday, October 07, 2003 2:02 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Converting Macros - Access XP


DoCmd.RunCommand acCmdConvertMacrosToVisualBasic

Charlotte Foust

-----Original Message-----
From: John Colby [mailto:jcolby at colbyconsulting.com]
Sent: Tuesday, October 07, 2003 9:41 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Converting Macros - Access XP


Believe me, I would (If I knew how).

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark
Sent: Tuesday, October 07, 2003 9:28 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Converting Macros - Access XP


Write a macro?

...sorry couldn't resist;)


Mark



-----Original Message-----
From: John Colby [mailto:jcolby at colbyconsulting.com]
Sent: Tuesday, October 07, 2003 3:50 AM
To: AccessD
Subject: [AccessD] Converting Macros - Access XP


I am inheriting an OLD application converted over the years up to
AccessXP. It has ~50 macros that in general do nothing other than open
forms, reports etc.  I thought there was something that would convert
ALL the macros to VB at one shot.  I can select a SINGLE macro. and the
wizard converts that single macro, but I'd prefer to do them all at
once.

Anyone know how this is done?

John W. Colby
www.colbyconsulting.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



_______________________________________________
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