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 [...]
Over the last year, I've been working on a book with Access experts and MVPs Teresa Hennig, George Hepworth and Doug Yudovich, focused on practical examples and techniques for building powerful Access applications. The book covers both new web apps and new solutions to client solutions. Here are few [...]
This is part two of two-parts on maximizing code reuse. Part one focused on assigning more than one event handlers to same object's event or sharing an event handler for several objects. We now turn to looking at how we can write design-time automation to help us save time in coding. If you enjoy lo [...]
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 [...]