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
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
How to email attachments using the Redemption Library – and avoid the Object Model Guardian. Mark Riddick wrote in response to Access Archon #114, Avoiding the Object Model Guardian with the Redemption Library, asking how he could email report snapshots using the Redemption Library (he used to do this with
Here’s another way to strip a character from a text string, a simpler alternative to the StripCharacter function. Q: Robert Greiff writes to say that there is a simpler way to strip a character from a text string than the StripCharacter function I described in WAW 4.24. He proposes using
How to suppress the “OpenForm action was canceled” message. Q: Nick Els finds that when he runs a report from a form, even though he has a message on the report’s NoData event, he still gets an annoying error message stating that the OpenForm action was canceled, and he wants
Access Archon #174 Introduction Many of my code samples write data from Access tables or queries to document properties in Word documents. For this technique to work, you have to add the appropriate doc properties to the Word template, which can be a time-consuming process. In this article I
Microsoft has released a set of programming tools to let developers work with Office 2007 documents without the Office applications themselves.click here for more …
How to enable Macros in Office 2007. Q: Marge W. writes that a client called her in panic, saying that “nothing works” in the updated database she just delivered. Upon questioning, it turned out that nothing happened when buttons were clicked on the main menu, and that the client had