Visual Basic

For those desperate 'maintenance' programmers using VB, VBA, etc.

http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20715390.html - a Replace function for Access '97

http://www.vb-helper.com/comments_vb_net_top_ten.html - Top 10 reasons to move from VB6 to VB.NET

Message Queueing with MSMQ

Event-based receiving: http://www.developerfusion.com/show/2131/7/
MSDN documentation: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/msmq/msmq_ref_queue_1qcl.asp

Visual Basic

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

Programming