Access: Persistence of Reference Problems
Back in 2002 I wrote an Access Archon article dealing with reference issues, among them the problem of certain references Read 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-2013 Read 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 data Read 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 the Read 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 may Read 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 the Read 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 Back Read 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 Access Read 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 object Read More
Disabling a Label control
Access: Disabling a Label control Q: I need to disable a Label control, for a consistent appearance with some other Read More
Exporting Filtered Data to Excel
Exporting Filtered Data to Excel Access versions: 2007 – 2013 Level: Intermediate In Access Archon #200 (Exporting Access Data Read 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 Style Read 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 backup Read 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 receiving Read 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 be Read 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 has Read 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 data Read 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 is Read More