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 [...]
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 [...]
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 [...]
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 [...]
I’ve been using Access 2007 for about an hour now, quickly developing a small database to store information on what periodicals I’ve been reading for my thesis, and when I have accessed them. Quick review - it is fairly impressive! Highlights are:
The Ribbon Gui common to all Office 2007 products is used very well in [...]
You are currently browsing the archives for the Ms Access Tips & Solutions category.
