Max Wanadoo
max.wanadoo at gmail.com
Mon Oct 26 13:32:45 CDT 2009
Apros pro Macros code, I have a free prog called Short-Keys and in there I build short common routines that previously I had to type over and over again. Now by pressing #x it magically appears already typed into my keyboard buffer and thus onto my screen. The # is my self-defined "invoke" key and the x denotes my keypress which relates to this particular invocation of a Short-Key. There is a limit in the free version but it is great for my needs. I was thinking of creating one for Max signature... Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 26 October 2009 18:18 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 Question Well, aside from being 'old school', functionally, what are their drawbacks? R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Monday, October 26, 2009 11:00 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 Question I, personally, was writing something like those macros thirty years ago for my calculator. Doesn't really appeal for Access. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Monday, October 26, 2009 10:01 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 Question In general, why is there a preference for VBA over macros? I can see where VBA might have more flexibility but for repetitive cookie cutter tasks aren't macros quite effective? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Monday, October 26, 2009 9:36 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 Question This gives you a good idea of where macros are going http://blogs.msdn.com/access/archive/2009/07/28/meet-the-access-2010-mac ro-d esigner.aspx Martin Martin WP Reid Information Services The Library at Queen's Tel : 02890976174 Email : mwp.reid at qub.ac.uk ________________________________________ From: accessd-bounces at databaseadvisors.com [accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust [cfoust at infostatsystems.com] Sent: 26 October 2009 16:22 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 Question Access certainly used to have a wizard for converting macros to code, but it didn't do a very good job, since it created obsolete code in the process. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Sunday, October 25, 2009 1:39 PM To: Access Developers discussion and problem solving Subject: [AccessD] Access 2007 Question I have downloaded and built all the Access 2007 template apps. Every single one of them does its magic with macros not with VBA. This begs some questions: 1. Does this indicate that developers are no longer welcome in the Access community? How are we to read this, when even Northwind has been translated to macros from VBA code? 2. Is there a wizard that converts a macro to VBA code? Or should I just cut and paste the macro in question to the code window and then attempt to translate it to VBA code? 3. Should we Access developers regard this as the definitive signal to move to Visual Studio or some other dev platform? (Just about the only thing that keeps me on Windows is Access; take away that and you may as well call me an Ubuntu boy.) Arthur -- -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com