Access: Specialty Combo Boxes, Part 2
This article describes several more variations of combo boxes, making them even more useful. Linked Combo Boxes You can use Read More
Helen Feddema
About Helen Feddema
Posts by Helen Feddema:
Access: Specialty Combo Boxes, Part 1
A regular combo box that gives you a choice of an item from a list (usually displaying items from a Read More
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
Scheduling an Access Task
Introduction If you need to print a report, or do some other Access task, on a regular basis, you can Read More
Copy a Record with AutoNumber ID
Introduction Back in 2004, I wrote an Access Archon article (Copying Records and Linked Records) that described a method for Read More
Delete Records in Linked Tables
Introduction If you want to delete a record in a form bound to a single table that is not linked Read More
Copy a Record with Calc ID
by Helen Fedemma Introduction Back in 2004, I wrote an Access Archon article (Copying Records and Linked Records) that described Read More
Filter by Form with Row Source Queries
Introduction Combo boxes are a handy way to select values for various purposes, such as filtering forms and reports. The Read More
Apostrophes in Text strings used for filtering
If you need to filter by a Text value, such as person’s name or a company name, you may run Read More
SpinButton Control for Selecting Time
Introduction Recently I had occasion to update an Access database that used a DateTimePicker ActiveX control for selecting times. This Read More
Listing used Word Document Properties
Introduction In my Working with Word ebook (the 4th edition is available now), there is code that lists (among other Read More
Access Datasheet Column Totals
If you have a datasheet subform on an Access form, containing numeric data in some columns, you may want to Read More
Access error 5152 and how to avoid it
If you get Error #5152 when running code that saves a file, check whether there is a date formatted with Read More
Access Macro Import Error
If you import a macro from an Access 2010 or 2013 database into an Access 2007 (or earlier) database, it Read More
Advanced Timesheet with Access
Introduction A few years ago, in Access Archon #127, I showed how to make an Access form for entering timesheet Read More
Complex Concatenation in Access
In previous Access Archon columns, I have discussed concatenation of dollar amounts (Access Archon #179), or children’s names and school Read More
Grey bands on an Access report
Q: On one of my Access reports, strange light grey bands print here and there. What causes them, and how Read More
Access: Emailing Order Lists to Clients
By Helen FeddemaAccess versions: 2007-2013Level: IntermediateAccess Archon #240: Introduction In a database (like the sample Northwind database) that records orders, Read More
Access: Filtering for records without attachments
Q: Don Ruppel writes: “I am using Access 2010 to track my collection and have photos attached. I want to Read More
Access: Control position problems
Q: Jane writes that when she makes a new form by clicking the Form button in the Create tab of Read More