Category Archives: General

Bringing Back the Hoff

My father is occasionally known for some fairly random but hilarious behaviour. I’ve made it an occasional hobby of mine to document some of his more inventive brain snaps, but not currently being in the country at the moment, I must rely on my siblings to provide with dad’s unique brand of comedy gold. The [...]
Posted in General | Leave a comment

Red Alert

Hi all. DM.com is changing. I’ve removed all the previous content excepting the tech tips. The old content will be edited and moved to a new home. This web page will get a face lift sometime in 2010 and serve simply as small place on the web with some information vaguely related to myself. More….soon. [...]
Posted in General | Leave a comment

Ever wanted to retreive the label information of a textbox control in Ms Access?

Been a while since I’ve written one of these things. Truth is, I haven’t been doing much Access databases in some time. However, I’m back in the fold, writing a small Access 2007 app and reacquianting myself with its nuances and idiosynchroses. In the process, I stumbled across a small little feature that, while obvious [...]
Posted in General | Leave a comment

DCount – “You canceled the Previous Operation” error

Really really quick tip It seems that if you use dashes (-) in your field names for any table, and try to run functions on them in VBA like “DCount()”, you’ll keep encountering a Run-Time Error ‘2001′ “You canceled the previous operation”. My recommendation: get rid of dashes and underscores in your table field names. Edit: You will [...]
Posted in General | Comments closed

Argh! Wordpress post.php returns blank page…solution.

Yes, wordpress is being annoying. I was having a problem with publishing new posts after upgrading to the latest wordpress. I would write a post, hit publish, and the post.php would appear, BLANK. No real explanation was given. I did notice that the post I had selected to publish turned up as a draft. Trying to [...]
Posted in General | Comments closed

A useful fashion to code multiple filters on an Access form

Programming an form filter in Ms Access is simple enough. Assume you have a combo box with two values – TRUE or FALSE – on some sort of boolean control. You want the filter to set this value to TRUE when the combo box reads TRUE, and vice versa. Usually you would simply put some [...]
Posted in General | Leave a comment