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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
When querying SQL Server date fields in Access, you may need to use the time specification to get all of the records in your date range.
Over the weekend I had the great pleasure to participate in SQL Saturday #73 in Orange County California, my two sessions were well attended and I had a lot of interest from SQL Server professionals on how to maximize performance between Access and SQL. Why I won't post my presentation I received nu [...]
When: Monday, Apr 11, 2011 6:30 PM (CDT) Where: Hinsdale, IL *~*~*~*~*~*~*~*~*~* CCS West Suburban Access Developers, Tomorrow's presentation by Juan Soto at Mary Sue's will also be webcast via LiveMeeting. This email should contain the details needed to connect to the webcast. Here is the informati [...]
Conditional formatting is a great feature introduced in Access 2000, it allows you to apply different formats to records on a form based on values and formulas you setup. In this example, I'm going to build on an article by Microsoft you can find here. Colors are better for some... My client wanted [...]