Category Archives: Programming

Can’t find the form “|” referred to: Solved

Sorry for yet another technical article but I just can’t let this one slide. One of the most frustrating error messages you’re likely to encounter if you are doing any Access development is: can’t find the form “|” referred to … Continue reading

Posted in Programming | Leave a comment

Cannot create/shadow copy “File Name” when that file already exists

If you’re developing an assembly, placing it in the global assembly cache, and testing it from another application you probably want to keep making changes to the assembly, but don’t necessarily want to keep upping the version number (which means … Continue reading

Posted in Programming | 2 Comments

My History with Computers

Computers seem to be a dominant thing in my life. I work with them for eight hours a day, and all my hobbies involve a computer in some way, so I thought it might be fun to look back on … Continue reading

Posted in Programming | Leave a comment

‘At most one record can be returned by this subquery’ on SELECT TOP 1

Anyone who has had to write any Jet SQL for an Access database is probably well aquainted with frustration. The way it nests its joins is horrendous for one thing, but here’s a little trap that caught me up recently. … Continue reading

Posted in Programming | 1 Comment

Stack Overflow with Word Automation Replace – SOLVED

When performing Word automation, Word will sometimes throw a System.StackOverflowException, which you cannot catch, while performing a find/replace operation. It is usually the Find.Replacement.ClearFormatting(); call that leads to this exception. The solution to this is simple, use late binding. In … Continue reading

Posted in Programming | Leave a comment