How to merge data from linked tables Q: Lisa Hartley writes: I’m planning to use the code in code2.zip to merge data from Access into word documents. Could you please give a couple lines of sample code which would tell me how to get data from a related table. In other words I have: Table […]
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 […]
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 all of them. How can […]
How to use Access 2007’s new “multi-valued fields” feature. Access Archon #159 Access 2007 has a new feature for fields: one field can now hold multiple values. This feature is called “multi-valued fields,” and is implemented by creating a field with the Lookup Wizard. On the first screen of the Wizard, select the I want […]
How to make one cell in a datasheet subform a different color than the others using conditional formatting. Q: Rosie W. writes to ask if there is any way to make one cell in a datasheet subform a different color than the others. This control is locked, and she wants it to be a different […]
