Friday, February 29, 2008

Single, Double Comparison Accuracy

Understanding problems with single precision and double precision can get you unstuck. Here is description of the problem all be it from a perspective.

Visual Studio Magazine Online | On VB: Maximize Comparison Accuracy

Personnaly the biggest problem in Access with single precision fields occurs when you use Sum or Avg in group by queries. The results generally come up with a figure that has some weird significant figures. The solution in this case involves changing the field from single precision to double precision. This will increase the table size by 4bytes*no_of_rows which can prove significant in large tables.

Garry Robinson

Monday, February 25, 2008

Check out Garry's new blog

I have now started a new blog on web 2 software at the following location

Even easier sign up for the newsletter (it probably will only come out every other month)

Friday, February 22, 2008

FTP From An Access Database

I recently came across a good looking FTP solution written by Danny Lesandrini and Dev Ashish. If getting files on and off the web is what you are after, this will help. Just a word of warning, this article uses the Shell command and large companies may have turned off "Shell"ing of applications like FTP altogether.

Read the article


Friday, February 15, 2008

Good looking forms (in less that 100 words)

I was asked how to make a better looking Access form

Generally the format these days is lighter (no bolds) and only buttons have raised the raised effect. No sunken controls. No underlined text unless it is a hyperlink

Fonts seem to look best like this (these occur on all machines that run Access)

MS Sans Serif for the field boxes and combos.
Verdana for the captions and labels but only if the form has a lot of space.
Arial if the form is pressed for space
Tahoma if space is really tight (also applies to boxes).

Tuesday, February 12, 2008

New Internet Programming Language?

There could be a new internet Programming language coming to Microsoft. Not sure I totally get it, why don't you have a read.