[AccessD] Elegant Solution?

Paul Strauss Paul at PStrauss.net
Sat Sep 25 22:05:47 CDT 2004


At 9/24/2004 07:41 PM, you wrote:

>Vlad,
>
>If you're interested, I have developed a class called clsDAOLib that wraps
>the most common DAO functions.
>
>...snip...
>If anyone is interested, please email me offline for the code, and short
>instructions on use.

Looks very interesting, very cool. I'd like to take a look.

I also have a few goodies that I'll share with you if you want. I have one 
class that edits names and addresses to fix the proper capitalization and 
to change addresses into what the USPS likes to see, e.g. Avenue -> Ave. 
I've got a great function, that I didn't actually write that properly 
quotes string for use in SQL strings, e.g. it properly quotes 5'4". One I 
did write is a function to properly quote dates and times. These all have 
been testing and working for years. I've got a bunch of other random stuff 
that I use all the time. I've been doing Access for about 10 years now and 
one tends to accumulate these things. I'm also working on a class to do an 
audit trail of any changes to a row. This one may still have some bugs as 
I've just finished it and it still needs some testing, but it seems to be 
mostly working.

If you want any of this stuff, I'll be glad to send them my "return mail". 
One thing I'd ask, if you could, but certainly not as a condition: I almost 
never have the opportunity for anyone to review and comment on my code, so 
I really don't know what is good, bad, or ugly. If you could comment on it, 
I love to hear your comments.


Regards,
Paul Strauss


----------

•  Web Site Design, Graphics, and Hosting (www.RationalHosting.net)
•  MS Access Database Custom Applications
•  Technical Support and Consulting

718-253-5535 / 917-975-1729
<mailto:Paul at PStrauss.net>Paul at PStrauss.net  


More information about the AccessD mailing list