View Full Version : insights

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