probably a stupid question

[aliceelizabeth]

hello, firstly apologies if this is painfully obvious as I have been clicking through menus for an hour unable to solve the quandary.

I am using a database that was designed by my predecessor.

she set it up to automatically print multiples of each report - but I only want one of each

how do I reset this so that it only prints one? I have been simply telling my printer to print 1-1 for the past few months and it's getting silly, any indicators much appreciated

Alice

 

[Galaxiom]

No such thing as a stupid question. Just stupid answers.

Somewhere in the VBA code there will be something that makes multiple copies. Put the report into design view and find the procedure that makes the report print. Post that procedure here.

 

[aliceelizabeth]

I think I just worked it out - such an indescribable numpty

she simply had two pages on the report. one after the other, so I deleted the page below and moved the margins - tada

sorry about that

 

[Galaxiom]

Well done Alice and welcome to the forum.

You have done everything right, especially posting your solution. There are many ways to do just about everything and those who come along after our original conversation need to think of every possibility.