I LOVE integrating Access with Outlook, it's really easy to create a system that allows our clients to export reports as PDF attachments in an email. Objective: Email pdf invoice to a recipient using Outlook. Needed Option table to hold templates for the Subject and body of email. Make sure client t [...]
As I write this I'm on my way with Ben to the annual MVP conference at Microsoft's campus in Seattle. The annual summit last four days and all expenses but your flight and transportation on the first and last day are covered. (If you don't share a room with another MVP you do have to pay for half of [...]
Office 2013 has gone on sale and already I've seen posts online from people asking about the SQL Server Upsizing wizard not found in the tool. It's no longer available The wizard was a causality in Access 2013 and frankly I say good riddance. I for one thought it was barely usable when it worked, si [...]
10 Question you Should Ask your Access Developer Companies are constantly looking for quality Microsoft Access developers, here are some questions to help you evaluate one: Do you provide quotes or estimates? If the MS Access consultant does not provide estimates, it's a major red flag. Quotes an [...]
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 [...]
