On May 13th, at 6:30 PM CST, I will be speaking about how you can easily create a solution that enable you to have your Access program working across broad geographic regions by leveraging SQL Azure Data Sync which is still in preview. In the talk, we will demonstrate how to get set up with replicat [...]
I am pleased to announce that AccessUserGroups.org have now developed further chapters, each of which have their own meetings online. The first one is today by Access Functions Group. The meeting will start at 7.00pm EDT, and will cover nulls, the Nz function, and two user-defined functions to easi [...]
The time has come to create a platform that will allow Access users a way to meet virtually and discuss a wide range of topics. It is with great excitement that Ben and I introduce AccessUserGroups.org Why virtual access user groups make sense I've had the privilege to visit and present at Access us [...]
Folks I'll be presenting at the NY Access SIG group at Microsoft's offices and we will be transmitting it over the web live! Here are the details: NYPC ACCESS SIG The NYC Access Special Interest group (SIG) helps Access users (from novice to professi [...]
I have a busy schedule in the next five days with presentations at CTAUG and SQL Saturday tomorrow and Saturday. For more details on those events click here. Tomorrow's presentation WILL BE broadcast online! Here are the details: CTAUG Meeting Info https://www2.gotomeeting.com/join/878628578 2. Use [...]
I will be in Connecticut next week participating in two events, first up: Connecticut Access Users Group - Thursday February 27th 6 PM I'll be presenting on "Building Access Dashboards with SQL Server", where we will discuss leveraging the power of SQL Server to harness many queries in one procedure [...]
This winter Microsoft provided all MVPs at the annual summit with a heavily discounted Microsoft Surface RT second generation. It promptly got sequestered by my wife, but I was intrigued enough to go out and purchase a Surface Pro 2 and give up my cherished IPad Mini in the process. I would use the [...]
This is part two of our two-part series on working with XML data with a SQL Server backend. Part one can be found here. In part one, we showed how much simpler and effective it was to manipulate XML data by doing it directly in the SQL Server layer as opposed to front-end or middle-layer code. The i [...]
This is part one of a two-part series that discusses working with XML data with an SQL Server backend. Part two is discussed here. I've personally found XML files to be something of a bugbear. They're going to require some kind of transformation to get it in a format that's useful for importing or e [...]
We use subforms in Access a lot around here. Sometimes, we may have upwards of 5 or 6 subforms per form. Adding that many can be a real drag on performance if you're not careful. This is part one of two posts on the topic. Ben will talk about disabling the loading of subforms on startup in our next [...]
Check out the SQL Stairway Series for some great training on SQL Server: http://www.sqlservercentral.com/stairway/ Enjoy! [...]
