For those desperate 'maintenance' programmers using VB, VBA, etc.
Message Queueing with MSMQ
I've been coding some VB (inside of MS Access) the last during the last week or so. The hard part wasn't writing the code, so much as deciphering what the previous programmer did (no comments/docs), how all the tables and reports and forms fit together, figuring out what data has to go into this nasty ASCII export format, then writing out a text file with all the required bits and pieces. Formatting strings is always a pain in VB, so I ended up writing my own tools like Pad, PadLeft, Change, etc. My biggest ARGH! frustration was that I forgot that bugs in a running program (like an accidental forever loop) will also take down the text editor and database. Not fun. Lost some code, but of course the second time goes muck quicker. --Wim