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 [...]
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! [...]
As I'm writing this I'm seated next to Ben on the Microsoft campus during our yearly pilgrimage to Redmond. (I call it getting re-charged at the mother ship). What is the future? We are hearing about it this week. One of the advantages of being an Access MVP is the ability to meet and share with the [...]
UPDATE: Had a great turnout at the event, thanks for all who came out! Update: Here is a trailer for the presentation: Starting your own consulting practice - Trailer from Juan Soto on Vimeo. [...]
This is a part one of two-part on how you can make your queries much more powerful. In first part, we look at whether we're in or not. Part two can be found here. The IN clause is a great tool to have in your arsenal, it can allow your forms to be editable or filter forms using . What is the IN clau [...]
Access developers come in a wide range of skill sets, but what set apart those who are good at Access development? I've put together a rather subjective list of 7 habits for your review, let me know what you think in the comments! Habit 1: Using error handlers in all procedures Errors generated by A [...]
Here's a great way to learn more about SQL Server, Azure, Windows Server and other Microsoft technologies with this collection of Free ebooks: UPDATE: Here's a more recent list of free books from Microsoft: http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/30/another-large-collection-of-free-micro [...]
It's that time of the year again folks, where the Access team is debating what to include, fix or remove from the next version of Microsoft Access, and if past history is any notion of what to expect, don't expect anything to change on the client side: no new IDE tools, no new coding tricks, nada. * [...]
What does "moving Access application to the cloud" mean? It means you are moving your data to a hosted SQL Server database on the web. You no longer have the data locally and you are still running the Access frontend locally. You may or may not have some tables local, but for the most part, all of t [...]
