Thursday, March 11, 2010

Access small business database book

A few of the Access MVPs got together to produce a book specifically for small business people Access Small Business Solutions

Coverage includes:

Elements of a Microsoft Access Database | Relational Data Model |  Dealing with Customers and Customer Data | Customer Relationship Management Database Solutions | Marketing Database Solutions | Sales Database Solutions  |  Producing and Tracking the Goods & Services  |  Production and Manufacturing Database Solutions  | Inventory Management Database Solutions  | Services Database Solutions  |  Tracking and Analyzing Financial Data 1 | Accounting Systems: Requirements and Design Database Solutions  | 
Accounting: Budgeting, Analysis, and Reporting Database Solutions  |  Managing Memberships  |
SQL Server and Other External Data Sources

Monday, March 08, 2010

A good writing blog

Writing is an art, I am a programmer so don't think "tink" I can write.  Here is a blog on writing to whet your appetitie

Sunday, March 07, 2010

Raining Fish

We have had a lot of rain in Australia lately with some floods reaching record levels but this town in the desert reporting fish falling from the sky.  They are 300 miles from the coast.

Wednesday, March 03, 2010

Google Apps - Not So Easy

This week I had a ambition, I wanted to see if I could respond to my emails online and on a phone and then file them away into a folder so I didnt have to read them again in Outlook.  So I went to Google as the Calendar App mentioned sharing and 2 way sync. It worked pretty well except for the fact that google sync keeps trying to open Outlook even when its not open which is not so hot for backups.  The google calender online works well but looks pretty 90's. 6/10
Then I decided to move onto the Google Apps to do my emails and maybe even tasks.  Little did I know that I was heading into a product that basically would move all of my current email ISP offerings to Google and leave me making the decisions that a Microsoft Exchange manager would make. After a few hours, I gave up.  All I wanted was to sync my emails, not move the whole lot. I dont see Microsoft being too worried about google in that area yet.  2/10 or maybe a 7/10 if you hate MS Exchange and the $$$

Read a different opinion here Google-gains-momentum-with-apps

Tuesday, March 02, 2010

Outlook VBA Programming

Outlook 2010 VBA programming is discussed on this Microsoft Outlook page  Good to see VBA still getting top billing.

Accessing detailed file information provided by the Operating System

Have you ever wanted to find out generic properties about a file, such as the duration length of an MP3 file, or the date a JPEG picture file was taken on a digital camera?

Windows Explorer shows us this sort of information, so surely we can tap into this facility to programmatically access these properties?

Read on to find out how to do this in VBA.

Requires at least Windows Vista or newer.