Beyond Excel: VBA and Database Manipulation:

June, 2010

1

June 30, 2010  9:30 PM

Check Entry – Common Validations



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

Today's post is about a routine I call Check_For_Normal_Entry_Errors.  In my opinion, the toughest part of coding is checking for entry errors because just knowing what good values look like isn't good enough.  You also need to anticipate anything a user might do even though it...

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


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: