Category Archives: General
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
Bringing Back the Hoff