Code Sample originsWhy reinvent the wheel? When I write a module that I know that I will use again or write a module based on extensive research and testing, I save a copy to use later. As my collection has grown, my development time has decreased. These are code samples, fragments, and forms that I have collected and that I use in my development every day. They come in three overlapping types in no particular order. Some are example modules and forms. They contain the sample code that I found through Microsoft or on the web as the first subroutine in the module. Then one or more subroutines follow that are copied from applications that I have developed to show how I have used algorithm of the example in actual situations. Some of the modules and forms I use as whole cloth. I copy them into the current application that I am building. Some are strictly for development. They return information that I use to speed development. | Forms | Modules | Tables |
|---|
- frmASCII
- frmCalendar
- frmCompareField_Tab
- frmExportToExcel
- frmFieldList
- frmOneField
- frmPassword
- frmPleaseWait
- frmPleaseWaitDetail
- frmPrintStatus
- frmProgressBar
- frmProperties
- frmSearchQueries
| - ModAutoExcel
Basic Excel Automation Download ModAutoExcel.txt - ModAutoMDE
A scary method using sendkeys to automatically generate MDE files from an array of database names Download ModAutoMDE.txt - ModBuildForm
- ModCalendar
- ModChangeLinks
- ModClearList
- ModClipboardAPI
- ModCommandBar
- ModConvertTo
- ModConvertToPDF
- ModCreateTable
- ModDisconnectedRecordset
- ModDisplayReportControlProperties
- ModElapsedPartialMonths
- ModEncrypt
- ModExists
- ModExportTableToExcel
- ModExportToFile
- ModExportToFilePipe
- ModFileOperationAPI
- ModGetLogin
- ModListEverything
- ModListFilesAPI
- ModListPrinters
- ModLoadAndSaveFromText
- ModLogManager
- ModLotus
- ModMultipleColumnListBox
- ModOpenSaveDialog
- ModPleaseWait
- ModPrintArray
- ModPrintDialog
- ModPrinterStatus
- ModPrintPositionNumberedString
- ModReplacementStringFunctions
- ModReturnFolder
- ModReturnPassword
- ModReturnReferences
- ModRunningApp
- ModSelectTimeCommandBar
- ModShowHideApplicationWindow
- ModSleep
- ModSpecialFolders
- ModTempDB
- ModUNC
| - tblRetry
- tblTempObjects
|
Disclaimer:Some of the code in these fragments comes from other online sources. They are imbedded inside of my subroutines and are properly documented. If, however, you feel that this document infringes upon your copyright. Please inform me by email specifying the offending code and I will remove it immediately. |