DaveCorun.com Dave Corun's Free Development Resources and Music

 

Visual Basic 6

A long time ago, I used to teach VB6 courses. These links are still here for students that may want them.

Code for Extra Labs:

Using the Common Dialog box from code
General Error Message Code
Convert strings to "Proper" names (like companies and people)
Convert currency to 2 digits w/o using the Round() function
Pad strings w/ spaces so you can run WHERE clauses on char(50) fields
Remove all underscores from a string
Calculate the Weekdays from a date range
Write out a file w/ line numbers

MSDN Links:


Automating Word Using the Word Object Model
MSDN VB6 Documentation (The start of the documentation)
ADO and SQL Server Developer's Guide Sample
Developing SQL-DMO Applications Using Visual Basic (SQL-DMO gives the same functionality as Enterprise Manager to your apps)
Cross-Database Ownership Chaining Behavior Changes in SQL Server 2000 Service Pack 3

Other Links:


Common VB Routines
Read And Write From INI File Demo
.INI File Reader and Writer Class
Replace Special Vowels (…, ‚, Š, ...) with "Regular" (7-bit ASCII) Values
InstrRev Function With Reverse Count Option
FreeVBCode
VBCode: String Manipulation
VBA - The Word Working Partner
Create PDFs from all Word Docs in a folder
Common Word VBA Code
Experts-Exchange (Good resource for getting questions answered)
Infragistics (Brilliant ActiveX and .NET controls. 20 day free trial)
Introduction to the Win32API (Page 2+ has examples and walkthroughs)

Recommended Reading:


MSPress: Code Complete 2nd Ed.

Excellent intro into project management, writing readable code, and much more. Rapid Development at it's best.


MSPress: Programming Visual Basic 6

Great book in terms of overall content. It goes into detail w/ COM objects, Databases, etc.


Pure Visual Basic

Small code snippets of useful functions. Inexpensive book.


Wrox: Professional Visual Basic 6 Databases

Much more on the datagrids, flexgrids, etc. in terms of database development w/ SQL Server and Oracle. A good approach to n-tier application development.

Technology

Below are some useful links, including free training material and curriculums I've developed.

Music