We talked about concatenating multiple records into a single string using FOR XML PATH and we also talked about EXISTS clause. Here's a practical example that incorporates both. In one of our projects, we have an archive database that contains historical data of select tables from the production dat [...]
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 second part of 2-part series on SQL clauses. Juan covered the IN() in the first part. We now turn to a close sibling, EXISTS clause. As Juan demonstrated, IN() can be useful for some situations where we want to match a subset of another table without necessarily changing the output due to jo [...]
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 [...]
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 [...]
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. * [...]