Hello all,
I've been on a six week break and have started a new assignment at another local corporate headquarters, won't say who. For the first time in 12 years I have to commute. I've had the good fortune up till now of being within walking distance. 20 miles each way won't sound bad to most people, but like I say, I've been spoiled. Work is work, though and so are corporate cultures. This one at least allows me to wear tennis shoes and blue jeans if I want to.
The oddest part of this new assignment is the heavy use Access throughout the department, maybe the company. These databases are all in versions 2003 and earlier and rely almost universally on macros, which I hate. They are reluctant to go VBA, but that's where I'm going to have to take them if they want much development. Also these databases have been developed by dozens of different users over a dozen years, most of whom never heard of naming conventions. Queries are named with sentences in some cases. Here's one "Delete Qry older than oldest date on stmt NOT CURRENTLY USED", here's another "Match Stmt to Qry FOR AGING export (45+)". Renaming these to something sensible and debugging the macros will not be fun, but there it is. Mostly just wanted to say hello here and watch out. I'm back.
Access questions will follow immediately.