Visual Basic for Applications articles

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

2014-11-11T03:01:19-06:00December 18th, 2013|

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

2021-06-10T10:01:32-05:00September 23rd, 2013|

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

2013-09-10T00:45:52-05:00September 10th, 2013|

Maximizing Code Reuse: Writing design-time automation

This is part two of two-parts on maximizing code reuse. Part one focused on assigning more than one event handlers to same object's event or sharing an event handler for several objects. We now turn to looking at how we can write design-time automation to help us save time in coding. If you enjoy lo [...]

2013-06-14T19:31:29-05:00June 14th, 2013|

Using built-in enumerations in your procedures

Sometimes, we have recurring tasks that we would like to simplify and when those tasks involve interactions with the Access object model, we certainly don't want to miss out on the built-in intellisense. Do you have any intellisense? At IT Impact we frequently open forms in our code with a where cla [...]

2012-10-10T20:21:10-05:00October 10th, 2012|

Securing your ADO connections

A while ago, I wrote about securing the ODBC connections which was published on Access team's blog. Also, Juan recently wrote about the alternate method of deleting/recreating linked tables in a four part article. But what about ADO connections? A typical approach for creating an ADO connection may [...]

2021-03-18T07:55:29-05:00June 4th, 2012|

Part 3: Destroy your linked tables on exit

Author note: This is part 3 of a series on DSN-less tables in Access. You can review part one here. Part 2 here. Part 4 here. In part three of this series I'm going to give you the code to delete all of your linked tables once the app closes. Deleting your links makes your app secure since both the [...]

2012-04-17T03:20:56-05:00April 17th, 2012|

Part 2: Linking tables using a SQL Server table

Author note: This is part 2 of a series on DSN-less tables in Access. You can review part one here. Part three here. Part four here. In last week's post I talked about using a single table in your SQL Server database to easily manage security, in today's post I'm going to take it one step further an [...]

2012-04-04T09:00:34-05:00April 4th, 2012|

Why using unbound forms are a bad idea

Many of you know that I'm a big fan of Access with SQL Server, and if you're a frequent blog reader you will also know it's not easy to optimize the relationship between them, it takes work but it's very rewarding when they're working great.  Some developers however go to the extreme and use unbound [...]

2012-03-13T20:26:42-05:00March 13th, 2012|

Checking if files are locked using VBA

In one of our client's applications, we built an email template that sometimes may attach files to be sent out. Our client wanted a way to preview the attachment before they actually send the email. This created a dilemma - if they can preview and potentially edit the files, we certainly don't want [...]

2021-12-07T21:21:06-06:00March 6th, 2012|

Zip and Unzip from Microsoft Access VBA

Click image to learn more about the book On occasions, we have a need to zip files as part of our workflow within Access VBA. One sore point with zipping is that there's really no simple way to zip or unzip files without depending on a third-party utilities. When you think about it, it is quite od [...]

2021-03-18T07:40:17-05:00February 6th, 2012|
Go to Top