VBA

Visual Basic for Applications articles

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

Maximizing Code Reuse: Writing design-time automation2013-06-14T19:31:29-05:00

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

Using built-in enumerations in your procedures2012-10-10T20:21:10-05:00

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

Securing your ADO connections2012-06-04T08:21:32-05:00

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

Part 3: Destroy your linked tables on exit2012-04-17T03:20:56-05:00

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

Part 2: Linking tables using a SQL Server table2012-04-04T09:00:34-05:00

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

Why using unbound forms are a bad idea2012-03-13T20:26:42-05:00

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

Checking if files are locked using VBA2012-03-06T13:11:57-05:00

Zip and Unzip from Microsoft Access VBA

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 odd considering that zipping is built-in to [...]

Zip and Unzip from Microsoft Access VBA2015-07-03T19:21:17-05:00

Create temp tables in Access from SQL Server tables

If you've ever asked Access to do a join between a local Access table and SQL Server table (which is called a heterogeneous join) you may have experienced first hand how slow it can be to process results. The situation could be vastly superior if you can afford to download the SQL table as a tempora [...]

Create temp tables in Access from SQL Server tables2015-07-03T20:01:28-05:00

New book for Access Web Database and SharePoint now available!

As Juan may have mentioned earlier, I had been working with two other MVPs, Tim Runcie and George Hepworth in producing the first of its kind, a book dedicated to using Access with SharePoint. The book can be bought online at the Advisicon store. If you're wanting to learn more about the capabilitie [...]

New book for Access Web Database and SharePoint now available!2016-05-12T22:41:00-05:00

How to work offline with SharePoint and Access 2010

One advantage a SharePoint list has over any ODBC data source is that Access can disconnect and re-connect and synchronize the local edits back to the server fairly seamlessly. It also provides a friendly conflict resolution management, all out of the box. This is available whether you're using a tr [...]

How to work offline with SharePoint and Access 20102016-03-08T01:13:58-05:00
FREE CONSULT
close slider