Visual Basic for Applications articles
I've always found Itzik Ben-Gan's excellent chart on the logical SQL processing immensely helpful in reasoning about the querying performance. Even though the chart was made for SQL Server, it still is applicable to any database engine that follow SQL Standard, which also includes Access database en [...]
Avoid This Common Error When Executing Stored Procedure in MS Access We love running stored procedures from our VBA code, but there is one issue you need to watch out for: Executing a procedure that affects data already loaded on your form. If you're not careful you will get the following [...]
NOTE: I will be talking about this topic in depth in the upcoming Access and SQL Server monthly webinar on July 9th at 6:30 PM CDT. Register so that you can view the process live and ask questions! As we work with several applications and sometime in a team, source code control is pretty impo [...]
How to Fix 'System Resource Exceeded' When Migrating to Windows 10 System Resource Exceeded Error Message Lately we've been seeing a barrage of clients getting "System Resource Exceeded" when migrating to Windows 10, even though the system worked fine in prior versions of Windows. In some cases we' [...]
Learn How to Spawn Forms in Memory (Yes, You Heard That Right) Hi Everyone! This Tuesday I’m going to demo an amazing concept: How to spawn multiple copies of the same form in memory. Have you ever wanted to display multiple orders or invoices in your databases in separate forms using the same form [...]
Reporting More Granularly Than Usual - Microsoft Access Typically, when we do reporting, we usually do it at a higher granularity. For example, clients commonly wants a monthly report of sales. The database would store the individual sales as a single record, so it's no problem summing up the figure [...]
7 Ways To Do Sequential Numbering in Microsoft Access Occasionally we come across project requirements that include the ability to do sequential numbering in Access on a set of data. We cannot just use the auto-number data type because there is no promise of sequentiality but only uniqueness. In oth [...]
Working With Console Tools - Microsoft Access We recently had a project that required us to interact with console tools. People might have different terms for those type of tools so when I speak of console tools, I'm referring to a program or script that opens a command prompt and output stuff to th [...]
This is part two of our two-part series on working with XML data with a SQL Server backend. Part one can be found here. In part one, we showed how much simpler and effective it was to manipulate XML data by doing it directly in the SQL Server layer as opposed to front-end or middle-layer code. The i [...]
This is part one of a two-part series that discusses working with XML data with an SQL Server backend. Part two is discussed here. I've personally found XML files to be something of a bugbear. They're going to require some kind of transformation to get it in a format that's useful for importing or e [...]
In part one, Juan talked about the sequence of events fired when loading a form with a number of subforms in Access and how one can reduce the cascading effects of events being re-fired due to operations performed during the load. We will talk about how we can delay loading the subforms. By putting [...]
