UsefulOfficeExports - Over 50 exports from the Office DLL
ADO_to_DAO - Convert an ADO Connection object to a DAO Database Object
basHebrewAndGregorian - Convert dates from the Gregorian to the Hebrew Calendar and back
Connect - Finding out if you have an Internet connection
CalendarStuff - Get the (possibly localized) names of months and days
basDatabasePassword - Retrieve the database password of any Jet 3.x/3.5x database
basExecString - Execute a string from the VB6 IDE
basIntlFormats - Handle currency, date, and time formats for other locales
UILangAndLangGroups - Handling some of the Windows 2000 UI Language and Language Group Functions
basGUIDs - Guid Conversion functions for COM, Jet, and SQL Server
basScriptJetSecurity - Script out security permissions in your databases

Have you ever had to import all of the objects from one Jet database to another and wanted to preserve all of the security permissions on the objects? You can download the module basScriptJetSecurity which provides a function that will produce the code that "scripts out" the permissions for all the objects. Make sure you run it before you hit whatever problem causes you to need to script out the permissions! Note also that the actual user accounts are not scripted out (and cannot be since the PIDs to create the workgroup, users, and groups cannot be retrieved after the fact). If you track this information, you can also script that out as well, and even automate things, possibly using the TSI MDW file creator from the TSI utilities page to create the workgroup file.

Code from VBPJ Article "Solving Cross-Codepage Problems"

basInCodePage - Determine the Codepage to use When Converting Unicode to ANSI

basDebugEx - Debugging Functions

basHijri - Determine the Use of Hijri Calendar and Conversion to/from Hijri Dates

Code from Smart Access Article "Is the Query Compiled?"

Code from Smart Access Article "Manage Replication Conflicts"

Code from Smart Access Article "Introducing the TSI Synchronizer Object"

basIsValidIdent - Validate Names to Make Sure They Aren't VBA Keywords

Acheiving Callback Functionality in Access 97 and Office 97

basDbcsSbcs - Convert SBCS to DBCS

basLcidCp - Working with Language IDs, LCIDs, Code Pages, Character Sets etc.

basServerList - Get a List of SQL Servers on an NT Domain

Code from VBPJ Article "Name That Language"

Simple MAPI

Copy NT file perms from one file or dir to another

Problems with this site? Please contact the webmaster@trigeminal.com
with your comments, questions, or suggestions.