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