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