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 example, output a query as […]
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 are looking for a code […]
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 with conform dates but this […]
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, Outlook 2003 and before. click […]
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 form (shown in Figure D) […]