Version 10 of Total Access Analyzer is out now, ideal for anyone who develops in Access. FMS has released v. 10 of Total Access Analyzer, the premier product for analyzing Access databases. This version supports Access 2002, both for Access 2000 and Access 2002 formatted databases. Track down those unused
How to customise the captions on MessageBox buttons. Q:Piet Boden wants to know if it is possible to change the text displayed on the buttons in a MessageBox.A: Not on a message box produced by the MsgBox function, though you do have a choice of various buttons. You will need
How to print envelopes directly from Access. Q:Jim Coxon writes: “What I need to do is to print envelopes directly from Access. i.e. Customer rings up for tickets, agent enters details into Access using a form, form is printed, agent puts tickets into envelope. If we could print the envelope
A reader offers this great tip to save time when creating new databases. Chuck Roberts writes with a suggestion that saves time when creating a new database: I frequently make new databases. So I created a blank database with a template form, a template report, and all my standard subroutines.
How to get calculated fields to display zero. Q: Rob Stoker writes: I have a calculated field which is sum([nettprice]*[quantity]) which works ok. However if there is no data then it displays #Error. I have tried the Nz function, and tried the IIf function but I can’t seem to stop
Information on an unpatched security glitch in Word 2002 (Office XP). Microsoft has disclosed a unpatched security glitch in Word 2002 (Office XP) only,click here for more …
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
