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 view in Access 2007 In […]
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 tab of the Form Tools […]
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 to be able to go […]
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 the data. It is indeed […]
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 editing to make it work […]