Beyond Excel: VBA and Database Manipulation:

database


December 19, 2009  2:23 PM

The Fields Table



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

[caption id="attachment_415" align="alignright" width="128" caption="Fields Table"]
Bookmark and Share     0 Comments     RSS Feed     Email a friend

December 15, 2009  6:13 PM

75% Done



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

As far as writing reports in Excel is concerned, using just what we've discussed up til now get's us about 75% of where I want to take us.  The next 25% is more tedious to work through, but the advantages are worth it. Quick Change SQL The first...


December 10, 2009  6:03 PM

It’s Time to Play



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

In the last post, we integrated frmPrompt into Macro1(), but we didn't take full advantage of what frmPrompt offers.  We limited values to just one for each parameter.  Today we are going to add the ability to filter our database using...


December 8, 2009  10:58 PM

Putting it all Together



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

In the last post we finalized frmPromptfrmPrompt provides a feature rich and professional looking method for getting parameters for our customer's reports.  Today, we're going to ignore some of those rich features in order to ease us into integrating...


December 4, 2009  10:20 PM

Asking for It



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

[caption id="attachment_372" align="alignright" width="356"...


December 3, 2009  9:23 PM

Looking for a Date?



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

Last post I introduced frmSelect_Multiple that helps users find:

  • Codes/Types by Code/Type or Description
  • Cities by Zipcode or Name
  • Accounts by Number or Description
  • Employees, Customers, or Vendors by ID/Number or...


November 30, 2009  5:02 PM

Searching for Codes



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

[caption id="attachment_307" align="alignright" width="338" caption="frmPrompt Dates and IDs"]

Bookmark and Share     1 Comment     RSS Feed     Email a friend


November 23, 2009  10:08 PM

Creating a Date Prompt Form



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

We're going to replace XL's limited InputBox function with a user form.  If you've never created a user form, don't worry.  YouTube has several decent tutorials for you.  Check these out (at least the first one anyway), then come back here. YouTube videos on how to create forms in VBA


November 18, 2009  9:13 PM

Good Form



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

If we stopped with only what has been posted in this blog so far, we would have a powerful tool set to create meaningful charts and drill down pivot tables from data residing in just about any database.  It only takes a couple of minutes to replace the SQL statement in Macro1() and to set...


November 10, 2009  5:58 PM

Say Goodbye to QueryTables



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

We started with the QueryTable object in order to ease into this subject.  It's time to say farewell to QueryTable and fully embrace ADO.  I'm using ADO, not because it's the best, but because it is compatible with everything my customers have and (I'm guessing) with 98% of all current XL...


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: