Here’s a good method for copying values from one record to another, including any linked records. Access Archon #133 Introduction In Access Archon #51, I described how to copy values from one record to another, using hard-coded control names. That method does the job, but it requires a lot of
Several readers have written to recommend using a certain format when date stamping files. In AW 7.04 I recommended date-stamping files using date formats such as “m-d-yyyy” or “d-mmm-yyyy”. The latter is the one I use most frequently, because it prevents confusion as to whether the day or month is
How to place bar codes on Access reports. Q: Keith Hills wants to know if there is a way to place bar codes on an Access report. A: You would need to get a font that can print the bar codes. I have a Zip font, from an installation of
Looks at the different types of item counts you can get for listboxes and combo boxes. Access Archon #132 Introduction Recently I received some emails from AW readers requesting help on counting selections in listboxes and combo boxes. This article deals with the different types of item counts you
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
A reader’s method for calculating total hours. Bill Patterson responded to my request in Access Archon #129for alternate (possibly simpler) methods of calculating total hours. I used a series of calculated fields in a query to do the calculations; by contrast, the Nearest_Time function listed below does all the calculations
How to throw up a flag if someone’s editing an existing record. Q: Julie Garret writes to ask if there is a way to throw up a flag if someone edits an existing record. A: On a bound form, you can use the form’s BeforeUpdate event for this purpose. Here
Working with a combo box record selector. Q: Debbie Sabia writes that she has created a form with a record selector combo box. The end user selects an ID from the combo box and correct data is pulled up on that student. Here’s the problem. When you use the record
How to convert Access data from a newer version so it can be viewed in an earlier version. Q: Linda Vazquez was sent an Access 2003 database, but she has Access 2000. Is there any way to open this database, even just in read-only mode? A: If you have Access
Looks at importing Excel data to Access databases. Q: Graham Alison has two Excel workbooks, and when he imports them into an Access database, he just gets the data, not the formats that make the spreadsheets work. A: Data is all you will get when importing from Excel. If you
Shows some more options that are available to you when using the Printer Object. Access Archon #131 The AssignPrinter procedure given in Part 1 of this article will do fine if you need to ensure that a specific report will always be printed to a specific printer (especially if
How to print a report to a specific printer using the Printer Object. Access Archon #131 Introduction WAW reader Tim H. writes: “Unless my mind is starting to go, I remember being able to select a specific printer for a report in past versions of Access. The report was
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