Author: Darragh
-
UN Internship FAQ and Other Tales
It’s been some time since I’ve blogged here. About a year in fact. My bad. I’m sorry, I’ve been busy. Anyway, I’ve finally gotten around to putting something up of use. The UN Internship FAQ. People kept commenting on my blog entries or sending me private message asking questions so I collated their questions and…
-
I’m now an United Nations Intern
If you’ve come here from Google and are looking for general UN Internship information, I’ve written up a post detailing some information about the selection process and what the internship is all about. View the UN Internship FAQ. Annoying Australian allowed into the UN general assembly It has been a hectic few days for me…
-
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…
-
Troubleshooting Potential Errors when Using Transactions in Ms Access – Do NOT Close the Workspace!
I was doing some recordset juggling in vba and out of habit I usually close every object I open up explicit using the .close method on that object. For example if I open up a database using something like this Dim db as dao.database Set db = currentDb I will close it at the end…
-
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.…
-
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…