VBA

Visual Basic for Applications articles

Getting “System Resource Exceeded” messages? Here’s one way to fix it

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've traced the issue to apps that use a lot of subforms in a tab con [...]

Getting “System Resource Exceeded” messages? Here’s one way to fix it2018-04-22T21:20:43-05:00

Tuesday April 11th: 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 design? One way of doing this would be to have multiple copies [...]

Tuesday April 11th: Learn how to spawn forms in memory, yes, you heard that right2017-04-10T13:46:05-05:00

Reporting more granularly than usual

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 figures to the month each. Ditto with year, or even going from [...]

Reporting more granularly than usual2016-08-25T22:17:07-05:00

Ways To Do Sequential Numbering in 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 other words, if someone creates a record then later delet [...]

Ways To Do Sequential Numbering in Access2015-07-30T20:51:20-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 refired due to operations performed during the load. We will talk about how we can delay loading the subforms. By putting o [...]

Delay Loading Subforms in Access Part 12014-11-11T03:01:27-05: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-05:00

Are you IN or are you out? (Not IN)

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

Are you IN or are you out? (Not IN)2018-02-19T18:35:12-05:00

Automation and Web

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

Automation and Web2013-09-10T00:45:52-05:00
Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.