View Full Version : access insights


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