View Full Version : Code Repository


  1. Code Archive
  2. Draw expanding lines in report detail
  3. Hide all Access Toolbars and Menubars
  4. Calculate A Person's Age
  5. Reverse UK School Year
  6. Clipboard stuff
  7. Misc Text functions
  8. very basic email validation
  9. regex validation
  10. Replacing characters/words using public types
  11. Arrays and the Split Function
  12. Conditionally highlight report controls.
  13. Check for entry - Any comments?
  14. Use of the hidden reference to DAO.
  15. Sending password-protected Winzipped reports to recipients
  16. Export All Database Objects Into Text Files
  17. Strings and the Replace Function
  18. Subform Syntax
  19. Backup & Restore using ZIP
  20. Image Linking In Reports
  21. Batchfile for backup with timestamp
  22. Hidding MS Access Objects
  23. Using DAO to search strings
  24. Create XML and XSL files from SQL SELECT statement
  25. Word Count Function
  26. Transpose function for Access
  27. The FileSystemObject Complete Story
  28. Please Don't Post Questions Here
  29. Wait for an object to close ...
  30. Conditionally Change a ComboBox RowSource from one Query to another.
  31. Sorting Complex Alpha-Numeric Strings
  32. Generic Error Handling function
  33. Default value for Custom Property
  34. Not In List Code
  35. Adding/subtracting weekdays
  36. From Tech Republic - A simple solution for tracking changes to Access Database
  37. Save user settings to registry
  38. Recursive GetPart function
  39. Forgotten the hourglass?
  40. When queries get corrupted...
  41. Showing all initial values in cascading comboboxes
  42. Set/Create AllowByPassKey property
  43. Disable Toolbars
  44. Bypass outlook security settings (Free!!)
  45. converting reports crystal reports 7.x to crystal reports 8.x
  46. function to return the day that is the third Wednesday of a given month
  47. xth weekday of the month
  48. ACC2000: Recursive RSS/XML Reader
  49. Calculate Business Days - No Holiday table needed
  50. Calculate Business Days - No Holiday Table Needed (including MLK day)
  51. Page Numbers for Individual Sections on Report
  52. Reverse String
  53. Database corruption - potential solution
  54. DateDiff results in years, months, days
  55. Returning Top n Records from Starting Point Other than 1st Record
  56. GetTotalTime Function
  57. Get Table Information
  58. Universal Return Particular Date Function
  59. Forcing Intellisense to work in VBA
  60. integer to text binary, hex, or any other base
  61. Check Access Version w/ Batch File
  62. vbSentenceCase -> Convert a string to Sentence Case
  63. Get Excel's cell value (format string "A1")
  64. Week start calculation
  65. Get the n-th string faster
  66. Export any form's recordset to Excel
  67. Code to upsize individual tables to SQL Server
  68. Masked Input Box (DKInputBox)
  69. Access Sub-Total Function Code 4 u
  70. Search for Multiple Parameters
  71. Create and Arrange Graphs in Excel from Access
  72. Find nth Occurence of a space/character in a string
  73. Query Previous Time Periods
  74. Audit Trail into a separate table (Tracking record edits in a databse)
  75. Array Shuffler
  76. Spell Checker Popup Form
  77. Display Current DB File Size on a form
  78. Reconnect Attached tables on Start-up
  79. Creating a global Compilation Directive to optionally compile code
  80. XML Recursive Tree Walker
  81. Timed Msgbox Function: TMsgBox
  82. String Set Combinations / Permutations
  83. Extracting a specified block of characters from a delimited string
  84. Maximize Internet Explorer Window with VBA
  85. Hide the Access Program Window
  86. VB_Beautifier and Cross Reference (ongoing)
  87. Keep Access forms on top of other windows/programs
  88. Disable EXIT menu / CLOSE button
  89. Position and Size the Access Window
  90. Check Screen Resolution
  91. PC Speaker beeps, buzzes and tunes
  92. Delete Duplicate Records based on criteria
  93. Word Scrambler
  94. New, faster GetPart function without recursion using Split()
  95. Determining error # for error that is occuring
  96. Error Message Override
  97. KeyDown Code
  98. KeyPress Code
  99. Dealing with null values in textboxes
  100. KeyPress Code
  101. Shutdown rEstart and logoff from a form
  102. Using the validation rule based on a value of a filed in the same table!
  103. Splash screen
  104. Removing the list of recent opened files using code
  105. Fill Data automaticly using a Timer()
  106. Packaging and Deployment solution using MS DOS
  107. Preventing users from using the F11 key
  108. Disable the SHIFT key bypass option
  109. Convert a given drive letter to the mapped UNC of the local machine
  110. Autonumbering rows in Excel by VBA
  111. D Functions
  112. Connect Excel to Access
  113. Using FTP in VBA
  114. Convert Strings to Hyperlinks (Excel VBA)
  115. Who's Connected / Who's Logged on
  116. Hide / Disable Menu Bar
  117. Get Computer Name/Identifier
  118. Product/License Validation
  119. Organizing If-else-statement
  120. Good old Acc97 Messagebox
  121. Free to use - Schedule/TimeTable form