Home > IT Blogs > Beyond Excel: VBA and Database Manipulation/

Beyond Excel: VBA and Database Manipulation:

ms query

12345678
August 21, 2010  7:47 PM

Controlling the Cursor



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

Updating databases demands discipline.  Excel is about freedom.  It's what your users love about it.  Even so, updating databases demands discipline and striking the right balance between freedom and discipline is key to making Excel a great tool for users and DBAs. We've just invested most...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

August 9, 2010  8:13 PM

Check Entry – Worksheet_Change – Code



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

Last post we discussed the theory behind the WorkSheet_Change event code below.  This code must be in the WorkSheet class as it only responds to events for the worksheet that contains it.  Here is the code: 

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

August 6, 2010  5:21 PM

Check Entry – Worksheet_Change – Theory



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

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 data). 
  Bookmark and Share     0 Comments     RSS Feed     Email a friend

July 22, 2010  6:59 PM

Check Entry – Post_Click Event



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

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...

      Bookmark and Share     0 Comments     RSS Feed     Email a friend

    July 20, 2010  8:48 PM

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

    July 13, 2010  10:12 AM

    Check Entry – The Controlling Routine



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

    [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



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

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

      Bookmark and Share     0 Comments     RSS Feed     Email a friend

    July 1, 2010  9:32 PM

    Check Entry – Marking Cells as having passed or failed



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

    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...

      Bookmark and Share     0 Comments     RSS Feed     Email a friend

    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...

      Bookmark and Share     0 Comments     RSS Feed     Email a friend

    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

      Bookmark and Share     0 Comments     RSS Feed     Email a friend

12345678