Search results

The easiest way to debug these type of errors is to add a bookmark to the code. When it breaks during execution, walk through it a line at a time and see where the logic takes you, and what exactly is in the variables. The immediate window is useful for evaluating logical expressions and Domain...

Since you are using debug.print, I assume you are familiar with the Immediate Window in the VBA IDE. If you are unfamiliar with the Locals & Watch windows in the view menu, take the time to browse Access help on how to set them up and use them. One or both may do exactly what you need without...

In Access 2002 & later, there is a new printer object model. You can set any propperties and use any printer you like (we do it here all the time). Here is a link to the MS documentation, code samples, and sample database downloads: http://msdn.microsoft.com/en-us/library/aa139946(office.10).aspx

You get six because that is how many records are returned by the recordsource. If the records truly are duplicates, then this, from Access help, may be of use: