Tuesday, November 26, 2013

How to make X-Y plots using MS Graph in Access 2007

Ever thought about turning X-Y coordinate data into a grid of results with cells containing the average of all points in the cell.  This article on spatial data will show you that Access can do it. The download in Accdb format with the spatial code is here

Thursday, November 21, 2013

How do people get a barcode on a report ?

Just in case you didn't know, you can add a bar code to a report by adding a Bar Code font.  Then you simply put the numbers/text you want in the report and change the font to the bar code font and hey presto, there is the barcode. 

If you look at the second picture you will see the barcode font in action where the Barcode says Hello Readers. 

Garry Robinson

There was an article on barcodes in Smart Access back in the 90s.

Wednesday, November 20, 2013

J Street Access Relinker 2 now available

If you have an Access Front-End ~ Back-end database configuration, you may grow tired of using the built in MS Access relinking tool. If so, you may want to check out the J Street Access Relinker free download, supports 64-bit Access and encrypted BE databases. Armen Stein, Access MVP.

Tuesday, November 12, 2013

A challenge - Finding the last value in query

Peter Henreid writes

     Until recently, I have never been able to get the LAST function to work within a GroupBy and I need this a lot.  It returns random results, it seems no matter how the primary key is structured.  I always have to use a tri-level query because the sub-queries are too slow.  Yesterday, I just decided there must be a solution to it somewhere so I googled probably for the 10th time over the years – same articles, use tri-level query (one level to find the record that contains the max, next level to retrieve the desired field value, then join this query into the main query… a pain), but then in the very small print of one post, without explanation, I found this link.  As far as I can tell so far, it works and is just darn clever (not all that intuitive unless you really think about it).


And here is the second article that I ever wrote on consolidation queries for a bit more background on group by queries.  Garry Robinson