Beyond Excel: VBA and Database Manipulation:

December, 2009

1

December 31, 2009  9:08 AM

Creating the Fields Table

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

I hope you had a Merry Christmas and will have a great new year.  My heart goes out to the drivers and office workers of Arrow Trucking.  ABC News reported on...

December 19, 2009  2:23 PM

The Fields Table

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

[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

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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


December 3, 2009  9:23 PM

Looking for a Date?

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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


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: