Search results

In fact I removed the table that was in both queries, and instead populated the fields (that I thought I needed the duplicated table for) using Allen Browne's ELookup

In fact I find that when I am able to stop Access from having a fit the report still duplicated

Thanks Pat. I Think your suggestion is working but can't be sure because when I open the report, Access cracks a hissy fit and I have to shut it down.

In Access 2010 I have a Sub-report embedded in a Report. The sub-report works fine. The problem is that if there is 5 records in the sub-report I get 5 versions of the Main Report. My user has a work around, he just tells the printer to print page 1 only. That's coolbut I want to (know how to)...

Thanks - do hope you find the Code you mention.

I was going to set up a client who wants to print labels to go on swing tags, using the Avery Wizard but instead they wish to use the above Dymo product as it eliminates the wastage of printing an entire page involved with Avery. Has anybody done this/Can anybody help with appropriate VBA code?

Hi All, just joined today. I am an experienced Amateur Programmer from Melbourne, Australia, having learned VBA from "VBA for Dummies". I not only want to pick up a few pointers from the Forum but also to contribute from what I have learned thus far.