How to display an ID field in a closed combo box but hide it in a drop-down list. Q: Rich writes that he needs to display an ID field in a closed combo box, but doesn’t want it to appear in the drop-down list. The field is the first one in the combo box’s row […]
A reader suggests another way to convert a numeric option value to text. In AW 7.12 I suggested using the Switch function to convert numeric values from a choice in an option group to text values. Tom Bushaw writes to suggest another possibility, the Choose function. The Choose function yields a value (such as a text […]
The Office Update page of the Microsoft Web site offers a useful toolkit for analyzing databases prior to converting them to Access 2003 format. It is called the Access 2003 Conversion Toolkit, listed under the Add-ins link under the Access 2003 heading on the page. Donn Edwards offers a utility called AccessOpener, which avoids those […]
How to create a file name that includes the date. Q: Steve Mason is trying to export data from a query to an Excel worksheet, and save each exported file with today’s date in the file name, for example qrytest.01/01/2004.xls. How can this be done? A: Slashes in the date won’t work — they are […]
How to successfully merge data from Access to Word. Q: Bruce Michael writes: “I have been attempting to do a merge in Word 2003 using an Access 2003 query. When I look in the query, the data is correct, but when I actually merge using the data, for one column in the database, the values […]