View Full Version : access insights


  1. Sending E-Mails via Outlook - One Developer's Approach
  2. Parts of a form - Nomenclature
  3. Display images in your DB without using Attachment Fields
  4. Back by popular(?) demand!
  5. A Better Progress Bar
  6. VBA to C Crossover
  7. Alternative Filter Method / Single Field Filtering
  8. Control External Processes using Scripts - CMD
  9. Control External Processes using Scripts - FTP
  10. Adding business days with configurable weekend days and holidays
  11. Determine if a Declared Array has been Initialised
  12. Use SQL in other application vba
  13. Fuzzy String Matching: Double Metaphone Algorithm
  14. Item Numbering Within a Group
  15. Multi-Import/Link Excel file into access with debug info and more option
  16. The VBA Rnd() Function is Bad and What to Use Instead
  17. LZW Compression Algorithm in VBScript
  18. Optimally Assigning Workers to Jobs Using the Hungarian Algorithm
  19. Using A Foreign Key's Value in a Table's OrderBy Property
  20. Importing MS Word Tables into MS Access Tables using VBA
  21. How to open Access 2010 Navigation Form in acAddMode
  22. For Fun: Blackjack Simulator
  23. Managing DSN-Less Connections
  24. Log Code and Property References
  25. Working with Front and Back-Ends
  26. How To Create User Permissions and Customized Menus in MS Access
  27. Dev Tools: Fill immediate window with Table columns
  28. When to Use Layouts: The Synergy of Layouts and Anchors in MS Access 2010
  29. Ranking Queries in MS Access SQL
  30. How to Export a Form or Report as a "Package"
  31. VBA Standard Text File I/O Statements
  32. Inactivity Detection in Access
  33. How to Close a Main Form Without Saving Changes of any Subforms
  34. Combining all parts of a name without extra spaces
  35. Using buttons to change sort order
  36. Access Progress Form
  37. How to find out which report or form a control belongs to
  38. Access: Crash Reporter / Error mailer
  39. Getting the results for all values in a combo box
  40. Risks Involved When Using Memo Fields in MS Access Databases
  41. Database Analyser
  42. Treeview in Access Part 1: Basic - Loading information into treeview
  43. How to dynamically resize a continuous Dialog form to fit / show all records
  44. Windows Management Instrumentation (WMI) Tutorial
  45. How to Decompile an Access Application Or How to do a Full Fresh Compile
  46. Convert query, table or SQL to web forum compatible markup
  47. Search QueryDefs, Reports and Form controls for a string
  48. Steganography for VBA
  49. Exporting filtered access Datasheet to Excel spreadsheet - No truncation
  50. How To Get External IP Address via VB/VBA
  51. Aggregate Query Woes
  52. Create a shortcut for your application automatically
  53. Find users special folders (such as desktop/My documents)
  54. Create a Folder using VBA
  55. Access Application Installer with Shortcuts
  56. A Developer Front-End for Queries and Tables
  57. Expand intellisense to your custom function
  58. Database Properties
  59. Handling Optional Parameters in VBA
  60. Extracting/Updating SQL from a QueryDef
  61. Class Module to Handle Opening Forms Hierarchically
  62. Connecting to Different Databases from MS Access
  63. Select a File or Folder using the FileDialog Object
  64. Context-Sensitive Help
  65. How to Debug SQL String
  66. MS Access Calendar - OVERVIEW
  67. Video: How to use a custom function in MS Access (2003)
  68. NGram Approximate String Matching
  69. Levenshtein Approximate String Matching
  70. How to implement a multi-lingual database
  71. How to change BackEnd Database links. (Access 2003)
  72. Progress Indicator in Access
  73. SHA2 Cryptographic Hash Algorithm for VBA and VBScript
  74. Securing a Database in Access
  75. AES Encryption Algorithm for VBA and VBScript
  76. RC4 Encryption Algorithm for VBA and VBScript
  77. How to Download A File From Internet using VBA
  78. Asynchronous Query
  79. How to select Records in an Access Subform from a Combo Box
  80. Cascaded Form Filtering
  81. How to Stop Bound Forms from Updating Automatically
  82. Simulate Full Screen or Dim the Background
  83. Custom Error Messages
  84. Generate secure user passwords using the MD5 hash class module
  85. Relinking ODBC Tables using VBA
  86. Format system time to milliseconds in VBA
  87. Using msoFileDialogSaveAs in MS Access
  88. Invoking a Database From the Command Line
  89. AddAllToList With Column Headers
  90. Demo of Conditional format in subform - Unlimited colours
  91. SQL Injection Attack
  92. Code Signing
  93. Multiple Combobox Filter with Clear Option
  94. HowTo: Calculate business days - pure SQL approach.
  95. Reasons for a Query to be Non-Updatable
  96. Forms Interaction
  97. ShellWait() Function
  98. Why Values in Unbound Form Controls Don't Persist
  99. How to Dynamically set the Combo Drop Down List Width
  100. For...Next vs Do...Loop, and the Winner is?
  101. Require Variable Declaration
  102. Double-clicking to move an item between list boxes
  103. 'Spruce Up' Your Message Boxes!
  104. Access QueryDefs Mis-save Subquery SQL
  105. Retrieving Data From an ADO Recordset Using GetRows()
  106. Retrieving Data From a DAO Recordset Using GetRows()
  107. Finding Jet SQL Help
  108. Publishing Access Data on the Web
  109. Excel in Access (Part 1)
  110. Windows Script Host Object library
  111. Microsoft Scripting Runtime #4
  112. Microsoft Scripting Runtime #3
  113. Microsoft Scripting Runtime #2
  114. Microsoft Scripting Runtime #1
  115. Using "&" and "+" in WHERE Clause
  116. The BLOB (not the movie!)
  117. Generate Statistics With the OpenSchema Method
  118. The ISAMStats Method
  119. How to Create a Data Link File
  120. Queries in Access using SQL View
  121. Indexes in Microsoft Access
  122. Access Built-in Functions
  123. VBA - Event Driven Programming
  124. Macros or VBA?
  125. How to Programmatically Create a Hyperlink on a Form
  126. Printer and Printing Tips
  127. Front-End / Back-End (FE/BE)
  128. Using ParamArray()
  129. How to Use Named Arguments
  130. Does a File Exist?
  131. Access 2007 Linked Table Manager not working correct...
  132. How to Use Excel Functions in Access
  133. The Supports Method of an ADO Recordset Object
  134. Excel Functions in Access
  135. In Arrays, For Each...Next vs For...Next
  136. What is Null?
  137. Cache Object References
  138. The Partition() Function
  139. How to Unsecure a Secure Access Database
  140. Methods of Connecting to SQL Server
  141. Create Dynamic Report using VBA
  142. How to Declare a Default Property in a Class Module
  143. ADO Events [Advanced Content]
  144. Early vs Late Binding
  145. How to Generate a User List
  146. Passive Shutdown
  147. ADO Transaction Processing
  148. ANSI Standards in String Comparisons
  149. MS Access Calculated List
  150. DAO Transaction Processing - What is it?
  151. Scroll Wheel Support in VBA Window
  152. Finding a Specific Record Programmatically
  153. Automatic Error Handling in Access
  154. Use IsCharAlphaNumeric() Rather Than ASCII Values
  155. Meet the ADO Cursors
  156. User-defined class for SQL Select expressions
  157. Reserved Words in Access, Especially Date and Time
  158. Variable Scope in VBA for MS Access
  159. Stored Query vs SQL Statement
  160. Function to return Username (NT Login) of current user
  161. 'Persisting' a Recordset
  162. Running code asynchronously
  163. Debugging in VBA - 3) General Tips
  164. Debugging in VBA - 2G) The Watch Pane
  165. Debugging in VBA - 2F) The Locals Pane
  166. Debugging in VBA - 2E) The Object Browser Pane (F2)
  167. Debugging in VBA - 2D) The Immediate Pane (Ctrl-G)
  168. Debugging in VBA - 2C) The Properties Pane (F4)
  169. Debugging in VBA - 2B) The Project Explorer Pane (Ctrl-R)
  170. Debugging in VBA - 2A) The Code Pane (F7)
  171. Obtain Access Information/State of an Object
  172. Debugging in VBA - 1) Overview
  173. Debugging in VBA
  174. Using the MouseMove Property
  175. How to Use a Progress Meter in Access
  176. A 6-Pack of Good Programming Style Hints
  177. Producing a List from Multiple Records
  178. How to Play Sounds in Access
  179. Accessing Field Values in Recordsets
  180. Testing for an Empty Recordset
  181. How to Optimize Queries and Recordsets
  182. DAO or ADO - Why Not Both?
  183. Custom Error Messages
  184. Hide/Display SubMenu Buttons
  185. Control Object Reference (Me!)
  186. timeGetTime() vs Timer()
  187. Cascading Forms.
  188. Module to Read from the Windows Registry
  189. Accessing Tabs on a Tab Control
  190. Avoid IIf(), Switch(), and Choose() in VBA code
  191. To create an mde file
  192. SQL JOINs
  193. What's Your Function Flavor?
  194. Cascading Combo/List Boxes
  195. Microsoft Access Specifications
  196. VBA Data Types
  197. Application Automation
  198. Referring to Items on a Sub-Form
  199. Converting numbers to Words
  200. Memo Field Angst
  201. Memo Fields in Access
  202. Using Tabbed Pages on a Form
  203. Subqueries in SQL
  204. Input Masks
  205. Function to Move (Forwards or Backwards) Through Weekdays
  206. Example Filtering on a Form.
  207. Retrieve Values from a Multi-Select ListBox
  208. Basic SQL Syntax for Access Queries
  209. Import csv (Comma Separated Value) File
  210. Database Normalization and Table Structures
  211. Access VBA DAO recordset loop using two recordsets
  212. Literal DateTimes and Their Delimiters (#).
  213. Quotes (') and Double-Quotes (") - Where and When to use them