Max Wanadoo
max.wanadoo at gmail.com
Thu Jan 28 12:01:24 CST 2010
1. Actually I was. I have been here for circa 10 years or so maybe longer, and can remember them well. 2. I actually use Classes. Yes, ones I have written myself and they work fine. The problem I have with them is that, FOR ME, do nothing that I cannot do with normal everyday code in a module BUT they do require a lot of overheads. 3. AND, if you recall, many years ago you could not copy classes between mdbs. From memory, you had to go through a convoluted series of steps to get it into a new module (not nowadays, but back then). 4. I like classes when I am leveraging methods and properties from, say Outlook. But the aruguments about Business Rules in one place just sucks. 4. And besides all that, all they guy wanted to do was parse a string.. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: 28 January 2010 17:38 To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2003:Replacing 'tokens' in a string Sigh, Max, you weren't on here during the bound/unbound debates. Those debates were monumental, and most of it was experience vs. experience. You are arguing with people that have already been down the path you have been. I don't think you will ever find a developer using OOP that hasn't done the basic line per line process too. And we all got pretty good at that first too. My initial experience with Access involved macros, and I could do some magic with macros. But then I ran into something that I couldn't do with a macro (in that particular case, I wanted to hide the Access window, not the DB window, the Access window, and that required an API call), I started to learn VBA. Do I still use macros? Yes, can't beat the AutoExec and AutoKeys feature of macros. Would I use a macro to open a form or run a query, nope, cause I can do that in code just as fast, and I get far more control. But it is simpler to open a form with a Macro, heck, you can drag a macro onto a form and it creates an command button automatically. Why would anyone use VBA code for such a simple task as opening a form? <grin> I am not trying to be derogatory here Max. You are a great programmer, I've seen a lot of the work you have posted. But this list is about sharing ideas and learning. I wish that this list had as many class posts as it does now, back when I first joined. I would have leaped ahead years before I did. So when you describe a class solution as horrendous, or classes are hammers, you give the WRONG, TOTALLY WRONG, impression of what classes are, and what they can do. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Thursday, January 28, 2010 7:39 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2003:Replacing 'tokens' in a string I would do Gustav, if and when I find I have a need for those languages. Everything i need at the moment is well handled by Access using VBA. Complexities is not an issue - in fact all those additonal properties and methods can be a real boon if and when needed. However, obfuscation is rife and needs to be whittled back so that the tyros do not get blinded by the aficianados. A simple request should, where possible, be given a simple solution. IMHO. sigh... max The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com