Recent content by djh57

I have a report that is one page per unit. I need to merge this with a letter Word Document so that I get one copy of the letter for each report page as follows letter/report/letter/report ..... Unfortunately most of the merge examples in the help or Technet seem to be pretty basic. Thanks.

I have a report that is one page per unit. I need to merge this with a letter Word Document so that I get one copy of the letter for each report page as follows letter/report/letter/report ..... I need to do this from VBA and have found a way to get the name and address into the letter...

Fixed. It was nothing to do with form, but a query that had been renamed.

The macro has only one line OpenReport with a report name and view. The only other information available is that the error comes up with an Action Failed box. Macro Name - Run Totals by HS Condition - True Action Name - OpenReport Arguments - Total by HS, Print Preview,,

I have been passed an application that used to run on Access 95. I have converted it to Access 97. The following line produces an error DoCmd.RunMacro "Run Totals by HS" Run-time error '2465' Microsoft Access can't find the field 'Forms' referred to you in your expression. The macro runs a...