Authored by Ben Clothier The other day Juan needed my help with a query that required a special technique commonly known as the Strawberry query. He needed a way to match one group of records with the first occurrence of a item in another table. From that I decided to write this post to share the te [...]
A while back I wrote about a Inner Join technique using a date range. (You can find that post here.) Today I'm going to take it a step further and discuss using inner joins to another query and conclude with an issue in Access you may shed some light on. Using Queries as Inner Joins For the longes [...]
A while back I talked about a problem one of my clients was having with Windows 7 64 bit and Access 2010/2007. It was terribly slow and unacceptable. You can see the original post here. Solution Found - Turn off the LLMNR Protocol My client waited long and hard to get this resolved, but Microsoft di [...]
Creating a primary key using that is also a auto increment field in code can be challenging. This article will discuss how to do so in two steps.
I'll be presenting on using Access with SQL Server as a business intelligence, (BI), tool and will cover the following three areas: Using SQL Server as a dashboard agregator with Access Creating powerful Crosstab queries in Access Using Pivot Table Tools Creating Sub-Totals in both Crosstab and Pivo [...]
I use SQLOLEDB a lot in my code, thinking I was bypassing some of the ODBC stack. Now it turns out we can use ODBC after all in our connection strings. Here is the post from Microsoft: http://blogs.technet.com/b/dataplatforminsider/archive/2011/08/29/microsoft-aligning-with-odbc.aspx It's probably g [...]
The other day I asked Ben to help me with a thorny problem, I needed to match records in one table with records in another table using a date range. Here's the table I needed to update, called tblWidgets: WidgetID DateProduced WidgetWeekID ------- ------------ ---- 1 1/2/11 2 1/16/11 3 1/31/11 Widge [...]
He's gone. And we are all fortunate to have had him with us, just as we had Einstein, Edison, Pasteur, and many others. Men of impact, men who expanded their world to touch the next one in the future and bring it back. Steve had taken calligraphy classes and had wanted the same effect on the Mac, wh [...]
Friends, family and blog readers: I've been named an Access MVP! It's the highest honor I can achieve in my field and I'm proud to wear the badge. With my accomplishment I join a brotherhood of professionals committed to promoting Access and helping others with their Access problems. There are only [...]
I'll be presenting at CTAUG this month! Below are the details, would love to meet my blog readers in the area and have a great evenning of fun, Access and SQL Server in depth. Where: Microsoft Offices, Farmington, CT Pondview Corporate Center 74 Batterson Park Rd., #100 Farmington, CT 06032 (800) 67 [...]
Frequently, we work remotely on our clients' network, doing development work with one of their workstations and/or servers. As a consequence, it's not always desirable or practical to install our favorite utilities. We therefore make good use of online utilities that can help make development easier [...]