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 […]
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 you can filter contacts in […]
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 instead. What is the syntax […]
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 code, but need help in […]