[AccessD] Access 101 on VBA coding syntax

Susan Harkins ssharkins at gmail.com
Wed Apr 23 06:37:04 CDT 2008


> This might sound really dumb but I want to get it clear in my head.  Been 
> reading the Access 2002 Desktop Dev handbook and it seems nothing I have 
> done in the past has been anything like how it should have been done. 
> Despite this the stuff I have built seems to work fine (well, most of the 
> time anyway). That said, none of it has been enterprise standard and/or 
> rocket science.

====First, if your code works and performs well, it doesn't need to look 
someone else's.  Second, I love the Developer handbooks, they are great 
tools. Third, I find some of their solutions awash in unnecessary 
foldarah --- please put your torches down folks and let me explain. They 
approach every problem from the standpoint that the code will be reused, 
will be expanded upon, must be "parameter ready", and frankly, most people 
using Access just don't work that way. I love the way their minds work, but 
I also love stripping their code and applying it the way most Access users 
would. :) But... that's just me. So, what I'm saying is -- the Developers 
handbook is just one way to do things, and you've found another.

I do think that anytime you can write a function so that it's more versatile 
and reusable, you win.

Susan H. 




More information about the AccessD mailing list