Thursday, January 31, 2008

Scaling Access Forms

An open source VBA module for scaling Access forms for different display resolutions has been posted at SourceForge.

It is worth a look. I quickly tested the code in Access 2003, and for vanilla Access forms, it seems to work OK, subject to some tweaking(?):
  • Comment out the first line in the module
    Attribute VB_Name = "modScaleForm"
    as it does not compile and appears redundant

  • Change this line of code
    Dim fw As New clFormWindow
    Dim fw As New Form
    as there is no such class module and using the Form object seems to work

  • Font-scaling needs attention
In Access 2007, you can use the new native Anchoring property for form controls to achieve scaling, but don't use these techniques on complex forms with subforms or tab controls, as the result is less than satisfactory...

Wednesday, January 30, 2008

Useful Access 2007 Demos

Up to speed with Access 2007

Use control layouts on forms and reports

Collect data in Access 2007 by using e-mail

Bring your business data together in an Access database

Windows Vista and the 2007 Office system — better together

Find what you need faster with the redesigned Office Online

Meet the Navigation Pane

Monday, January 28, 2008

Office 2007 Ribbon XML File Reviewer Freeware

Click on the image to zoom in...

My new Access freeware tool provides advanced Office 2007 Ribbon XML file review features. Open your Ribbon XML file in the Reviewer to review the Ribbon's full menu hierarchy in a tree-view with all control attributes detailed in an adjacent panel. Extensive reference resources are also incorporated into the GUI.

Download (Requires Access 2007)

You can also try the free BETA 2 of Access 2007 RibbonX Reviewer and Builder Add-In

Wednesday, January 23, 2008

The Future of VBA?

A reading through this post, VBA in Office 14, on the Access Team Blog, seems to confirm that Office 14 will mark the beginning of the end for VBA.

This should be no surprise. Bill Gates in the months preceding the release of Office 2003, flagged that VBA would be demoted if not dumped in the version of Office after Office 12.

I have added my 2 cents to the debate in a comment to the post.

Monday, January 21, 2008

New Access Downloads Portal

Check out the new MS Silverlight Downloads Center. This is a link to the Access portal on the site.
How do I… Transfer data from a Word form to an Access database?

This is an excellent article from blogger, Mark Kaelin, on how to use a Word form to collect data for an Access database, even when the user's PC does not have Access installed.

Saturday, January 19, 2008

Support WebCast:
Introduction to the Access 2007 Outlook Add-in for Data Collection and Publishing

Friday, February 15, 2008 10:00 AM Pacific Time

This Support WebCast from Microsoft will help you understand the features and capabilities provided by the Microsoft Access Outlook Add-in for Data Collection and Publishing. Register

Friday, January 18, 2008

Collect Data for an Access 2007 Database Using Outlook Emails Office blogger, Mary Ann Richardson, has posted a very useful article on how to use the new Access 2007 Collect Data Through Outlook E-mail feature to automatically log data submitted by email direclty into an Access 2007 table.

SQL Server 2005 Best Practices Analyzer (January 2008)

This download is the January 2008 release of SQL Server 2005 Best Practices Analyzer (BPA), which gathers data from Microsoft Windows and SQL Server configuration settings.

BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in your SQL Server database environment.
Access Team Blog: For the Latest on Access 2007

The Access Team Blog from Microsoft has over recent weeks been receiving
some serious attention from the Access team at Redmond. I highly recommend that all
Access 20007 developers subscribe to the feed for tips and sample code from the guys who build Access.

A sample of recent posts: