Category: Visual Basic for Applications
Avoid error “2427 You entered an expression that has no value” when passing a parameter to a form
To avoid getting an error when passing a variable to a form, using If Not against the EOF (I believe […]
In VBA strip out characters which cause TSQL to fail
A simple way to strip out characters which can cause TSQL Code to break. Assumes the SQL commannd is in […]
Microsoft Access 2010 loader
Credits (As what I consider the hard stuff was actually done by other people): TheSmileyCoder for the solid awesome little […]
Outlook 2010: VBA delay sending of emails until the next working day if outside of reasonable hours
This Outlook 2010 VBA code was used to impose a time when emails could not be sent and were instead […]