SQL Server Stored Procedure Guide for Microsoft Access – Part 1
SQL Server Stored Procedures are a great way to leverage SQL Server with your Access database. This post will explain how to use Stored Procedures using Pass Through Queries.
Self-healing Objects
Use self-healing objects to avoid problems with objects not being initialized when running your code.
Use temp tables in your code for quick and easy analysis
Learn to use temp tables in your Access code.
Dynamically sorting forms and reports
Learn how to order forms and reports dynamically using the open event.
Importing Outlook emails into Access
Article describes how to import Outlook emails into Microsoft Access using code.
SharePoint Lists and Microsoft Access in depth
Article will describe how to use SharePoint lists in depth with Microsoft Access.
SharePoint and Access: How do they fit together?
Note: This is the first part of a three part series, you can find the second part here and the third part here. Hello, Access with SQL Server blog readers! This is my first post since joining the firm and I look forward to many more! Both Juan and I will be blogging here about Access, SQL Server and [...]
Winner Announced: Amazon gift card
Last month I wrote a three piece series on the Access IDE. If you read through the whole article you would have seen anyone posting a comment through the series they would be entered into a $25 giveaway after comments had been closed on the last post. Thanks for everyone who left a comment, the winn [...]
Introducing Ben Clothier
The IT Impact family is growing with the addition of Access MVP Ben Clothier as a Senior Access Developer. Ben has been developing for many years with Access and has an impressive list of accomplishments: He's been an Access MVP since 2009, based in part on his ground breaking work integrating Acces [...]
When to use a form's recordset and when to use recordsetclone
Recordsets are an essential tool of any Access programmer, there are many types and are used in a wide range of situations, today we're going to talk about form recordsets and provide some examples of their use. What are Form Recordsets? If your form has a data source, either a table or query, it ha [...]
In San Jose/Aptos Area until May 26th 2011
Hello Everyone, Just wanted to let you know I'll be in the San Jose/Aptos California area from May 17th through May 26th. I'm available for any Access/SQL Server user meetings or meetups with other Access enthusiasts to talk about Access and/or Access with SQL Server over coffee. Perhaps you've alwa [...]