Code Library

Code Library

#clsApp Routines

  • Environmentally Friendly Access:

  • The Global Form:

#clsRegOp Routines

  • RegOp Class for 64-bit VBA:

  • RegOp Quick Tip:

#clsStatus Routines

#CodeGeneration Routines

#DateFunctions Routines

#DesignProcedures Routines

  • Python-inspired Doc Tests in VBA:

  • Writing Code with Code in VBA:

  • "Complex" DTOs in VBA:

  • Watch This!:

#DesignProcedures Routines

  • Listing External Table Sources:

#FileFunctions Routines

  • Recursion Demystified: Creating Subfolders:

  • The Subtle Dangers of Dir():

  • Kill Failed? Let User Try Again:

  • Text Files: Read, Write, Append:

  • Unicode-Safe Filtered Filename Lookups:

  • Joining Paths in VBA:

  • Finding the Temporary Folder with VBA:

  • Getting a Temporary File Name with VBA:

#FormFunctions Routines

  • My Dirty Little Secret:

  • Filling in the Blanks:

  • Why so lazy, Access?:

  • Clearing a List Box in Access:

  • Unicode-Friendly MsgBox:

  • Setting MultiSelect At Runtime:

  • PreviewReport Function:

  • The ArrowKeyNav Routine:

  • ComboBox Dropped Down State:

  • Get Form By Control:

  • Microsoft Access: Check if Form Object is a Subform:

  • Get Top Form By Control:

  • Combo Boxes and Target Sizes:

#ReportFunctions Routines

  • Nothing To See Here:

#SqlServer Routines

  • Pushing Field Comments to SQL Server:

#StringFunctions Routines

  • Quoth thy SQL? Evermore!:

  • Come Together:

  • Part and Parse()-l:

  • Now you have two problems:

  • Converting Numbers to Text:

#we Classes Routines

#WindowFunctions Routines

  • Fun with Form Windows:

  • Get Back Here, Form!:

  • Get a Handle on Window State: