Monday, March 30, 2009

Microsoft Access VBA

I just had a look around at some Access VBA books. I would recommend some human interaction, tuition so that you get the “inside story” on why one would use one approach or another as supplement to these books though.

Access 2007 VBA Programmer's Reference (Programmer to Programmer) (Paperback) seems to be a well documented reference.


Automating Microsoft Access with VBA (Business Solutions) (Paperback) by Mike Gunderloy and Susan Sales Harkins is probably Mike’s last book on Access. Comprehensive.

Beginning Access 2007 VBA (Paperback) by Denise Gosnell is more brief.


Access 2007 VBA Programming For Dummies (For Dummies (Computer/Tech)) (Paperback)  should have a fair number of tips, but it is not intending to school you in VBA.

Helen Feddema’s Access 2007 VBA Bible: For Data-Centric Microsoft Office Applications (Paperback) appears not so much about Access and VBA but about invoking Outlook, Word, Excel and making them play with Access.

Expert Access 2007 Programming (Programmer to Programmer) (Paperback) is for more esoteric manipulations.

Thursday, March 19, 2009

Snippets of Microsoft Access Tutorials

Whilst training, I may show and walkthrough a feature that is relevant to my class but don’t have the resources or time to produce a documented tutorial. Microsoft is doing it’s part in providing activity specific tutorials.

Using queries as a datasource for Forms – In introductory classes we tell people that a Form can display records from a table and a query (and optionally an SQL string). You can create a Form by walking through a wizard. If you want to set up a form manually, well, this is the tutorial.

There are two ways to create an Access Switchboard – i.e. a Form festooned with buttons that acts as the main “menu” to your system. One is to create a blank form and put buttons on yourself. The other is to use the famous Switchboard Manager. Tags: ,
From Melbourne

Wednesday, March 18, 2009

Luke Chung speaks on Microsoft Access on MSDN

Microsoft Office Access

Image via Wikipedia

Luke has been a hero of mine. He sure looks a lot younger than I feel, his hair is still black! I love his FMS Inc. product – Total Access Analyzer.

Luke’s Channel 9 MSDN video interview here.

He writes about the Top Features of Microsoft Access 2007 that aren’t available in Prior Versions and Microsoft Office Access 2007 Form Tips.

Reblog this post [with Zemanta]

Saturday, March 14, 2009

Around the Office

Microsoft PowerPoint

Image via Wikipedia

There seem to be more businesses and government departments migrating to Microsoft Office 2007. Although Microsoft Office and Windows are intertwined products and Microsoft uses this as a marketing approach, it’s my perception that Microsoft Office has overcome a lot of trials and tribulations about The Ribbon interface, picking up small and big business customers, inspite of the lacklustre reception of Windows Vista. Maybe that’s why Sinofsky, the Office head in Microsoft is now helming Windows.

Powerpoint 2007 is to me, a real re-architection of classic Powerpoint – full, redblooded restructure. The completely new Slide Master, Slide Layout framework is very welcome but also requires some double takes as one grapples with how Slide Headers and Footers work. Why did they nuance Headers and Footers this way, when they could re-jig the Slide Master, Slide Layout concept? Maybe they ran out of time or they had a roadblock in the idea?

My good friend Gerhard also notes that Microsoft Word’s Headers and Footers User Interface has been re-jigged. But that’s more User Interface – substituting the classic Header / Footer editing pane and icon bar with reworked QuickParts (which were there as AutoText in Word classic). You can still, if you knew / know how, carry out classic Word Header / Footer production using Word Field Codes.

Meanwhile, on a side note, the Tutorial Blog has a tutorial on using Hyperlinks in Powerpoint 2007.

In the Simple Thoughts blog, amongst the 10 MS Excel Hacks and Tips, there is one that would quickly become a favourite with Excel users:

9. How to Paste Column Widths

To copy paste the cells you use Ctrl C and Ctrl V. But this doesn't paste the column widths that can accommodate that data. So what you do

• Use the normal Paste option to paste in the data and cell formats
• Right click on the new range of data you have pasted
• Click the Paste Special, and select the Column Widths radio button.


Related articles by Zemanta

Reblog this post [with Zemanta]

Wednesday, March 11, 2009

What about VBA?

I have an eye on Dick Kuleiska’s blog. He just posted a quick one on the future of VBA. There were some informed responses, I thought, might as well weigh in with my 50lb boots….

Read my response here.