EXPERTOS MICROSOFT ACCESS +1-844-328-2636 (+1-844 DATA MEN)

VBA

Visual Basic for Applications articles

Securing your ADO connections

2012-06-04T08:21:32+06:00junio 4th, 2012|

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 3: Destroy your linked tables on exit

2012-04-17T03:20:56+06:00abril 17th, 2012|

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

Part 2: Linking tables using a SQL Server table

2012-04-04T09:00:34+06:00abril 4th, 2012|

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

Why using unbound forms are a bad idea

2012-03-13T20:26:42+06:00marzo 13th, 2012|

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

Checking if files are locked using VBA

2012-03-06T13:11:57+06:00marzo 6th, 2012|

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

Zip and Unzip from Microsoft Access VBA

2012-02-06T09:24:44+06:00febrero 6th, 2012|

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

Create temp tables in Access from SQL Server tables

2012-01-10T08:00:30+06:00enero 10th, 2012|

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

How to work offline with SharePoint and Access 2010

2011-12-08T09:00:38+06:00diciembre 8th, 2011|

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

Stored Procedure Guide for Microsoft Access – Part 2

2011-08-15T11:06:17+06:00agosto 15th, 2011|

This is part 2 in a multi-part series on Stored Procedures with Access, Part 1 can be found here and Part 3 here. In the first part of my guide I talked about using Pass Through queries as a convenien [...]

Ir a Arriba