December 15, 2009 6:13 PM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaAs 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
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaIn 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
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaIn the last post we finalized frmPrompt. frmPrompt 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
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
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaLast 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...
0 Comments
RSS Feed
Email a friend
