Excel tutorials in video

I was browsing through Pivot Table history (heard of but didn't look at Lotus Improv in its day) and came across DataPig's Excel Training videos. Well worth a look....

Help > About

The new Access 2007 UI is fine and all that, but where's classic Help > About?

It's now Office Button > Options > Resources > About.

Doh!

What a place to put it.

Changed in Access 2007: The Control Wizard

The Control Wizard in Access "classic" has provided VBA snippets or rather, full Sub...End Sub OnClick Procedures with error handling. People have copied the few productive lines in the procedures as well as the On Error procedure handling.

In Access 2007, the Control Wizard produces embedded macros in .accdb files. If, however, you work in a classic .mdb, the Control Wizard creates VBA code and improved VBA code over classic.

Run through making a "Close Form" button with the Control Wizard in an .mdb. You'll find that the VBA code has:

If Me.Dirty Then Me.Dirty = False
DoCmd.Close

The Me.Dirty was missing the the Classic Control Wizard.
In the .accdb, the Wizard produces a macro with a Close Action, with a Prompt To Save parameter.
I see no sign of Dirty.

Related articles by Zemanta

• Access 2007: Go to a Record Combo Box Wizard
• Access 2007 for newbies books
• What Visual Basic's Office return means for Mac IT
• VBA to return in next version of Microsoft Office; SP1 released

Stumbled across this presentation

No Powerpoint, just flip charts and some music. Sure works for me

Powerpoint Goodies and Fun

Shyam Pillai, a Microsoft Powerpoint MVP, has heaps of paid and free goodies for Powerpointers.

• a VBA Programming section
• a General Tips section inclusive of Word and Excel tips
• an Add-Ins section featuring LiveWeb - surfing the web inside a Powerpoint show.
  

Reading RibbonX for Dummies

RibbonX for Dummies, it's a well written book, able to maintain my interest. However, someone needs to produce a webpage of link resources quotes in the book - the editing team doesn't seem to understand how to use TINYURL.COM or to use keyword recommendations in Google searching so that people do not have to key in the long urls by hand.

1. Office 2007: List of Control IDs from Microsoft Downloads
   
2. 2007 Office System: XML Schema Reference
   
3. openXMLDeveloper.org: Office 2007 Custom UI Editor Tool 

Associated Resources:

1. Developer Overview of UI
2. Customizing the 2007 Office Fluent Ribbon for Developers Part 1 (Ken Getz, MSDN)
3. ..part 2
4. ..part 3
5. Developer Screencast (.wmv direct link)
6. Savraj Dhanjal blog entry: RibbonX Resources
7. OpenXMLDeveloper list of learning articles
8. UI Style Guide for Solutions and Add Ins
9. Icons Gallery