[AccessD] Access 101 on VBA coding syntax

Darryl Collins Darryl.Collins at coles.com.au
Wed Apr 23 16:10:48 CDT 2008



A big thank you to everyone for taking time to cover this question, and in such detail.  Your thoughts are very much appreciated.  And yep, I love the Dev handbook - I just need to try it all out and get my head around some of the concepts. 

Kind regards
Darryl.




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Wednesday, 23 April 2008 9:37 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 101 on VBA coding syntax


> 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. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses.  No warranty is made that this material is free from computer virus or any other defect or error.  Any loss/damage incurred by using this material is not the sender's responsibility.  The sender's entire liability will be limited to resupplying the material.




More information about the AccessD mailing list