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
How to sort reports by date in Access. Access Archon #163 Introduction If you have a report with a date field, you may need to sort the report by date, and Access has a built-in feature that lets you do date sorting very easily, without preparing a query in advance,
Access 2007 has a new Report view which implements interactive sorting and filtering. Access Archon #158 Access 2007 has a new Report view for reports, which implements a long-requested feature: interactive sorting and filtering. To use this feature, select the Report view for a report: Figure A. The new Report
Here’s where to locate the Access 2007 equivalent of the View Form Header/Footer command. For a while, I couldn’t locate the Access 2007 equivalent of the old View Form Header/Footer command, and finally found it, as a tiny button on the far right of the Show/Hide group on the Layout
Access Archon #144 Introduction I was recently given an assignment. The client needed to extract information from several log files and put them into a format that would expedite ad-hoc analysis. These log files were in several different folders, and were generated at several times during the day. They wanted
Use this technique to switch fields to records. Access Archon #137 Introduction Ray Wright wrote to me to ask how he could convert a table with over 100 questionnaire fields to a more manageable format, with the fields converted to records in a table, to make it easier to tabulate
Here’s a good method for copying values from one record to another, including any linked records. Access Archon #133 Introduction In Access Archon #51, I described how to copy values from one record to another, using hard-coded control names. That method does the job, but it requires a lot of
This shows you how to filter contacts, then merge the filtered records to Word documents. Access Archon #130 Introduction Thanks to John Lehmus for suggesting this article, which combines the fancy filtering of Access Archon #129 with the four types of merging featured in my Code Sample #24, so that
How to export contacts from an Access table to an Outlook folder. Q: Farouk Dawood has written code to export contacts from an Access table to an Outlook folder, using the CreateItem(olContactItem) syntax, but it isn’t working – the new contacts are being created in the default local Contacts folder
Here’s a brief overview of my latest book, Expert One-on-One Microsoft Access Application Development. I wrote my latest book (Expert One-on-One Microsoft Access Application Development, Wrox) for experienced Access users, who know how to create tables, queries, forms and other Access objects, and have some familiarity with writing Access VBA
How to suppress printing of a record or a control on a report. Q: Luis Pelaez is looking for a way to suppress printing of a record on a report if the Balance Due field is zero. A: If you wish to just suppress printing of one or more controls,
How to change the Overtype mode in text boxes to Insert mode. Q:John Lawrence is frustrated with the Overtype mode in Access text boxes, and wants to know if it can be changed to Insert mode. A:Yes, this can be changed in the Options dialog. Click the Keyboard tab, then
