Using control tip property to display real time information
I was selected to be a guest blogger on the official Microsoft Access blog! You can read the article here: http://blogs.office.com/b/microsoft-access/archive/2011/11/28/display-real-time-information-with-the-controltip-property.aspx Please read and come back here for some final thoughts on the technique. Another alternative: DAO When I wrote the guest post I automatically selected ADODB since that’s what I use almost always in [...]
Running Access locally on a different domain using VPN
We develop solutions using Access on the desktop and SQL Server on the network for clients through out the US. Our standard method is to login to the client’s network via VPN and program on their server, since we couldn’t program on our development machines using the credentials provided by our client. They would clash [...]
Query Pattern: Finding the maximum/minimum and getting the full row
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 [...]
More fun with Inner Joins
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 [...]
Windows 7 64bit Slow with Access 2007 – Solved!
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 [...]
