Code Categories in Total Visual SourceBook

Here are the highlights of the categories available in Total Visual SourceBook:

Microsoft Access

Working within Access or an external instance of Access

• Automation for running another instance of Access
• Access Environment
  • Startup routines such as relinking tables, setting error trapping, opening backend databases, etc.
  • Access application level routines for the database window, user names, profiles, closing Access
  • Windows API calls to show, hide and adjust the transparency of windows and controls
  • Information on the current database name, version, Jet version, ADP, runtime, etc.
  • Manage the printer settings and orientation on Access forms and reports
  • Manage the Access Ribbons to show, hide, minimize, maximize, and toggle it
  • Manage the Access status bar and progress meter
  • Working Microsoft Visual SourceSafe from Access
• Access Forms
• General routines for Microsoft Access forms (Jet and ADP)
• General routines for Microsoft Access subforms (Jet and ADP).
• Launching the Microsoft Access spell checker on an Access form and its subforms
•  Routines for Microsoft Access forms in ADPs
• Routines for Microsoft Access forms using Jet (for MDB/ACCDB, not ADP)
• Access Macros: Retrieving Microsoft Access macro names and running them
• Access Modules
  • Compiling, opening, retrieving, replacing, saving, and deleting Microsoft Access modules
• Access Object
  • Routines for running an Access Data Projects (ADPs)
  • Manage open Access objects, inventory, active objects, and minimizing, restoring and closing them
  • Delete, duplicate, rename, and export Access objects in Jet and ADP databases
  • Get, set, and create Access properties for the Current Project (Jet or ADP database)
  • Retrieve Access object information from the MSysObjects table
• Access Reports
• Routines for reports to print, preview, report view, output to PDF, and inventory reports and their controls

Microsoft Outlook

Find, edit, and delete Outlook objects:

• Address Book and the Exchange Server Global Address List
• Calendar Appointments and Meeting Requests
• Contacts
• Folders (opening, copying, emptying, moving, deleting, etc.)
• Sending email
• Notes
• Tasks and Task Requests

General Code that Works with Office/VBA and VB6

• Abstract Data Types (bit array, history list, queues, stacks)
• Application Techniques (dictionary, message box, shutting down Windows, error handling)
• Clipboard Operations
• Data Integrity with 16 and 32 bit Cyclic Redundancy Check (CRC)
• Data Type and Unit Conversions
• Date and Time (date/time math, holiday/business date math, high resolution timer)
• Encryption and Compression using passwords, Huffman compression, Lempel-Ziv compression (CLZ), Run Length Encoding (RLE), and UU encoding and decoding
• File and Disk Operations (disk drives, paths, copying/moving/deleting files, folders, and subfolders)
• Help Calls for using HTML and CHM files
• INI File Support
• Library Reference Information
• Math (general, area/volume, statistics, trigonometry)
• Multimedia (running AVI and WAV files, managing CD/DVD drives, telephone/modem TAPI)
• Registry Management
• Searching and Sorting
• String Manipulation
• System Information (computer, keyboard, memory, mouse, printer, system folders)
• Windows Common Dialog (color, file, font, page setup, printer, folder browsing)
• Zip Code lookup

Internet and Web

• File Transfer Protocol (FTP)
•  HTTP connections, data, and sessions
• Mapping and Directions using Google Maps, MapQuest, and Bing
• Twitter searching and posting

Databases

• Access/Jet database, tables, queries, and fields using DAO and ADODB
• SQL Server using ODBC and OLE DB Drivers, and Data Link Dialog
• SharePoint

Other Microsoft Office

• Excel
• PowerPoint
• Word
• Command Bars

Visual Basic 6

• Application Techniques (command arguments, error handling, hourglass, shell execute)
• VB6 Controls (combo box, date time picker, list box, text box, toolbar)
• Forms (captionless window mover, form position, references, and ordering)
• Graphics (GDI shapes, screen resolution, screen capture, fractals, colors, effects, simulated controls)
• Menus (VB6 menus and most recently used lists)
• Printer management and direct drawing

ActiveX Controls

• Windows Common Controls (List view and Tree view)
• Windows Media Player

Additional Categories

• Active Server Pages
• XML

---

Additional Resources

• Complete list of all the VBA/VB6 modules and classes with their descriptions
• Sample Code (Example of Date/Time Calculations)

Main Total Visual SourceBook Page