Introduction Back in 2004, I wrote an Access Archon article (Copying Records and Linked Records) that described a method for copying a record with possible linked data in another table, using an array based on form controls. This article describes a different approach, based on table fields rather than form
by Helen Fedemma Introduction Back in 2004, I wrote an Access Archon article (Copying Records and Linked Records) that described a method for copying a record with possible linked data in another table, using an array based on form controls. This article describes a different approach, based on table fields
Introduction Combo boxes are a handy way to select values for various purposes, such as filtering forms and reports. The row sources can be of three types; this article discusses how to select the appropriate type of row source query, and use them to open a filtered report. The Form
If you need to filter by a Text value, such as person’s name or a company name, you may run into this problem: An error caused by an apostrophe in a Text string This is because the apostrophe is a Text delimiter. The way I deal with this problem is
Introduction Recently I had occasion to update an Access database that used a DateTimePicker ActiveX control for selecting times. This control had worked for many years (about 15 years in this case), but stopped working when the user updated to 64-bit Windows 10. I was able to replicate the functionality
Introduction In my Working with Word ebook (the 4th edition is available now), there is code that lists (among other things) the document properties in a Word document. This is useful information, but sometimes you need to know which of the doc properties have actually been used; that is what
If you have a datasheet subform on an Access form, containing numeric data in some columns, you may want to have column totals at the bottom of the datasheet. You can do this easily in an Excel workbook or a Word table, using a formula, but Access does it differently.
Introduction A few years ago, in Access Archon #127, I showed how to make an Access form for entering timesheet data, which was then exported to Excel. That timesheet had combo boxes in the header to select a project and a week, and columns for entering data for the days
In previous Access Archon columns, I have discussed concatenation of dollar amounts (Access Archon #179), or children’s names and school subjects (Access Archon #230). In this article I discuss a more complex type of concatenation, where concatenation is done for sets of records filtered by three values. The Form The
If you have an unbound form, and need a quick and convenient way to write values from its controls to the appropriate fields, instead of listing every field by name, you can use this procedure, based on the assumption that each control that contains a value to be written to
Here is a procedure that will close all open Outlook email messages without saving – very handy if you have just created hundreds of emails testing email creation with the Emailing Order Lists to Customers database: Public Function CloseAllEmailMessages() On Error GoTo ErrorHandler Dim appOutlook As Outlook.Application
By Helen Feddema Access versions: 2007-2013 Level: Intermediate Access Archon #240: Introduction In a database (like the sample Northwind database) that records orders, you might want a quick and easy way to send order lists to customers. This article demonstrates how to send order lists to customers in both Plain
Q: Don Ruppel writes: “I am using Access 2010 to track my collection and have photos attached. I want to filter and list any records that do not have an attachment (photo) so I know which items that need to take photos of. Every time I try to filter the
Q: Jane writes that when she makes a new form by clicking the Form button in the Create tab of the Ribbon, all the controls are the same width, and she can’t resize them individually, as in older versions of Access. A: This is a “feature” of recent versions of
Access Archon Column #237 By Helen Feddema Access versions: 2007-2013 Level: Intermediate The Problem Back in Access 2003 and Windows XP, it was easy to make a shortcut to open a specific Access database – just right-drag the database from an Explorer pane to the Quick Launch area of the
Q: Andy Walter writes: I have been using your Function BackupBackend () for a few years now (Many many thanks) but recently I have had to password protect the backend of my database to stop Mr Sticky Fingers. Unfortunately with the Password in place, I get the following Error. Not
By Helen Feddema Access versions: 2007-2013 Level: Intermediate Introduction Word has a sophisticated Table of Contents feature that automatically creates a table of contents from designated headings in a document. Access reports don’t have such a feature, but I managed to create one using VBA code, custom database properties and
Q: Arne Johnston writes that he has four phone number fields in a table, but that is not enough. How can he handle this better? A: For phone numbers, emails and other IDs, a separate linked table is best. I have one with just three fields: CompanyID (links to the
Access Archon Column #234 By Helen Feddema Access versions: 2007-2013 Level: Intermediate Introduction Sometimes, when working on an Access subform, you will get the “Field Cannot be Updated” error (no error number), generally when typing the first character into a new record: The Help topic for this error is of
The two procedures will let you easily clear up redundant Word documents, and alphabetize lists of declarations. Access versions: 2007-2013 Level: Intermediate Introduction The two procedures described in this article will let you easily clear up redundant Word documents, and alphabetize lists of declarations. When working on the 3rd edition
Q: Susan H. writes that she has some standard code that creates a Word document and puts some Access data into it, using VBA Automation code. But sometimes the Word window is hidden behind other windows, either the Access window itself or some other window. A: This is a long-standing
Q: Lou writes that sometimes when he clicks on a label in Design view, in order to change the caption, it displays with a dark back color, which is disconcerting. The Label control’s BackStyle property is set to Transparent, so it shouldn’t be displaying as a color. How can this
Back in Access 2003, you could easily change the font name and size for a datasheet form by clicking the square in the upper-left corner of the datasheet (in datasheet view), and selecting the font and size from the selectors on the Formatting toolbar, or by selecting Font from the
If you need to create a filter string for filtering by a person’s name, or a city name, you may run into this error: This is because single quotes are used as the delimiter for Text strings, and there is a single quote in the city name. To get around
Like almost any web site, we use technologies like cookies to store and/or access device information. We aim to keep that to a minimum. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions. We apologize for this box but it's legally required in some regions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.