Access: Persistence of Reference Problems
Back in 2002 I wrote an Access Archon article dealing with reference issues, among them the problem of certain referencesRead More
Microsoft Access
Access: Two Handy Procedures
The two procedures will let you easily clear up redundant Word documents, and alphabetize lists of declarations. Access versions: 2007-2013Read More
Access: Bringing the Word window to the front from code
Q: Susan H. writes that she has some standard code that creates a Word document and puts some Access dataRead More
Access: Back color displayed when none is selected
Q: Lou writes that sometimes when he clicks on a label in Design view, in order to change the caption,Read More
Changing the font size on datasheet subforms
Back in Access 2003, you could easily change the font name and size for a datasheet form by clicking theRead More
Single Quotes in Filters
If you need to create a filter string for filtering by a person’s name, or a city name, you mayRead More
Clearer table formatting than Microsoft auto-format
Some great tips on table formatting. Joey Cherdarchuk has a nice posting on a very different table styling to theRead More
Making Concatenated Strings from Linked Tables and Multi-valued Fields
Access Archon Column #230 – Making Concatenated Strings from Linked Tables and Multi-valued Fields Access versions: 2007-2013 Level: IntermediateIntroduction BackRead More
Fixing Normalization Errors in Access
Access Archon Column #229 – Fixing Normalization Errors Access versions: 2002-2013 Level: IntermediateIntroduction Sometimes when you take over an AccessRead More
Finding the location of the Office object model DLL
Finding the location of the Office object model DLL Q: Frank H. writes: “I want to use the FileDialog objectRead More
Disabling a Label control
Access: Disabling a Label control Q: I need to disable a Label control, for a consistent appearance with some otherRead More
Exporting Filtered Data to Excel
Exporting Filtered Data to Excel Access versions: 2007 – 2013 Level: Intermediate In Access Archon #200 (Exporting Access DataRead More
Access: Printing a Filtered Report
By Helen FeddemaAccess versions: 2007-2013Level: Intermediate The main menu of the sample database for Access Archon #212 (A New StyleRead More
Add-ins with Office 2013 64-bit
by Helen Feddema I recently had occasion to set up a VM with 64-bit Windows 8.1 and 64-bit Office 2013,Read More
SQL Backup and FTP
A simple way to backup your SQL databases and move them offsite. SQL Server from Microsoft has a built-in backupRead More
Putting SuperPAC’s into Excel
How to get detailed SuperPAC donation and spending information into Excel. Today the US Federal Election Commission (FEC) is receivingRead More
Accent characters in Office
How to enter accented characters, grave, circumflex, umlaut etc when they aren’t on the keyboard. Typing accented letters can beRead More
Free manuals for Microsoft Office
Free training manuals for Office 2007 and before plus Quick References for Office 2010. Mouse Training in the UK hasRead More
Exporting Access Data to Excel, Part 1
There are several built-in ways to export Access data to Excel. There are several built-in ways to export Access dataRead More
Fully indexing web code pages
How to index the code on ASP and ASP.net web pages with Windows Search A problem with Windows Search isRead More
Office Watch
Office for Mere Mortals
Twitter
Facebook
Instagram