Here’s some Explorer-type interfaces for finding records in Access tables. Q: Tom Gerry asks: “Is there any way to create an Explorer style cascading folders user interface to find records in an Access Table?” A: The closest to this would be a TreeView control used as a record selector. I
This article looks at using conditional formatting on a form field. Q: Tim Rundle writes: “I have two fields that form part of a database. Both are numeric. In the forms area I obtain the average of the two fields and show the result as an unbound Field in the
The second part of the article on merging Access data with Word documents. Access Archon #130 The remaining part of the cmdWordDocs Click event procedure is listed below, with the code for the Doc Props, Mail Merge and TypeText methods for merging Access data to Word documents. DocProps: With
How to add a specified number of records to a table. Q: Kacie Anderson writes: “I have two tables, one for Orders and one for Loads and both of which contain an OrderID field to link them together (the OrderID is autogenerated). For each order, there can be multiple loads.
How to generate sequential dates automatically. Q: Richard Bryant writes: “I have made a diary in Access. I enter a month at a time from notes on my calendar. I have to enter each date of the month each time I make an entry. In Excel the dates can be
How to turn off the make-table query warning message. Q: Steve Mason wants to know how to turn off the warning message saying “X table will be deleted” before the query runs. A: Open the Options dialog (Tools|Options) and click the Edit/Find tab. In the Confirm section there are
This shows you how to filter contacts, then merge the filtered records to Word documents. Access Archon #130 Introduction Thanks to John Lehmus for suggesting this article, which combines the fancy filtering of Access Archon #129 with the four types of merging featured in my Code Sample #24, so that
How to change the names for the fields in the column headings. Q: Marlene H. writes: “I want to display more user-friendly names for fields in the column headings for the lists in combo boxes and listboxes – for example, Project Code instead of PrjCode. How can I do this?
Here’s a way around an error that can sometimes occur with the IsLoaded property. Q: Chuck Tucker writes that he is getting an error on the IsLoaded function reference in a code sample from my book, Access 2002 Inside-Out. A: IsLoaded is a function that comes with the Access sample
A reader wants to know where to find Functions information for more recent versions of Access. Q: Marty Nizlek writes: “In Access 97 one could easily find a summary page listing Functions alphabetically. As well, there was the ability in the Builder Wizard to select a function, then hit help,
How to deal with unwanted or redundant indexes. While reading my new book, Expert One-on-One Microsoft Access Application Development, Garry Robinson (see my review of his Access Security book in Access Archon #120) wrote to point out that I didn’t mention that giving fields the suffix “ID” can result in
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
How to rename the column headings for combo box columns. Q: John V. wants to be able to give the column headings for combo box columns the names he wants – not just pick up the field names. A: This can be done by entering the column heading text you
How to format times and/or dates in the way you want to see them. Q: M. Schiller wants to know how to convert a time to the 12 hour time format. A: There is no need to convert – just use the Format function to format dates and/or times in
How to use the AddItem method to transfer data from two fields into a single column in a listbox. Q: Kris Rutko wants to know how to transfer data from two columns of table information into a single column in a listbox, using the AddItem method. A: Save the value
How to make all table records appear in a query regardless of whether they have any linked Extras records. Q: Liz has a query that returns records from a Registration table and an Extras table. She needs the recordset to include all the records in the Registration table regardless of
Making records appear in the order they were entered. Q: Frank Payne writes: “I would like the data in a particular table to appear in exactly the order in which I enter the records. I do not want it sorted in either Ascending or Descending order. I have deleted the
Tips for using dates in file save names. Q: Luis Pelaez writes to say that he is having a problem creating a document save name with a formatted date. A: You can have problems if you use slashes in file names, such as the standard mm/dd/yyyy date format. I use
How to filter a table-type recordset. Q: Mark Jackson writes: “Does anyone have a very complete example of how to open a table type recordset based on a table in the same database? I can’t seem to find what I am missing in my code. I was able to get
Access Archon #152 The Sample Forms The sample database has two forms, frmGetFromDBProps and frmSaveToDBProps. frmGetFromDBProps has an Open event procedure that first clears and then refills a table with the current database properties, and requeries the cboSelectProperty combo box. The txtPropertyValue field displays the property value from the
How to use Access custom database properties to store information in a database, out of sight, but available to your code as needed. Access Archon #152 Introduction Sometimes you may need to store bits of information in a database, out of sight, but available to your code as needed.
Here’s an updated way for you to add backup capability to an Access database. Access Archon #151 Introduction A few years ago, in Access Archon #115, I described a way to create backups of the current database, using several objects that you could import into a database, to make
How to total a calculated field on a report. Q: Marie H. needs a total in a report group footer, based on a calculated field in the report detail section. =Sum([txtWeekTotal]) doesn’t work – how can this field be totaled? A: You can’t total a textbox, but you can total
Here’s where to locate the Access 2007 equivalent of the View Form Header/Footer command. For a while, I couldn’t locate the Access 2007 equivalent of the old View Form Header/Footer command, and finally found it, as a tiny button on the far right of the Show/Hide group on the Layout