Charles Hui writes: After reading your article “ACCESS Archon Column #44 – Merging to Word from Linked Access”, I have expanded my WORD template to include a table and have successfully created letters using custom doc property and table together. In our letters, the fixed Borrower Name and Address are
How to make one cell in a datasheet subform a different color than the others using conditional formatting. Q: Rosie W. writes to ask if there is any way to make one cell in a datasheet subform a different color than the others. This control is locked, and she wants
How to use Access 2007’s new “multi-valued fields” feature. Access Archon #159 Access 2007 has a new feature for fields: one field can now hold multiple values. This feature is called “multi-valued fields,” and is implemented by creating a field with the Lookup Wizard. On the first screen of the
How to list detail items on a report in the order they were entered. Q: Scott Campos writes: “I want the invoice report to print in the same order as is entered on the order form. This makes it much easier to manually double check an order to make sure
Access Archon #144 The following sample VBS program will show how to extract these values: Option Explicit Function FindZip (Str) Dim re, Matches Dim Zips(2) Set re = New RegExp re.Pattern = “((d{5})(-(d{4}))?)” Set Matches = re.Execute (Str) If Matches.Count =
Playing audio and video files using the Windows Media Player Control. Access Archon #138 Introduction Since the earliest days of Access, you have been able to sound a beep from Access code, or a macro (the code is simple: DoCmd.Beep). But if you want something more sophisticated, say playing a
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
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
A reader’s having problems setting margins to very small. Q: Robert Byrne writes: “I am using Access 2000 to create signs. It’s similar to a mail merge. I have a database with product information and create signs 5.5 x 4.25. It all works great except Access won’t let me change
How to display data from other fields in the same record that’s selected in a combo box. Q: Robert Colum wants to know how to display data from other fields in the same record that is selected in a combo box. A: This can be done easily using the Column
Here’s a code that attaches a saved file to an outgoing fax, using a DDE command. In response to Access Archon #112 (Faxing from Access with WinFax using DDE), Susan S. writes that she needs to fax files as attachments. This can also be done in code. You could, for
Here are a couple of codes for passing parameter values to a query. Q:Michael O’neill Johnston wrote to ask how to pass a variable (created from a value in a table field) to a parameter query. A:There are many ways of passing a parameter value to a query. If you
How to stop Access auto-correcting your typing when you don’t want it to. Q: Maryann S. writes: “My application uses a number of two- or three-letter codes as field values. Sometimes, when I type one in, it changes to something else (for example, HGE changes to HE). How can I
Adding and subtracting dates. Q: Martin writes: I have these records written in two lines (dates, without separation in the European style (1030)) 051007 051107 I then want to take the dates and subtract the dates from each other and get how much time has passed. An easy task
How to view the ‘raw’ email message header in Outlook. Most of the time all you need is the basic message information – From, To and Subject but occasionally you need to dig a bit deeper into the ‘raw’ email message header. Here’s how to do it in Outlook 2007,
More on how to merge data from recordsets and queries to Word documents. Access Archon #168 Creating Queries on-the-fly for Filtering Data If you need to send letters to customers, and want the option of filtering by any country, not just the ones with the most customers, the frmMergeToWordDocProps
How to generate random numbers. Q: Bob wants to know if there is some way to generate random numbers within a certain range (he needs to fill a field in a table with sample values). A: Yes, there is an Rnd function you can use for this purpose. It returns
How to filter reports. Q: Sandy Salas writes to ask: I have a report that has several fields on the report that could be used as a filter. … Phase, Priority, Grouping, Open, Division… I may not use all of the filters might only need the first 2 but possible
How to write long strings to an InputBox. Q: Peter Matthews writes that help for the InputBox says it will input the user’s string, and the definition of a (variable length) string says it can be up to 2 billion characters. So how come my VBA called out InputBox won’t
Looks at a method that’ll often fix a problem that’s resistant to all other repair methods. Q: Harold Lewton writes: ” I have 1 database file that works perfectly in Access 2000 and partially in Access 2003. In Access 2003 it works fine while in the Access program itself until
How to export information from a current record of an Access form to make a new Outlook appointment. Q: Martin Wichmand writes: “In my planner I have a Subject, Startdate, StartTime and Endtime. Normally I import those to Outlook via the slow and manual way. But I wonder if it
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 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?
Some code or query expressions that were working have stopped – here are the updated applications. Recently, I have had to modify several Access 2000 applications that are currently running in Access 2002 or 2003 because code or query expressions that used to work have stopped working. The problems are
