New MSDN Articles on VBA In Office 2010

• Getting Started with VBA in Office 2010
• Working with VBA in Office 2010 (32-bit) and Office 2010 (64-bit)

Over 60 Free Controls from DevExpress!

Coinciding with the launch of Visual Studio 2010, DevExpress is offering a vast library of cutting edge controls for FREE!

Go to: http://www.devexpress.com/Products/Free/WebRegistration60/

Latest Access 2007 Technical Articles and VBA Code Samples on MSDN

Basics for Building Access 2007 Runtime-Based Solutions

Building SQL Statements that Include Variables and Controls in Access 2007

Constructing Modern Time Elapsed Strings in Access 2007

Counting the Number of Working Days in Access 2007

Creating Managed Add-ins for Access 2007

Customizing the Office Fluent User Interface in Access 2007

Deploying Access 2007 Runtime-Based Solutions

Developing Access 2007 Solutions with Native C or C++

Developer Considerations for Choosing File Formats in Access 2007

Error Handling and Debugging Tips for Access 2007, VB, and VBA

Integrating Workflows into Access 2007 Applications

Performance Tips to Speed Up Your Access 2007 Database

Security Considerations and Guidance for Access 2007

Tips and Techniques for Queries in Access 2007

Transitioning Your Existing Access Applications to Access 2007

Using Excel Date Functions in Access 2007

Using SQL Server 2008 Table-valued Parameters in Access 2007

Elapsed Time Sample Database for Access 2007
Excel 2007 Pivot Table Filtering
Excel Functions Sample Database for Access 2007
InfoPath 2007 Localizing Form Templates Sample
Working Days Sample Database for Access 2007

Two Excellent Coding Blogs for Access Developers

I recently discovered these two bogs maintained by Shanmuga Sundara Raman Murugan, a Systems Engineer:

• VBA Tips & Tricks
  
  
• SQL Tips & Tricks

Dot vs. Bang: Put to Rest

The issue of whether two use a DOT(.) or BANG(!) when referring to a form field or control in Access VBA viz:

• Form1.Control1
• Form1!Control1

has been an issue of contention ever since Access 95.

Now Access MVP Michael Kaplan in a post on the Access Team Blog has provided a definitive guide:

• The dot gives you early binding and is resolved at compile time, the bang is resolved at runtime.
• In the case of Forms, both controls and fields in the underlying query can be referenced via a dot since they are all in the type library for the form.
• Also in the case of Forms, if you change the underlying query at runtime - dot references to the old query's fields will fail at runtime since update of the Form's type library cannot happen at runtime.
• Because the dot is early bound, IntelliSense happens by default with the dot, not with the bang.
• The dot (since it is early bound) is faster than the bang, but no one runs enough code that uses these items enough for the performance difference to actually matter.

I have been a long-time convert to the DOT based on the sheer convenience of the IntelliSense default being the DOT.

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.

How To Export E-mail Messages to Access using VBA

From TechRepublic.Com blogger, Susan Harkins.

Exporting Outlook folders and their contents is a common and simple enough task most of the time using the Import And Export Wizard. But you can’t append records to an existing file using the Wizard. If you want to export frequently to the same database, or if you just want to take the process out of user hands, use VBA to automate the export. Article and Code

How To Use VBA Variables

Download a free sample chapter from VBA for the 2007 Microsoft Office System (Que) exploring variables and how to use them in your VBA procedures.

Chapter topics include:

• Declaring variables
• Avoiding variable errors
• Understanding variable data types
• Using array variables
• Working with constants
• Storing user input in a variable

Courtesy of TechRepublic.com.

Application Development Tips

From Aivisto.com:

User Interface Bug Tests Test your application for common bugs in the User Interface (GUI). This article shows 10 quick ways to find nasty bugs.

Optimize string handling in VB6 - Part II Get to know the performance of VB string functions. Learn the fast functions and the slow ones to avoid. Learn to call the Windows Unicode API functions and to build really, really huge strings without crashing your app.

InStr Function InStr is a powerful string function. It's the perfect way to search and test strings in robust applications. This article shows how to call InStr to perform advanced text processing tasks quickly.