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
  to
  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...

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

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

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.

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 TechRepublic.com 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.

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

Collect Data for an Access 2007 Database Using Outlook Emails

TechRepublic.com 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:

• VBA in Office 14
  17 January 08 12:27 PM


• Four new video demos about reports
  16 January 08 10:40 PM


• Rich formatted text that includes data from fields
  16 January 08 12:45 PM


• Easy Drill Through with Macros
  14 January 08 11:18 PM


• Interactive chart/form filtering code sample
  13 January 08 10:38 PM


• Tips and tricks designing forms and reports
  11 January 08 01:02 AM


• My favorite keyboard commands
  10 January 08 10:28 AM


• New Vehicle Maintenance and Expense Reports database available
  09 January 08 09:15 PM


• Using Hyperlinks in Access: Display As Hyperlink and Is Hyperlink
  09 January 08 08:47 PM


• New Ribbon Reference: RibbonX for Dummies
  06 January 08 02:12 AM