How to use Rich Text in memo fields in Access 2007. Access Archon #157 Introduction Over the years, the functionality of Access forms and reports has been significantly upgraded. In Access 2007, one long-requested feature has finally arrived in a workable form (I recall an early and unreliable implementation that made a brief appearance in […]
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 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 a Single value, so you […]
