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

Beyond Excel: VBA and Database Manipulation:

database

12345678
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"]
  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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

May 31, 2010  4:04 PM

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

May 26, 2010  10:33 PM

Validating Data Entries



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

Practically no one uses Excel to update databases directly.  I think the reason is because we think of Excel as a tool that end users can do whatever they want to with and updating databases requires discipline.  Just using Excel to shotgun records into a database can be...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

May 24, 2010  5:11 PM

Building a Library of Routines for Updating – #7



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

[caption id="attachment_687" align="alignright" width="91" caption="You are here (Click to enlarge)"]
  Bookmark and Share     0 Comments     RSS Feed     Email a friend

May 18, 2010  4:11 PM

Building a Library of Routines for Updating – #6



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

[caption id="attachment_673" align="alignright" width="91" caption="Your are here (Click to enlarge)"]

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

May 12, 2010  7:47 PM

Building a Library of Routines for Updating – #5



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

[caption id="attachment_666" align="alignright" width="91" caption="You are here (click to enlarge)"]

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

12345678