Bulgarian   Chinese - Simplified   Chinese - Traditional   Dutch   English - United States   French   German   Portuguese - Iberian   Spanish   Swedish   Tamil   Turkish  

Home




Code of Varying Usefulness - Trigeminal Software, Inc. (English)

The following is a collection of sample code of varying usefulness. Give them a try. You never can tell...


ExpandUsefulOfficeExports - Over 50 exports from the Office DLL
ExpandADO_to_DAO - Convert an ADO Connection object to a DAO Database Object
ExpandbasHebrewAndGregorian - Convert dates from the Gregorian to the Hebrew Calendar and back
ExpandConnect - Finding out if you have an Internet connection
ExpandCalendarStuff - Get the (possibly localized) names of months and days
ExpandbasDatabasePassword - Retrieve the database password of any Jet 3.x/3.5x database
ExpandbasExecString - Execute a string from the VB6 IDE
ExpandbasIntlFormats - Handle currency, date, and time formats for other locales
ExpandUILangAndLangGroups - Handling some of the Windows 2000 UI Language and Language Group Functions
CollapsebasGUIDs - Guid Conversion functions for COM, Jet, and SQL Server

If you work with COM, or Jet and/or SQL Server 7.0 replication, you use globally unique identifiers (GUIDs). There are a lot of rules about when you need to use the canonical (text) form that looks like

{5FF51B8E-8A0C-11D2-BD7C-006008D242CD}

when you need to use "Jet" text form that looks like

{guid {5FF51B8E-8A0C-11D2-BD7C-006008D242CD}}

or when you need to use the 16-byte binary form that looks like some unreadable slop that I will not post here. The module basGUIDs just contains some handy conversion functions you can use to do things with these handy items.


ExpandbasScriptJetSecurity - Script out security permissions in your databases
ExpandCode from VBPJ Article "Solving Cross-Codepage Problems"
ExpandbasInCodePage - Determine the Codepage to use When Converting Unicode to ANSI
ExpandbasDebugEx - Debugging Functions
ExpandbasHijri - Determine the Use of Hijri Calendar and Conversion to/from Hijri Dates
ExpandCode from Smart Access Article "Is the Query Compiled?"
ExpandCode from Smart Access Article "Manage Replication Conflicts"
ExpandCode from Smart Access Article "Introducing the TSI Synchronizer Object"
ExpandbasIsValidIdent - Validate Names to Make Sure They Aren't VBA Keywords
ExpandAcheiving Callback Functionality in Access 97 and Office 97
ExpandbasDbcsSbcs - Convert SBCS to DBCS
ExpandbasLcidCp - Working with Language IDs, LCIDs, Code Pages, Character Sets etc.
ExpandbasServerList - Get a List of SQL Servers on an NT Domain
ExpandCode from VBPJ Article "Name That Language"
ExpandSimple MAPI
ExpandCopy NT file perms from one file or dir to another

Home

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