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 all of the items were […]
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 = 0 Then FindZip = […]
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 piece of music or 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 WOPR Word add-on, that […]
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 rst Do While Not […]
