Beyond Excel: VBA and Database Manipulation:

May, 2010

1

May 31, 2010  4:04 PM

Check Entry – Initialize Globals



Posted by: Craig Hatmaker
database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

[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



Posted by: Craig Hatmaker
database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

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



Posted by: Craig Hatmaker
database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

[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



Posted by: Craig Hatmaker
database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

[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



Posted by: Craig Hatmaker
database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

[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



Posted by: Craig Hatmaker
database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

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