Beyond Excel: VBA and Database Manipulation:

excel


September 14, 2010  8:02 PM

Controlling the Cursor: Position_Curosr_In_Data



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

The last few posts covered Worksheet_Change and Worksheet_SelectionChange events.  Both rely on a function called Position_Cursor_In_DataPosition_Cursor_In_Data's Job is...

September 8, 2010  5:49 PM

Back to Controlling the Cursor



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

This post returns to controlling the cursor in update spreadsheets. As the user positions the cursor on the spreadsheet, we want to have it jump over 'locked' cells to the next 'unlocked' cell.  The words 'locked' and 'unlocked' are quoted because we aren't exactly using Excel's notion of...


August 31, 2010  10:16 AM

Strategies for Speeding Spreadsheets



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

By guest contributor: Yoav Ezer

NOTE: This post provides an example spreadsheet: accelerating-excel.xlsm.  Due to concern for your system's security, macro enabled...


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


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


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


    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_EditCust_Edit handles any field level validation that Check_For_Normal_Entry_Errors can't. ...


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: