Microsoft Access and Word VBA Document Assembly System Demo

Summary: This demonstrates a methodology and some of the associated technologies I’ve used to create complex and flexible contract generators, proposal generators, and other document assembly systems. Technologies: Microsoft Access (SQL Server*) Microsoft Word – Word Templates – Word Global Template w/AutoText Entries * SQL Server: For simplicity, this demonstration uses Microsoft Access as the […]

Continue reading
Use SQL Server as the back end database for your Microsoft Access projects

Using SQL Server Express for Your Microsoft Access Projects

Summary: Some of the reasons why you should use SQL Server (or SQL Server Express) to store data for your Microsoft Access projects. Plus, code to simplify connecting to SQL Server and attaching tables without manual linking. The Access DB is miserable but awesome! Can we be honest. It’s slow, clumsy to move around, inherently […]

Continue reading

Are Twitter Auto-follow Messages a Good Idea?

No! Okay.. perhaps that is simplistic but I think we can make the case. Below I have a link to my CIO Magazine blog post on the subject. I’ll offer a little context and explanation first. Let’s start with a question… What is your goal with social media? For most people, the goal is to […]

Continue reading