View Full Version : insights

  1. Relinking odbc tables using VBA
  2. Format system time to milliseconds in VBA
  3. Using msoFileDialogSaveAs in MS Access
  4. Invoking a Database From the Command Line
  5. Reserved names for Access
  6. AddAllToList With Column Headers
  7. Demo of Conditional format in subform - Unlimited colours
  8. SQL Injection Attack
  9. Code Signing
  10. Multiple Combobox Filter with Clear Option
  11. HowTo: Calculate business days - pure SQL approach.
  12. Reasons for a Query to be Non-Updatable
  13. Forms Interaction
  14. ShellWait() Function
  15. Why Values in Unbound Form Controls Don't Persist
  16. How to Dynamically set the Combo Drop Down List Width
  17. For...Next vs Do...Loop, and the Winner is?
  18. Require Variable Declaration
  19. Double-clicking to move an item between list boxes
  20. 'Spruce Up' Your Message Boxes!
  21. Access QueryDefs Mis-save Subquery SQL
  22. Retrieving Data From an ADO Recordset Using GetRows()
  23. Retrieving Data From a DAO Recordset Using GetRows()
  24. Finding Jet SQL Help
  25. Publishing Access Data on the Web
  26. Excel in Access (Part 1)
  27. Windows Script Host Object library
  28. Microsoft Scripting Runtime #4
  29. Microsoft Scripting Runtime #3
  30. Microsoft Scripting Runtime #2
  31. Microsoft Scripting Runtime #1
  32. Using "&" and "+" in WHERE Clause
  33. The BLOB (not the movie!)
  34. Generate Statistics With the OpenSchema Method
  35. The ISAMStats Method
  36. How to Create a Data Link File
  37. Queries in Access using SQL View
  38. Indexes in Microsoft Access
  39. Access Built-in Functions
  40. VBA - Event Driven Programming
  41. Macro's or VBA ?
  42. How to Programmatically Create a Hyperlink on a Form
  43. Printer and Printing Tips
  44. Front-End / Back-End (FE/BE)
  45. Using ParamArray()
  46. How to Use Named Arguments
  47. Does a File Exist?
  48. Access 2007 Linkedtable manager not working correct...
  49. How to Use Excel Functions in Access
  50. The Supports Method of an ADO Recordset Object
  51. Excel Functions in Access
  52. In Arrays, For Each...Next vs For...Next
  53. What is Null?
  54. Cache Object References
  55. The Partition() Function
  56. How to Unsecure a Secure Access Database
  57. Methods of Connecting to SQL Server
  58. Create Dynamic Report using VBA
  59. How to Declare a Default Property in a Class Module
  60. ADO Events [Advanced Content]
  61. Early vs Late Binding
  62. How to Generate a User List
  63. Passive Shutdown
  64. ADO Transaction Processing
  65. ANSI Standards in String Comparisons
  66. MS Access Calculated List
  67. DAO Transaction Processing - What is it?
  68. Scroll Wheel Support in VBA Window
  69. Finding a Specific Record Programmatically
  70. Automatic Error Handling in Access
  71. Use IsCharAlphaNumeric() Rather Than ASCII Values
  72. Meet the ADO Cursors
  73. User-defined class for SQL Select expressions
  74. Reserved Words in Access, Especially Date and Time
  75. Variable Scope in VBA for MS Access
  76. Stored Query vs SQL Statement
  77. Function to return Username (NT Login) of current user
  78. 'Persisting' a Recordset
  79. Running code asynchronously
  80. Debugging in VBA - 3) General Tips
  81. Debugging in VBA - 2G) The Watch Pane
  82. Debugging in VBA - 2F) The Locals Pane
  83. Debugging in VBA - 2E) The Object Browser Pane (F2)
  84. Debugging in VBA - 2D) The Immediate Pane (Ctrl-G)
  85. Debugging in VBA - 2C) The Properties Pane (F4)
  86. Debugging in VBA - 2B) The Project Explorer Pane (Ctrl-R)
  87. Debugging in VBA - 2A) The Code Pane (F7)
  88. Obtain Access Information/State of an Object
  89. Debugging in VBA - 1) Overview
  90. Debugging in VBA
  91. Using the MouseMove Property
  92. How to Use a Progress Meter in Access
  93. A 6-Pack of Good Programming Style Hints
  94. DO NOT POST QUESTIONS HERE
  95. Producing a List from Multiple Records
  96. How to Play Sounds in Access
  97. Accessing Field Values in Recordsets
  98. Testing for an Empty Recordset
  99. How to Optimize Queries and Recordsets
  100. DAO or ADO - Why Not Both?
  101. Custom Error Messages
  102. Hide/Display SubMenu Buttons
  103. Control Object Reference (Me!)
  104. timeGetTime() vs Timer()
  105. Cascading Forms.
  106. Module to Read from the Windows Registry
  107. Accessing Tabs on a Tab Control
  108. Avoid IIf(), Switch(), and Choose() in VBA code
  109. To create an mde file
  110. SQL JOINs
  111. What's Your Function Flavor?
  112. Cascading Combo/List Boxes
  113. Microsoft Access Specifications
  114. VBA Data Types
  115. Application Automation
  116. Referring to Items on a Sub-Form
  117. Converting numbers to Words
  118. Memo Field Angst
  119. Memo Fields in Access
  120. Using Tabbed Pages on a Form
  121. Subqueries in SQL
  122. Input Masks
  123. Function to Move (Forwards or Backwards) Through Weekdays
  124. Example Filtering on a Form.
  125. Retrieve Values from a Multi-Select ListBox
  126. Basic SQL Syntax for Access Queries
  127. Import csv (Comma Separated Value) File
  128. Database Normalization and Table Structures
  129. Access VBA DAO recordset loop using two recordsets
  130. Literal DateTimes and Their Delimiters (#).
  131. Quotes (') and Double-Quotes (") - Where and When to use them