Beyond Excel: VBA and Database Manipulation:

May, 2010

1

May 31, 2010  4:04 PM

Check Entry – Initialize Globals

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

[caption id="attachment_709" align="alignright" width="103" caption="You are here (Click to enlarge)"]

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

May 26, 2010  10:33 PM

Validating Data Entries

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

Practically no one uses Excel to update databases directly.  I think the reason is because we think of Excel as a tool that end users can do whatever they want to with and updating databases requires discipline.  Just using Excel to shotgun records into a database can be...


May 24, 2010  5:11 PM

Building a Library of Routines for Updating – #7

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

[caption id="attachment_687" align="alignright" width="91" caption="You are here (Click to enlarge)"]


May 18, 2010  4:11 PM

Building a Library of Routines for Updating – #6

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

[caption id="attachment_673" align="alignright" width="91" caption="Your are here (Click to enlarge)"]

  Bookmark and Share     0 Comments     RSS Feed     Email a friend


May 12, 2010  7:47 PM

Building a Library of Routines for Updating – #5

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

[caption id="attachment_666" align="alignright" width="91" caption="You are here (click to enlarge)"]

  Bookmark and Share     0 Comments     RSS Feed     Email a friend


May 6, 2010  8:34 PM

Building a Library of Routines for Updating – #4

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

We are just about finished with adding support routines for updating, inserting, and deleting records in a database.  As a reminder, these routines should never need modification.  The first routine should go in modSQL.  It is used to create a connection object that can be reused.  This...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: