By Darragh|Ms Access Tips, Reports|Be the first to comment!
I haven’t done one of these in a long, long time, but I happen to be doing a bit of coding for a friend, and wanted to make a subreport control on an Access report invisible should it have no data. Of course, since I’ve been mostly out of the Access game for a while [...]
Continue Reading →By Darragh|Ms Access Tips, VBA|Be the first to comment!
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 [...]
Continue Reading →By Darragh|Ms Access Tips|38 Comments
A quick tip to fix what shouldn’t be a problem! Occasionally, Access can act rather confusingly. I ran into a typical example early this morning, when I was trying to get Access to allow entry of percentages correctly. I’ve done this about one thousand times before and probably solved this problem one thousand times as [...]
Continue Reading →Website of Darragh Murray, Brisbane-based writer whose interests include music, video games, international politics, football and Arsenal FC.
Home to the UN Internship FAQ.
Read more about me.