Visual Basic for Applications articles

Create temp tables in Access from SQL Server tables

If you've ever asked Access to do a join between a local Access table and SQL Server table (which is called a heterogeneous join) you may have experienced first hand how slow it can be to process results. The situation could be vastly superior if you can afford to download the SQL table as a tempora [...]

2015-07-03T20:01:28-05:00January 10th, 2012|

New book for Access Web Database and SharePoint now available!

As Juan may have mentioned earlier, I had been working with two other MVPs, Tim Runcie and George Hepworth in producing the first of its kind, a book dedicated to using Access with SharePoint. The book can be bought online at the Advsicon store. If you're wanting to learn more about the capabilities [...]

2022-08-02T10:24:32-05:00December 17th, 2011|

How to work offline with SharePoint and Access 2010

One advantage a SharePoint list has over any ODBC data source is that Access can disconnect and re-connect and synchronize the local edits back to the server fairly seamlessly. It also provides a friendly conflict resolution management, all out of the box. This is available whether you're using a tr [...]

2016-03-08T01:13:58-06:00December 8th, 2011|

Stored Procedure Guide for Microsoft Access – Part 2

This is part 2 in a multi-part series on Stored Procedures with Access, Part 1 can be found here and Part 3 here. In the first part of my guide I talked about using Pass Through queries as a convenient way to use Stored Procedures in Microsoft Access, in this second post I'm going to take it a step [...]

2021-03-18T07:06:33-05:00August 15th, 2011|

Self-healing Objects

Use self-healing objects to avoid problems with objects not being initialized when running your code.

2011-07-26T22:37:35-05:00July 26th, 2011|

Use Batch Transactions with SQL Server to Guarantee Results

Batch transactions are a great way to avoid orphan records and to guarantee the database has performed all of the actions you have requested. This post will discuss how you can incorporate batch transactions in Access VBA using SQL Server. Why Batch? Normally you would use referential integrity and [...]

2011-06-06T17:47:26-05:00June 6th, 2011|

Multi-Session Global Variables

Global variables are a wonderful way to make your code consistent, powerful and easy to use, but the native Access global variable, one declared in a stand alone module has a critical flaw: it will reset if there is a problem in your code, and it does not retain it's value once you close Access. Use [...]

2017-04-03T18:49:36-05:00January 12th, 2011|

Using IIF examples and tips

IIF can be used in a wide range of situations: when building complex strings or invoking commands.

2020-09-18T17:11:10-05:00December 10th, 2010|
Go to Top