Wednesday, March 30, 2011

Sometime I just want to be single, okay?

(Guest blog by Banana)

On the surface, it appears that VBA does not like it very much when you want to have a Singleton class. Whenever I write a class module, which is kind of rare given the general patterns in Access/VBA development, it's almost inevitable I want a Singleton. The only reason it's a class in first place is because I need some variables declared WithEvents. We can't do that in a standard module, so it has to be a class module.

Sunday, March 20, 2011

No, Excel is NOT a Database

So, what's got my dander up today? I’m glad you asked.

Excel is NOT a database. You can't import Excel spreadsheets into Access and call that a database. You can't create "spreadsheets" directly in Access and call that a database. I wish more people understood that. It would make my blood pressure go down, probably down a lot.