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 [...]
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 [...]
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 [...]
PAUG Conference Review
We just wrapped the PAUG conference held at Silver Falls, (Portland Oregon) and this is my review of the weekend spent with other Access enthusiasts. Database Designer Conference The conference brought together a wide range of Access developers, users and Access enthusiasts. It started on Saturday a [...]
Access IDE Part III: My favorite development tools
This is the third part of a three part series on the Access IDE. Part I can be found here and Part II here. IDE Tools I Love Life in the Access IDE is a little easier with specialized IDE tools. In this final article of the series I'm going to let you in on my favorite tools, please comment on your [...]
10 New Features I wished I had in the Access IDE
This is the second part of a three part series on the Access IDE. Part I can be found here and Part III here. 10. Colored Command Buttons Call me a fashionista, but I'd love to have colored command buttons! 9. Collapsible Procedures Would love to have a "+" next to each procedure header to collapse [...]
10 things I love about the Access IDE
This is part one of a three part series on the Access IDE. Part II can be found here and Part III here. I work in the Access IDE, (Integrated Development Environment), all day and it helps to know a few tricks or ten on how to take advantage of the environment. 10. Before you can fix your code you n [...]