Sometime we take over a project where the original developer used SQL Triggers on the tables and unfortunately, we tend to find that more often, the triggers are not written in most effective manner. I'd like to highlight few common mistakes I see made with using the triggers: Assuming only one row [...]
Whenever the subject of new web apps introduced with 2013 or web databases introduced with 2010, one common lamentation bought up by people is that they both lack VBA. It is certainly an understandable lamentation; almost all serious Access developers have used VBA and it's VBA that makes it possibl [...]
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 [...]
Sometime we want to get data in a list. A good example is getting a list of orders that's coming up for delivery and has other orders that are past due. We would like to know what those upcoming orders are so we can ensure that the past due accounts are settled prior to actually delivering the order [...]
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 [...]
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 [...]
A while ago, I wrote about securing the ODBC connections which was published on Access team's blog. Also, Juan recently wrote about the alternate method of deleting/recreating linked tables in a four part article. But what about ADO connections? A typical approach for creating an ADO connection may [...]
In one of our client's applications, we built an email template that sometimes may attach files to be sent out. Our client wanted a way to preview the attachment before they actually send the email. This created a dilemma - if they can preview and potentially edit the files, we certainly don't want [...]
Click image to learn more about the book On occasions, we have a need to zip files as part of our workflow within Access VBA. One sore point with zipping is that there's really no simple way to zip or unzip files without depending on a third-party utilities. When you think about it, it is quite od [...]
A poster asked me a wonderful question: "How do I get Access [linked to SharePoint] to remember my login credentials so I don't have to login every time?" The answer to the question isn't simple as it should be and hence, I felt an article on the subject would be helpful for those who want to automa [...]