Beyond Excel: VBA and Database Manipulation:

July, 2010

1

July 22, 2010  6:59 PM

Check Entry – Post_Click Event

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

There are two times when you want to check entries:
 
  1. When the user changes something and 
  2. When they want to post entries to the database (aka add, change or delete...

    July 20, 2010  8:48 PM

    Check Entry – Initializing 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


    July 13, 2010  10:12 AM

    Check Entry – The Controlling Routine

    Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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

      Bookmark and Share     0 Comments     RSS Feed     Email a friend


    July 6, 2010  9:44 PM

    Check Entry – Dealing with Field Level Exceptions

    Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

    We're just about finished dealing with the Check_For_Normal_Entry_Errors.  It uses one routine we haven't discussed, Cust_EditCust_Edit handles any field level validation that Check_For_Normal_Entry_Errors can't. ...


    July 1, 2010  9:32 PM

    Check Entry – Marking Cells as having passed or failed

    Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

    The last post talked about a generic validation routine.  That routine requires some functions that I will provide code for in this post. These functions convey to users and other routines which cells: can change; have changed, have passed validation; or have failed.  Users need 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: