Beyond Excel: VBA and Database Manipulation:

June, 2010

1

June 30, 2010  9:30 PM

Check Entry – Common Validations

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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

  Bookmark and Share     0 Comments     RSS Feed     Email a friend


June 23, 2010  5:43 PM

Check Entry – Form Select – Visual Elements

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

[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: