Tuesday, March 27, 2012

How to find out how many records in multiple tables in one query

In the picture, you can see how I gathered up the total numbers of rows from more than one table.  Note how I use a "one" 1 in the DCount(1,"tableName") to refer to the first field in the query. This is easier than looking up the name of the first field.

Click on picture to enlarge

Wednesday, March 21, 2012

Google Plus

If you happen to be into Google+, and would like to track my Access articles in that environment, use this link You need to be a Google member to see my page.

Thursday, March 15, 2012

A New High Quality Website in 8 hours - you decide

I was bouncing around looking for a online website builder for my youtube posting mad eight year old when I stumbled across Weebly. The fact that it was one of 50th biggest websites in the world caught my eye. So I dived in. In 20 minutes I saw a lot of potential. 8 hours later I had revamped my boring old company website and here is the new home for my business information. If you like that, try the same www.gr-fx.com.au site in your android phone or iphone, it is optimised for small screens as well. If you want to create your own weebly site, follow this link,

The only caveat for a site like this is it only does what it does. If you want something customised, you are restricted to being able to add some html code and thats about it.

Wednesday, March 14, 2012

AutoIndex Gotcha - Access 2007/2010

The AutoIndex option, which is turned on from the Get Go in your databases, will automatically add Indexes to your tables without you knowing it is happening. This indexing article shows the symptoms and maybe even persuades you to turn off this "feature".

Monday, March 12, 2012

Backward Compatibility between 2010 and 2007

Reently I published a post on Scatterplots with a download accdb database. Somehow that file became 2010 only as discussed in a previous blog article. Now to downgrade the database, I found I had to open 2007 and make a blank database. Goto the 2010 database and open it in 2010. Export each object one by one to the 2007 database. Open the 2007 database in 2007 and it was fixed.  The 2007 version of the database is in the download now. This is way more complex than it needs to be.  Note that I switch Access versions using the Workbench

Monday, March 05, 2012

Indexed Words

Many years ago Microsoft wrote in its How to Write a Help Manual guide, that people were 30% more efficient when they used Indexed words to find the help they needed. Well if you didn't already know, vb123.com has hundreds of indexed words that you can use to find help topics. The picture below shows that you first click on the Key then start typing the Word and then click on the Word you want. If there is more than one page on the site that has that key Word, a list will be selected as in the figure. For those of you that have tried this before, I recently cleaned out a lot of words the cluttered your choices. Hopefully that will make it work even better.

Indexed words in action at vb123.com

Working Out The Size Of Objects in your Database

Whenever we are called in to fix a database that is misbehaving, we always head for the old standards of Compact and Repair, decompile and exporting all the objects into a brand new database.  When the dust settles and the database looks way too big for the information that you percieve is inside the database, there is nothing you can do to find out what is taking up all the space.  This page discusses how you can use the two recent save to text posts to work out the size of objects. There is also a link that discusses unnecessary indexes as they too can bloat a database a few percent.