Join me this Wednesday, January 4th at 6:00 PM EASTERN, 5:00 PM CENTRAL, at the monthly CTAUG, (Connecticut Access User Group), meeting. We will be discussing how to optimize Access with SQL Server: What is the ONE field all of your tables in SQL Server should have? (Hint: It's not just the a prim [...]
Queries, reports and emails, all standard stuff for Access, but sometimes you need more options, something innovative that will allow you to do more then you ever thought Access can do, thats where IF THIS THEN THAT comes into play, (www.ifttt.com). ifttt.com allows you to extend Access' capabiliti [...]
I was late to the ADP party, having discovered their power for a project I needed to do on a multi-franchise national database. I had started using a regular Access file but quickly grew disenfranchised with the record locks and other issues that propped up. The ADP proved great in both reliability [...]
This is first part of two-part series discussing about maximizing code reuse. Part two is here. One coding technique that I feel is frequently overlooked in Access application is the fact that we can assign multiple event handlers to the same object event and/or share the same event handler among di [...]
Sometimes, we have recurring tasks that we would like to simplify and when those tasks involve interactions with the Access object model, we certainly don't want to miss out on the built-in intellisense. Do you have any intellisense? At IT Impact we frequently open forms in our code with a where cla [...]
I've been seeing a lot of talk lately about linked SQL Server tables...ever since I've started this blog I've address it several times, but there have been some changes since my last diatribe that warrant revisiting the issue again. Linked SQL Server Tables - Should you use them? YES! Linked tables [...]
Recently we were invited to a product interaction session with the Microsoft Access team, it was a wonderful opportunity to discuss what we would love to see in the next version of Access and I'd like to share my responses with you and get your feedback. If you had $100 to spend on new features, how [...]
Today we debut a new site design! Let us know in the comments if you like it. Thanks! Juan (Editor in Chief) [...]
THIS EVENT HAS ALREADY PASSED. STAY TUNED FOR MORE EVENTS IN THE FUTURE Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to won [...]
Getting up and running on Office 365 Preview was not easy for me, there were a few gotchas through out the process and it became a frustrating experience. Lucky for you I've created a video that will walk you through the whole process! Why bother? Access 2013 is a big game changer to the prior versi [...]
My Access Kung-Fu is strong, join me on September 11th, 2012 as I demo advanced topics Live from Microsoft's campus in Redmond and the Seattle Access Users group: Access Kung-Fu! Join me next Tuesday, September 11th, 2012 for our second world wide session. Topics to be discussed: Master the use of T [...]