PDA

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. Connect Excel to Access
  112. Using FTP in VBA
  113. Convert Strings to Hyperlinks (Excel VBA)
  114. Who's Connected / Who's Logged on
  115. Hide / Disable Menu Bar
  116. Get Computer Name/Identifier
  117. Product/License Validation
  118. Organizing If-else-statement
  119. Good old Acc97 Messagebox
  120. Data Validation (key press events)
  121. How to prevent truncation of memo field (field > 255 char) on export to text file.
  122. Export to multiple Excel sheets
  123. Text alignment in listboxes
  124. Decimal to Hexadecimal Color Conversion Function
  125. Generating a List of Random Numbers
  126. VBA Program to get a IE HTML DOM Tree
  127. Search for a text trough all queries.
  128. Function Sort text identifiers with SQL Assending
  129. General function User actions log to table
  130. Get Current Path of Linked Table
  131. Function Format Excel Tab Name - remove characters from any string
  132. DAO CurrentDB.OpenRecordset example
  133. Backing up and restore your tables
  134. Not In List With a Pop-Up Form and SubForm
  135. How to Highlight an Option/Label in a Frame
  136. Use F1 to open a custom help file
  137. Program to convert a HTML Table to Access
  138. Sending Google Mail (Gmail) from MS Access, VBA, Excel, Word...
  139. How to geocode an address ?
  140. Hide Ribbon & Nav window yay
  141. Fast Lookup
  142. Output a Filtered Query to Excel
  143. Build a Filtered Subform Using Multiple ComboBoxes (Access 2007 or later)
  144. VB_Beautifier and Cross Reference (ongoing) v2.0
  145. Return to same field after requery in subform
  146. KeyDown Code Snippet
  147. Reset Access
  148. number to ordinal list (1st, 2nd, 3rd...)
  149. Code to Refresh Link to SharePoint Lists
  150. Drifting Colours
  151. Wait for a form to Close: Alternative to dialog mode
  152. Form to Display Next to Last record
  153. CSV input file checker.
  154. How to create msgBox with button label Yes(Y) and No(N)
  155. Reference a SubForm Control on a Second From the First Form
  156. Trusted Location
  157. 'Backup this database' button
  158. Example of SQL INSERT using ADODB.Command and ADODB.Parameters objects
  159. Military Time
  160. Coloring Controls made easy. Using Intellisence!
  161. Hiding Tables
  162. Compact a Back End OR a Front End Database
  163. Internationalisation Module for Access