fbpx

Visual Basic for Applications articles

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

Avoid This Common Error When Executing Stored Procedure in MS Access2021-06-30T14:54:20-05:00

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

Using OASIS-SVN and git for Access source code control2021-06-10T10:53:03-05:00

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

How to Fix ‘System Resource Exceeded’ When Migrating to Windows 102021-06-11T06:14:18-05:00

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

Learn How to Spawn Forms in Memory (Yes, You Heard That Right)2021-06-11T07:29:45-05:00

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

Reporting More Granularly Than Usual – Microsoft Access2021-06-11T07:39:55-05:00

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

7 Ways To Do Sequential Numbering in Microsoft Access2021-06-11T07:44:23-05:00

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

Working With Console Tools – Microsoft Access2021-06-11T07:45:07-05:00

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

Working with XML Data Efficiently – Part Two2016-04-02T00:00:23-05:00

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

Working with XML Data Efficiently – Part One2016-04-02T00:25:45-05:00

Delay Loading Subforms in Access Part 1

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

Delay Loading Subforms in Access Part 12021-03-03T15:49:36-06:00

Avoid the Groundhog Day Effect: Delay Loading Subforms in Access Part 2

We use subforms in Access a lot around here. Sometimes, we may have upwards of 5 or 6 subforms per form. Adding that many can be a real drag on performance if you're not careful. This is part one of two posts on the topic. Ben will talk about disabling the loading of subforms on startup in our next [...]

Avoid the Groundhog Day Effect: Delay Loading Subforms in Access Part 22014-11-11T03:01:19-06:00
Go to Top