Author: Darragh
-
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…
-
Access Report Design – Cluttered Controls – Can Grow & Can Shrink
Here’s a quick tip with regards to report, and to a lesser extent, form design. Many times when you’re design Ms Access reports, often you will come across spatial problems, where you simply trying to fit too many controls (usually textboxes) on a report – even when you’re designing in landscape mode. Two extremely handy…
-
Ms Access 2003 Bug – Crash after Compact/Repair & Autonumber Resetting
Two little tidbits of information today. Firstly, a bug that occurs in Access 2003 after you try run the Compact/Repair function. This is a really annoying bug that seems to occur randomly in Access 2003. What happens is that for one reason or another your database corrupts, and when you try open it, Access tells…
-
Ms Access – Cannot make MDE file error
Well, as usual, I published Access tips in response to problems that I come across, and get around, during my day-to-day Ms Access development. As we know, Ms Access ain’t exactly the most stable product ever made and there are many bugs which often occur with badly explained non-sensical error messages. Today, I kept getting…
-
Quick Tip – Conditional Formatting on Ms Access Reports
This is one little annoying problem that there is not enough obvious documentation for within Ms Access 2007. While it might seem obvious enough, at the time, it wasn’t to me (so who is to blame, my lack of knowledge, the software interface, or the help documentation?). I was developing a report in Ms Access…