VBA

Visual Basic for Applications articles

Evaluating when an expression in a query is evaluated

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 [...]

2022-04-19T04:00:03-05:00December 6th, 2021|

Avoid This Common Error When Executing Stored Procedure in MS Access

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 [...]

2021-06-30T14:54:20-05:00March 2nd, 2021|

Using OASIS-SVN and git for Access source code control

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 [...]

2022-01-07T09:04:42-06:00July 2nd, 2019|

How to Fix ‘System Resource Exceeded’ When Migrating to Windows 10

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' [...]

2021-06-11T06:14:18-05:00April 22nd, 2018|

Learn How to Spawn Forms in Memory (Yes, You Heard That Right)

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 [...]

2021-06-11T07:29:45-05:00April 10th, 2017|

Reporting More Granularly Than Usual – Microsoft Access

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 [...]

2022-07-26T03:33:47-05:00September 29th, 2015|

7 Ways To Do Sequential Numbering in Microsoft Access

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 [...]

2022-01-07T08:50:41-06:00July 28th, 2015|

Working With Console Tools – Microsoft Access

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 [...]

2021-06-11T07:45:07-05:00June 16th, 2015|

Working with XML Data Efficiently – Part Two

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 [...]

2022-04-18T16:31:06-05:00January 21st, 2014|

Working with XML Data Efficiently – Part One

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 [...]

2022-08-19T10:16:04-05:00January 14th, 2014|
Go to Top