Access Archon


The first table below lists the weekly Access Archon columns I wrote for Woody's Office Watch (many of them are now outdated and have been superseded by later articles in Access Watch).  The Woody's Access Watch columns are listed in the second table, and the Access Watch columns in the third table.

new_clr.gif (4924 bytes) 6-Aug-2016

Access Archon Columns from Woody's Office Watch

No. Title Download
All All the Access Archon columns from WOW
1. Null to Zero
2. Date Magic
3. Mysteries of the Enums
4. Getting Information from the Registry
5. Parameter Popups and What Causes Them
6. Linked Combo Boxes
7. Add-to Combo Boxes
8. More Add-to Combo Boxes
9. Inter-Office Images
10. Selecting All or Nothing from a Combo Box
11. Displaying Unrelated Data on a Form
12. Using the Tag Property to Copy and Restore Values
13. Conditional Report Formatting accarch13.zip1
14. Pick from/Write To Combo Boxes
15. Early and Late Binding of Variables
16. Form and Report Types
17. Printing the Same Information Twice on a Report
18. Year-end Summary
19. Fields and Controls -- There Is a Difference!
20. Debug.Print, MsgBox, InputBox
21. Printing Forms And Why You Shouldn't
22. Creating Save Names for Word Documents
23. Numbering Report Lines
24. Exporting Access Reports
25. A Miscellany of Tips
26. Credit Card Dates
27. An On/Off Switch for Warning Messages
28. Conference Report
29. Digital Certificates
30. Form and Report Templates
31. Backing up Database Objects
32. Working with Forms Four Ways
33. Odds & Ends
34. Outlook to Access
35. Working with Non-Normalized Data
36. Two Access Add-ins
37. Custom Database Properties
38. More on Database Properties
39. Creating Word Custom Doc Properties
40. Customizing Menus and Toolbars
41. Selecting a Sort Field for a Report
42. Selecting a Filter for a Report
43. Creating a Denormalized Table for Mail Merge


Access Archon Columns from Woody's Access Watch

No. Title Download
44. Merging to Word from Linked Access Tables
45. Better Reports I
46. Better Reports II
47. Using Listboxes and Combo Boxes to Display Data
48. Retrieving Data from Listboxes and Combo Boxes
49. Record Numbers and Autonumbers
50. Retrieving User Paths and Creating Folders
51. Duplicating Records
52. Using Special Controls
53. TreeView Control Wizard and Subdatasheets
54. The Three Object Models of Access
55. Moving Large Quantities of Data from Access to Word
56. Notes on Importing and Exporting
57. Forms and Subforms
58. Reports and Subreports
59. Working with Strings
60. Queries I
61. Queries II
62. Searching and Finding with Access Data
63. Working with Linked Tables
64. Updating Distributed Applications
65. Working with the Word Object Model
66. Working with the Excel Object Model
67. Working with the Outlook Object Model
68. Creating an Access 97 Distributed Application
69. Creating an Access 2000 Distributed Application
70. Troubleshooting Distributed Applications
71. Paired Single-Select Listboxes
72. Paired Multi-Select Listboxes
73. Linked Forms and Tab Controls
74. Getting A New Agent
75. Renaming Database Objects
76. Design Schemes Add-In, Part 1
77. Design Schemes Add-In, Part 2
78. Adding Data on-the-Fly
79. Many-to-Many Relationships
80. Formatting Address Components
81. Working with Files and Folders
82. Proper Case for Names
83. Parsing Name and Address Data -- The Utilities
84. Setting Play Order -- Manual Selection
85. Creating Queries in Code
86. PivotTables and PivotCharts, Part I
87. PivotTables and PivotCharts, Part II
88. Finding Things That Haven't Happened
89. Flattening Linked Data
90. Tricky Queries to Impress Your Boss
91. Using the Office XP FileDialog Object
92. Mail Merge Mysteries
93. Working with Captions
94. A Round-up of Rounding Methods
95. If...End If And Its Alternatives
96. Calculating Working Days
97. Report Footer Positioning
98. Useful Access Add-ons, Part 1 (Total Access Analyzer)
99. Three Ways to Do Anything in Access
100. Specialized Combo Boxes
101. More Things You Can Do Three Ways in Access
102. Storing Outlook Mail Messages in an Access Table
103. Using a TreeView Control as a Record Selector
104. Making Variable-Height Bordered Text Boxes on Reports
105. A Continuous Forms Compendium
106. Mass EMailings from an Access Table
107. Working with References
108. Writing Access Add-ins
109. Using an Array to Work with Form Data
110. Printing Index Cards
111. Working with Lookup Tables
112. Faxing from Access using WinFax with DDE
113. Avoiding the Object Model Guardian with the Redemption Library
114. Creating an Incrementing ID with Date Information
115. Auto-Saving an Access Database
116. Displaying Search Results in a Subform
117. Writing Data to a Text Box
118. Writing Data to a Text File
119. Access 2003 Security Warnings
120. Garry Robinson's Access Security Book
121. Time Zone Converter
122. Using the Office Envelope Object to Avoid Attachment Removal
123. Saving Email Attachments to an Access Table
124. Footers Like Word
125. Denormalizing Linked Data
126. Using Task Reminders to Send an Email Message

Access Archon Columns from Access Watch

No. Title Download
127. Creating Excel Time Sheets from Access Data
128. Comparing Files in a Folder with Files in a Table
129. Fancy Filters
130. Filter and Merge
131. Using the Printer Object
132. Counting Selections in Listboxes and Combo Boxes
133. Copying Records and Linked Records
134. Useful Access Add-ons, Part 1:  Clickbook
135. Mass Report Emailing
136. Caps and Mixed Case Conversion
137. Switching Fields and Records
138. Playing Audio and Video Files Using the Windows Media Player Control
139. Using Text Files to Write and Read Data
140. Printing USPS Bar Codes on Envelopes
141. Matching Word Document Properties with Access Fields
142. Copying a Template for Use in Mail Merge
143. Archiving Data
144. Automating Access Using Windows Script
145. Matching Access and Outlook Contacts
146. Filtering Reports by Month and Year
147. Confirming Deletion of Linked Records
148. Retrieving Path Information
149. Useful Add-ons, Part 2:  The Access Workbench
150.  Listing Table and Query Fields
151. Updated Database Backup
152. Storing Data in Database Custom Properties
153. Creating a Folder for a Word Letter
154. Getting User Paths and Date Formats for Use in VBA Code
155. The Extras Add-in for Database Backup and Field Listing
156. Saving to PDF in Access 2007
157. Rich Text in Memo Fields in Access 2007
158. Interactive Report Filtering and Sorting in Access 2007
159. Multi-Valued Fields in Access 2007
160. Simple Filters
161. Add-to Combo Boxes
162. Getting Your Add-ins to Work in Vista
163. Sorting Reports by Date
164. Displaying More Information about ListBox Items
165. Recovering from an AutoNumber Disaster
166. The Extras Plus Add-in
167. Complex Query Problems and Solutions
168. Merging Data from Queries and Recordsets to Word
169. Editing Value Lists in Access 2007
170. Mass EMailing of Report Links
171. Linked Listboxes
172. Adding and Deleting Listbox Items
173. Setting the Current Row Back Color
174. Working with Word Document Properties
175. Using the UpDown Control on an Access Form
176. Using the Outlook View Control on an Access Form
177. Writing Data to a Table from a Form
178. Entering Data for a Many-to-Many Relationship
179. Concatenating and Saving Data
180. Working with a Password-Protected Database
181. Working with Progress Bars
182. Custom Navigation Bar
183. Too Many Controls Problem
184. Creating a Word Document with Form Fields
185. Folder Selectors for a Main Menu
186. Controlling One Database from Another
187. An Unbound Combo Box for Selecting or Creating Records on a Subform
188. Working with the New Access 2007 Attachment Field
189. Working with Colors in Access 2007
190. And/Or Filtering and Searching
191. Emailing Custom PDF Reports in Access 2007
192. Creating a Fake Access 2007 Split Form in Access 2003
193. Using Google Maps on an Access Form
194. Currency Formatting on Reports
195. Finding the Nearest Value
196. Access 2007 Multi-valued Fields Revisited
197. Filtering by Multiple Selections
198. Editing Data in Lookup Tables
199. Forcing Zeroes in Reports
200. Exporting Access Data to Excel
201. Colorizing Selected Datasheet Rows
202. Concatenating Name and Address Fields
203. Creating a Log File
204. Creating Future Emails
205. Backwards Compatibility Problem between Access 2010 and 2007
206. Updated Paired Listboxes
207. Archiving Linked Tables to Another Database
208. Dealing with Disabled Databases
209. An Alternate Method for Archiving to Another Database
210. Listing Office Properties
211. Showing and Hiding the Navigation Pane
212. A New Style Main Menu
213. Slide Show Reports
214. Mixing Text and Numbers in a Report Column
215. The Dotted Square Bug
216. Working with Access from Outlook
217. Linking to a Textbox
218. Selecting Countries for a ComboBox List
219. Creating Text Files with Word Info
220. Creating a Set of Records
221. Crosstab Query Reports
222. Calendar Form
223. Select or Filter
224. Printing Selected Record(s)
225. Report Filtering with Combo Boxes
226. An Alternative to the Treeview Control
227. Printing a Filtered Report
228. Exporting Filtered Data to Excel
229. Fixing Normalization Errors
230. Making Concatenated Strings from Linked Tables and Multi-valued Fields
231. Two Handy Procedures
232. Daily Calendar Form
233. Three Calendar Forms
234. Dealing with the "Field Cannot be Updated" Error
235. Dealing with Office Security
236. Table of Contents Report
237. Making an Access Database Taskbar Item
238. Date Filtering for Reports
239. Saving Reports to Folders
240. Emailing Order Lists to Customers
241. Complex Concatenation
242. Advanced Timesheet
243. Formatting Phone Numbers
244. Crosstab Reports, Part 1
245. Listing Used Word Document Properties
246. Crosstab Reports, Part 2
247. SpinButton Control for Selecting Time
248. Filter by Form with Row Source Queries
249. Copy a Record with Calc ID
250. Copy a Record with AutoNumber ID
251. Delete Records in Linked Tables