A place where I can write irrelevant anecdotes that make me sound like a pretentious git.
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 [...]
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 [...]
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 an error [...]
I recently encountered a problem that I’ve actually encountered millions of times before - trying to run an SQL string from VBA code which makes use of double apostrophe’s (””). Naturally, VBA uses these to break from a string literal, but pure Jet-SQL uses them for functions like Format() and Nz().
So if you do [...]
You are currently browsing the archives for the VBA & Access Coding category.
