Beyond Excel: VBA and Database Manipulation:

tutorial


June 25, 2010  3:54 PM

Check Entry – Form Select – Code



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

Today we add the code to frmSelect (See: frmSelect Visual Elements for what this form looks like, or

June 23, 2010  5:43 PM

Check Entry – Form Select – Visual Elements



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

Today we will see how frmSelect is constructed.  This is the basic form with the visual elements labeled.
[caption id="attachment_746" align="alignnone" width="538" caption="frmSelect with Labels"]


June 19, 2010  11:25 AM

Check Entry – Form Select – Theory and Demo



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

frmSelect facilitates finding and selecting a record in massive lists by allowing the user to search by code/id/number or description/name (See video demo at bottom of post).  Below is a screen shot showing someone searching a poorly designed customer master file.  It looks and...


June 17, 2010  4:37 PM

Check Entry – DB_Lookup



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

DB_Lookup validates a code or ID against a database table.   Where as XL_Lookup is meant for tiny code lists, such as States or Provinces that fit nicely in an Excel range, DB_Lookup is meant for massive lists such as employees, customers, or...


June 12, 2010  11:12 PM

Check Entry – XL_Lookup & Dynamic Arguments



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

Creating that last post ate at me.  The old Table_Lookup functions just seemed so klunky that I was ashamed to have posted them.  So I rolled up my sleeves and did what I should have done long ago.  I created a function that:

  • Gets a result from an Excel range like...


June 2, 2010  9:27 PM

Check Entry – Table Lookup



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

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

Bookmark and Share     0 Comments     RSS Feed     Email a friend


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


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: