These are the weekly Access Archon columns I wrote for Woody's Office Watch. The column now appears in Access Watch; those columns are listed in the second table (see the Links page to subscribe to either Office Watch or Access Watch).
20-Mar-2012
Access Archon Columns from Woody's Office Watch |
||
| No. | Title | Download |
| All | All the Access Archon columns from WOW | wowaarch.zip |
| 1. | Null to Zero | accarch01.zip |
| 2. | Date Magic | accarch02.zip |
| 3. | Mysteries of the Enums | accarch03.zip |
| 4. | Getting Information from the Registry | accarch04.zip |
| 5. | Parameter Popups and What Causes Them | accarch05.zip |
| 6. | Linked Combo Boxes | accarch06.zip |
| 7. | Add-to Combo Boxes | accarch07.zip |
| 8. | More Add-to Combo Boxes | accarch08.zip |
| 9. | Inter-Office Images | accarch09.zip |
| 10. | Selecting All or Nothing from a Combo Box | accarch10.zip |
| 11. | Displaying Unrelated Data on a Form | accarch11.zip |
| 12. | Using the Tag Property to Copy and Restore Values | accarch12.zip |
| 13. | Conditional Report Formatting | accarch13.zip |
| 14. | Pick from/Write To Combo Boxes | accarch14.zip |
| 15. | Early and Late Binding of Variables | accarch15.zip |
| 16. | Form and Report Types | accarch16.zip |
| 17. | Printing the Same Information Twice on a Report | accarch17.zip |
| 18. | Year-end Summary | accarch18.zip |
| 19. | Fields and Controls -- There Is a Difference! | accarch19.zip |
| 20. | Debug.Print, MsgBox, InputBox | accarch20.zip |
| 21. | Printing Forms And Why You Shouldn't | accarch21.zip |
| 22. | Creating Save Names for Word Documents | accarch22.zip |
| 23. | Numbering Report Lines | accarch23.zip |
| 24. | Exporting Access Reports | accarch24.zip |
| 25. | A Miscellany of Tips | accarch25.zip |
| 26. | Credit Card Dates | accarch26.zip |
| 27. | An On/Off Switch for Warning Messages | accarch27.zip |
| 28. | Conference Report | accarch28.zip |
| 29. | Digital Certificates | accarch29.zip |
| 30. | Form and Report Templates | accarch30.zip |
| 31. | Backing up Database Objects | accarch31.zip |
| 32. | Working with Forms Four Ways | accarch32.zip |
| 33. | Odds & Ends | accarch33.zip |
| 34. | Outlook to Access | accarch34.zip |
| 35. | Working with Non-Normalized Data | accarch35.zip |
| 36. | Two Access Add-ins | accarch36.zip |
| 37. | Custom Database Properties | accarch37.zip |
| 38. | More on Database Properties | accarch38.zip |
| 39. | Creating Word Custom Doc Properties | accarch39.zip |
| 40. | Customizing Menus and Toolbars | accarch40.zip |
| 41. | Selecting a Sort Field for a Report | accarch41.zip |
| 42. | Selecting a Filter for a Report | accarch42.zip |
| 43. | Creating a Denormalized Table for Mail Merge | accarch43.zip |
Access Archon Columns from Woody's Access Watch |
||
| No. | Title | Download |
| 44. | Merging to Word from Linked Access Tables | accarch44.zip |
| 45. | Better Reports I | accarch45.zip |
| 46. | Better Reports II | accarch46.zip |
| 47. | Using Listboxes and Combo Boxes to Display Data | accarch47.zip |
| 48. | Retrieving Data from Listboxes and Combo Boxes | accarch48.zip |
| 49. | Record Numbers and Autonumbers | accarch49.zip |
| 50. | Retrieving User Paths and Creating Folders | accarch50.zip |
| 51. | Duplicating Records | accarch51.zip |
| 52. | Using Special Controls | accarch52.zip |
| 53. | TreeView Control Wizard and Subdatasheets | accarch53.zip |
| 54. | The Three Object Models of Access | accarch54.zip |
| 55. | Moving Large Quantities of Data from Access to Word | accarch55.zip |
| 56. | Notes on Importing and Exporting | accarch56.zip |
| 57. | Forms and Subforms | accarch57.zip |
| 58. | Reports and Subreports | accarch58.zip |
| 59. | Working with Strings | accarch59.zip |
| 60. | Queries I | accarch60.zip |
| 61. | Queries II | accarch61.zip |
| 62. | Searching and Finding with Access Data | accarch62.zip |
| 63. | Working with Linked Tables | accarch63.zip |
| 64. | Updating Distributed Applications | accarch64.zip |
| 65. | Working with the Word Object Model | accarch65.zip |
| 66. | Working with the Excel Object Model | accarch66.zip |
| 67. | Working with the Outlook Object Model | accarch67.zip |
| 68. | Creating an Access 97 Distributed Application | accarch68.zip |
| 69. | Creating an Access 2000 Distributed Application | accarch69.zip |
| 70. | Troubleshooting Distributed Applications | accarch70.zip |
| 71. | Paired Single-Select Listboxes | accarch71.zip |
| 72. | Paired Multi-Select Listboxes | accarch72.zip |
| 73. | Linked Forms and Tab Controls | accarch73.zip |
| 74. | Getting A New Agent | accarch74.zip |
| 75. | Renaming Database Objects | accarch75.zip |
| 76. | Design Schemes Add-In, Part 1 | accarch76.zip |
| 77. | Design Schemes Add-In, Part 2 | accarch77.zip |
| 78. | Adding Data on-the-Fly | accarch78.zip |
| 79. | Many-to-Many Relationships | accarch79.zip |
| 80. | Formatting Address Components | accarch80.zip |
| 81. | Working with Files and Folders | accarch81.zip |
| 82. | Proper Case for Names | accarch82.zip |
| 83. | Parsing Name and Address Data -- The Utilities | accarch83.zip |
| 84. | Setting Play Order -- Manual Selection | accarch84.zip |
| 85. | Creating Queries in Code | accarch85.zip |
| 86. | PivotTables and PivotCharts, Part I | accarch86.zip |
| 87. | PivotTables and PivotCharts, Part II | accarch87.zip |
| 88. | Finding Things That Haven't Happened | accarch88.zip |
| 89. | Flattening Linked Data | accarch89.zip |
| 90. | Tricky Queries to Impress Your Boss | accarch90.zip |
| 91. | Using the Office XP FileDialog Object | accarch91.zip |
| 92. | Mail Merge Mysteries | accarch92.zip |
| 93. | Working with Captions | accarch93.zip |
| 94. | A Round-up of Rounding Methods | accarch94.zip |
| 95. | If...End If And Its Alternatives | accarch95.zip |
| 96. | Calculating Working Days | accarch96.zip |
| 97. | Report Footer Positioning | accarch97.zip |
| 98. | Useful Access Add-ons, Part 1 (Total Access Analyzer) | accarch98.zip |
| 99. | Three Ways to Do Anything in Access | accarch99.zip |
| 100. | Specialized Combo Boxes | accarch100.zip |
| 101. | More Things You Can Do Three Ways in Access | accarch101.zip |
| 102. | Storing Outlook Mail Messages in an Access Table | accarch102.zip |
| 103. | Using a TreeView Control as a Record Selector | accarch103.zip |
| 104. | Making Variable-Height Bordered Text Boxes on Reports | accarch104.zip |
| 105. | A Continuous Forms Compendium | accarch105.zip |
| 106. | Mass EMailings from an Access Table | accarch106.zip |
| 107. | Working with References | accarch107.zip |
| 108. | Writing Access Add-ins | accarch108.zip |
| 109. | Using an Array to Work with Form Data | accarch109.zip |
| 110. | Printing Index Cards | accarch110.zip |
| 111. | Working with Lookup Tables | accarch111.zip |
| 112. | Faxing from Access using WinFax with DDE | accarch112.zip |
| 113. | Avoiding the Object Model Guardian with the Redemption Library | accarch113.zip |
| 114. | Creating an Incrementing ID with Date Information | accarch114.zip |
| 115. | Auto-Saving an Access Database | accarch115.zip |
| 116. | Displaying Search Results in a Subform | accarch116.zip |
| 117. | Writing Data to a Text Box | accarch117.zip |
| 118. | Writing Data to a Text File | accarch118.zip |
| 119. | Access 2003 Security Warnings | accarch119.zip |
| 120. | Garry Robinson's Access Security Book | accarch120.zip |
| 121. | Time Zone Converter | accarch121.zip |
| 122. | Using the Office Envelope Object to Avoid Attachment Removal | accarch122.zip |
| 123. | Saving Email Attachments to an Access Table | accarch123.zip |
| 124. | Footers Like Word | accarch124.zip |
| 125. | Denormalizing Linked Data | accarch125.zip |
| 126. | Using Task Reminders to Send an Email Message | accarch126.zip |
Access Archon Columns from Access Watch |
||
| No. | Title | Download |
| 127. | Creating Excel Time Sheets from Access Data | accarch127.zip |
| 128. | Comparing Files in a Folder with Files in a Table | accarch128.zip |
| 129. | Fancy Filters | accarch129.zip |
| 130. | Filter and Merge | accarch130.zip |
| 131. | Using the Printer Object | accarch131.zip |
| 132. | Counting Selections in Listboxes and Combo Boxes | accarch132.zip |
| 133. | Copying Records and Linked Records | accarch133.zip |
| 134. | Useful Access Add-ons, Part 1: Clickbook | accarch134.zip |
| 135. | Mass Report Emailing | accarch135.zip |
| 136. | Caps and Mixed Case Conversion | accarch136.zip |
| 137. | Switching Fields and Records | accarch137.zip |
| 138. | Playing Audio and Video Files Using the Windows Media Player Control | accarch138.zip |
| 139. | Using Text Files to Write and Read Data | accarch139.zip |
| 140. | Printing USPS Bar Codes on Envelopes | accarch140.zip |
| 141. | Matching Word Document Properties with Access Fields | accarch141.zip |
| 142. | Copying a Template for Use in Mail Merge | accarch142.zip |
| 143. | Archiving Data | accarch143.zip |
| 144. | Automating Access Using Windows Script | accarch144.zip |
| 145. | Matching Access and Outlook Contacts | accarch145.zip |
| 146. | Filtering Reports by Month and Year | accarch146.zip |
| 147. | Confirming Deletion of Linked Records | accarch147.zip |
| 148. | Retrieving Path Information | accarch148.zip |
| 149. | Useful Add-ons, Part 2 – The Access Workbench | accarch149.zip |
| 150. | Listing Table and Query Fields | accarch150.zip |
| 151. | Updated Database Backup | accarch151.zip |
| 152. | Storing Data in Database Custom Properties | accarch152.zip |
| 153. | Creating a Folder for a Word Letter | accarch153.zip |
| 154. | Getting User Paths and Date Formats for Use in VBA Code | accarch154.zip |
| 155. | The Extras Add-in for Database Backup and Field Listing | accarch155.zip |
| 156. | Saving to PDF in Access 2007 | accarch156.zip |
| 157. | Rich Text in Memo Fields in Access 2007 | accarch157.zip |
| 158. | Interactive Report Filtering and Sorting in Access 2007 | accarch158.zip |
| 159. | Multi-Valued Fields in Access 2007 | accarch159.zip |
| 160. | Simple Filters | accarch160.zip |
| 161. | Add-to Combo Boxes | accarch161.zip |
| 162. | Getting Your Add-ins to Work in Vista | accarch162.zip |
| 163. | Sorting Reports by Date | accarch163.zip |
| 164. | Displaying More Information about ListBox Items | accarch164.zip |
| 165. | Recovering from an AutoNumber Disaster | accarch165.zip |
| 166. | The Extras Plus Add-in | accarch166.zip |
| 167. | Complex Query Problems and Solutions | accarch167.zip |
| 168. | Merging Data from Queries and Recordsets to Word | accarch168.zip |
| 169. | Editing Value Lists in Access 2007 | accarch169.zip |
| 170. | Mass EMailing of Report Links | accarch170.zip |
| 171. | Linked Listboxes | accarch171.zip |
| 172. | Adding and Deleting Listbox Items | accarch172.zip |
| 173. | Setting the Current Row Back Color | accarch173.zip |
| 174. | Working with Word Document Properties | accarch174.zip |
| 175. | Using the UpDown Control on an Access Form | accarch175.zip |
| 176. | Using the Outlook View Control on an Access Form | accarch176.zip |
| 177. | Writing Data to a Table from a Form | accarch177.zip |
| 178. | Entering Data for a Many-to-Many Relationship | accarch178.zip |
| 179. | Concatenating and Saving Data | accarch179.zip |
| 180. | Working with a Password-Protected Database | accarch180.zip |
| 181. | Working with Progress Bars | accarch181.zip |
| 182. | Custom Navigation Bar | accarch182.zip |
| 183. | Too Many Controls Problem | accarch183.zip |
| 184. | Creating a Word Document with Form Fields | accarch184.zip |
| 185. | Folder Selectors for a Main Menu | accarch185.zip |
| 186. | Controlling One Database from Another | accarch186.zip |
| 187. | An Unbound Combo Box for Selecting or Creating Records on a Subform | accarch187.zip |
| 188. | Working with the New Access 2007 Attachment Field | accarch188.zip |
| 189. | Working with Colors in Access 2007 | accarch189.zip |
| 190. | And/Or Filtering and Searching | accarch190.zip |
| 191. | Emailing Custom PDF Reports in Access 2007 | accarch191.zip |
| 192. | Creating a Fake Access 2007 Split Form in Access 2003 | accarch192.zip |
| 193. | Using Google Maps on an Access Form | accarch193.zip |
| 194. | Currency Formatting on Reports | accarch194.zip |
| 195. | Finding the Nearest Value | accarch195.zip |
| 196. | Access 2007 Multi-valued Fields Revisited | accarch196.zip |
| 197. | Filtering by Multiple Selections | accarch197.zip |
| 198. | Editing Data in Lookup Tables | accarch198.zip |
| 199. | Forcing Zeroes in Reports | accarch199.zip |
| 200. | Exporting Access Data to Excel | accarch200.zip |
| 201. | Colorizing Selected Datasheet Rows | accarch201.zip |
| 202. | Concatenating Name and Address Fields | accarch202.zip |
| 203. | Creating a Log File | accarch203.zip |
| 204. | Creating Future Emails | accarch204.zip |
| 205. | Backwards Compatibility Problem between Access 2010 and 2007 | accarch205.zip |
| 206. | Updated Paired Listboxes | accarch206.zip |
| 207. | Archiving Linked Tables to Another Database | accarch207.zip |
| 208. | Dealing with Disabled Databases | accarch208.zip |
| 209. | An Alternate Method for Archiving to Another Database | accarch209.zip |
| 210. | Listing Office Properties | accarch210.zip |
| 211. | Showing and Hiding the Navigation Pane | accarch211.zip |
| 212. | A New Style Main Menu | accarch212.zip |