I have a report in my MS Access contacts database, which filters out just the people that I want to send Xmas cards to. I have a button on my switchboard that I want to be able to click and print the labels. Here is my problem:
Linked to the button is the following (two line) macro:
OpenReport (Report Name: "rpt Xmas Card Labels", View: "Print")
PrintOut (Print Range: "All", Copies: "1")
However, whenever I run the macro, I get a printout of the correct labels, followed by a printout of the entire switchboard. Even if I insert an extra line at the beginning of the macro to close the switchboard, it still prints out the entire switchboard after the labels. I have tried using "Select Object" to specify which form to print, and then it prints the labels, but ends with an error, saying that the object it is trying to print isn't open. Surely this must be a simple enough task! If anyone can point out what I am missing, I'd be grateful. Thanks.
2006-07-17
01:55:01
·
3 answers
·
asked by
Anonymous
in
Software