This version supports Microsoft Access/Office 2016, 2013, 2010, and 2007
The most popular professional source code library for Microsoft Access/Office and VB6 is now available for Microsoft Access/Office 2016, 2013, 2010 and 2007; and Visual Basic 6. Total Visual SourceBook builds on its heritage of helping VBA/VB6 developers create better solutions using it's extensive collection of powerful, consistently written, documented, and tested source code.
As before, you can insert the source code directly into your projects and use them immediately. Treat them as a black box and just call the routines, examine each line of code to learn from our techniques, or modify the code to your specific needs. The code is completely open for you to use, and you can include them in your projects royalty-free!
We've added many enhancements based on our experiences and the recommendations of our customers. Thank you very much! We hope you like the results:
Microsoft offers 32 and 64-bit versions of Office and Access 2016, 2013 and 2010. The source code in Total Visual SourceBook 2013 is compatible with both 32 and 64-bit versions of Office/Access. We've taken care of the complexity of different Windows API calls, data types, type structures and other differences between the two platforms to ensure the features you implement are compatible.
That means you can insert the code into your projects and rest assured it will work regardless of whether your users are running the 32 or 64-bit version of Office/Access today or tomorrow.
Total Visual SourceBook has always allowed you to save your own code and share it with others by storing it in a Microsoft Access database. You can now upsize that database to SQL Server and share your code from there. You can use your own SQL Server host or a cloud provider like SQL Azure. If you and your fellow developers can connect to your SQL Server database, you can easily search, use, and update your shared code.
In total, there are 227 modules and classes (up from 194) and 125,000+ lines of code (up from 100,000), with 25,000+ lines of example code (up from 20,000), plus extensive notes so you can maximize your understanding of the content. Some legacy modules were deleted, and these 36 added:
|Access Databases||Database||JetEngine||Manage Access database characteristics such as passwords, encryption, compact, workspaces and tuning through DAO in VBA and VB6.|
|Fields||HyperlinkFields||Working with hyperlink fields in Access ACCDB databases using DAO with VBA or VB6.|
|Table and Records||CreateTableDAO (class)||Create a table in a Microsoft Access Jet database using VBA with DAO.|
|JetLinkedTables||From Access, work with Microsoft Jet Linked tables in the current database to link to external data sources using DAO in VBA.|
|RecordsetADO||Use the ADODB database object to create recordsets from data objects and SQL strings in Microsoft Access for the current project (ACCDB, MDB, or ADP) using Access VBA.|
|RecordsetDAO||Use DAO to create recordsets for Microsoft Access database objects from VBA or VB6.|
|TableModifyDAO||Modify Microsoft Access tables to add, delete and rename fields, set starting number of autonumber fields, set table property for performance, and set field properties using VBA and VB6.|
|Error Handling||VBA||ErrorHandlerAccess||Global error handler for Microsoft Access VBA. Added to every procedure, these routines will trap, document, email, and gracefully exit your application when unexpected errors occur. A global error handler will help you improve the quality of your application by providing developers with the information necessary to diagnose problems and minimize the need for users to report crashes.|
|Excel||Automation||ExcelExport||Basic data routines to export data from Microsoft Access to an Excel spreadsheet from a table, query, or SQL statement using DAO and ADO from VBA or VB6.|
|General VBA/VB6||Data Type and Unit Conversion||AsciiBinaryHex||Convert ASCII characters, numbers, and hexadecimal values, encode URL characters and generate HTML colors using VBA and VB6.|
|EBCDIC||Convert between ASCII characters and Extended Binary Coded Decimal Interchange Code (EBCDIC) using VBA and VB6. EBCDIC is an 8-bit character encoding used mainly on IBM mainframe and IBM midrange computer operating systems.|
|Date and Time||
|Business day math (taking holidays into account) with holidays stored in a Microsoft Access/Jet table using DAO for VBA and VB6 (does not support ADPs).|
|AgeBirthdays||Calculations for age, birthdays, anniversaries, and days since the last one or until the next one using VBA and VB6.|
|Waiting||Routines for wait for a period of time or until a particular time using VBA and VB6.
Uses the Windows API Sleep command to avoid the DoEvents command in a loop that eats up all your CPUs. Includes support for 32 and 64 bit API calls.
|Encryption and Compression||Encryption||Encrypt and decrypt a Unicode or ASCII string using XOR password encryption in VBA and VB6.
Similar to class modEncryption but simplified for function calls and no progress events.
|ZipFile||Create compressed zip files, list the files in a zip file, and extract/unzip all files or individual files from zip files with file overwrite options using VB6 and VBA in 32 and 64-bit.|
|Searching and Sorting||SortCollection||Sort a Collection using a BubbleSort algorithm in ascending or descending order in VBA and VB6.|
|String Handling||EmailValidation||Verify an email address or set of email addresses conforms to standards in VBA and VB6.|
|PhoneButtonLetters||Convert between phone numbers and their corresponding button letters using VBA and VB6.|
|StringNumbers||Convert currency numbers to full word text for check writing and Roman numerals with VBA and VB6.|
|Geospatial||Addresses and Distances||Distance||Measure the distance between two latitude and longitude coordinates using the spherical law of cosines or Haversine formula in VBA or VB6.
Due to the curvature of the earth, the distance between two points is not a straight line.
|GoogleMapsAPI||Use the Google Maps web service API to translate street address to GPS latitude and longitude coordinates, and other address components using VBA or VB6.|
|Create a Google Earth KML file by adding location placemarks, advanced custom HTML descriptions, icons, and colored line segments, then launch Google Earth with it using VBA or VB6.
Requires Google Earth to be installed and the default program when a KML file is opened.
|GoogleEarthTour (class)||Create a Google Earth KML file to generate an animated tour by adding locations and wait times, then launch Google Earth with it using VBA or VB6.|
|Mapping||MappingBing||Use Bing Maps to show addresses, directions (driving, transit, walking), and display options in VBA or VB6|
|MappingGoogle||Use Google Maps to show addresses, directions (driving, transit, walking, biking), and display options in VBA and VB6.|
Mapquest to show addresses
and driving directions in VBA and VB6
|Internet/Web||Internet/Web||Bitly (class)||Bit.ly is used by Twitter to shorten URLs in tweets. Use the Bit.ly web service to convert a long Internet URL string to a short one and vice versa with VBA and VB6.|
|InternetSearch||Internet search using VB6 and VBA to launch a web browser with Bing, Google, Yahoo, and YouTube to perform global searches and specific searches for books, finance, images, news, sports, videos, weather, etc. while properly formatting the URL search string.|
|Outlook||Automation||OutlookFolders (class)||Working with Microsoft Outlook Folders through Automation using VB6 and VBA. Compatible with 32 and 64-bit VBA. This is similar to COutlookFolders32 without the use of the 32-bit Common Controls of MSComCtl32.ocx.|
|Windows||Common Dialogs||FileDialog||Displaying the File Open/Save Common Dialog in VB6 and VBA with 32 and 64 bit Windows API calls. A set of pre-defined File Masks are included to simplify the selection of file types.|
|FileDialogVBA||Use the File Open, File Save, and Folder Open Dialogs using the built-in VBA FileDialog command without using the Windows API calls. Supports 32 and 64-bit VBA. The VBA FileDialog command is not as full featured as the Windows API approach but are much easier to use. A set of pre-defined File Masks are included to simplify the selection of file types.|
|Word||Automation||WordMerge (class)||Use Microsoft Word Automation to combine data from a Microsoft Access data source (table, query, or SQL string) to a Word file for mail merge from VBA and VB6.|
|WordConversion||Convert word documents from one format to another using VBA and VB6.|
|XML Files||XML Files||XMLFileCreate (class)||Create an XML file using the DOMDocument MSXML.DLL object with encoding to support Unicode from VBA and VB6. Easily specify the root, add items, add elements (nodes), and add items and elements to elements|
|XMLFileRead (class)||Read an XML file or text string using the DOMDocument MSXML.DLL object from VBA and VB6.
Easily read the root, elements (nodes) for children and sibling nodes. Examples show how to read the entire file and search for specific nodes.
In addition to every existing module that had a Declare statement adjusted to support 64 bit versions of VBA, many modules were significantly enhanced
The code browser is enhanced to improve the way code is managed:
Under Options, error handling default settings can be selected for the error handling module or class you add to your application. This simplifies the specification of the Error Enabler, Re-Enabler, and Handler, plus the use of a global constant to turn error handling off or on.
The Setup program offers user or machine installation options respecting user access control (UAC) permissions and online activation of the product. Supports from Windows XP through Windows 8.x.
New user manual and context sensitive help file.
Total Visual SourceBook is available in different versions depending on your version of MS Office/Access. The 2013 version runs in Office/Access 2000 through 2016 with source code expecting Access/Office 2007 or newer. If you are using Office/Access 2003 or earlier and don't have plans to migrate to 2007 or later, you may prefer the 2003 version.
Total Visual SourceBook Pricing
for Visual Basic (VB6) and VBA such as Microsoft Office/Access/Excel/Word
|Licenses||Price||2016, 2013, 2010 and VB6||2007||2003, 2002, and 2000||97 and 95|
|Single||$399||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Pack||$1299||Buy Now||Buy Now||Buy Now||Buy Now|
|Single||$299||Buy Now||Buy Now||Buy Now||NA|
|5-Pack||$899||Buy Now||Buy Now||Buy Now||NA|
Premium Support Subscription
Also Available as part of:
Source Code for 32 and 64-bit Versions of Office/VBA
Microsoft Office 2016, 2013 and 2010 are available in 32 and 64-bit versions.
The source code library in Total Visual SourceBook 2013 is compatible with 32 and 64-bit Office/VBA.
Unless explicitly specified, all of the source code can be inserted into your projects and will work for users running either the 32 or 64-bit version of Office/VBA.
This makes it easy to support your users without worrying about which version of Access/Office they installed.
Note the Visual Basic 6 specific code is only 32-bit compatible since VB6 does not have a 64-bit version.
Integration with the Module Code Editor (IDE)
Total Visual SourceBook 2013 runs as a standalone program or as an add-in to your VBA/VB6 IDE.
The add-in can only run within the 32-bit version of the IDE.
If you are using the 64-bit version of Office, Total Visual SourceBook still works on its own, but not within your IDE.
Source code library material is redistributable royalty-free.
It must be contained in an application that is compiled and the Total Visual SourceBook library code is not redistributed in a readable form.
Total Visual SourceBook is licensed on a per developer basis.
Each developer who runs the program and uses the code must have a license. Read the License Agreement for details.
Supports Access/Office 2016, 2013, 2010 and 2007, and Visual Basic 6.0!
"The code is exactly how I would like to write code and the algorithms used are very efficient and well-documented."
Van T. Dinh, Microsoft MVP