Re: Printing labels?

If your report is printing all of the addresses for the currently selected
person, you have the child alias selected. It sounds like the report is
running through the entire child parameterized view.

Add NEXT 1 to the REPORT FORM command. That only prints the current record.

You can certainly hard-code SET PRINTER TO (name of printer), although what
happens when the user changes the name of the printer?

Dan

Linn Kubler wrote:
Hi All,

I am trying to put together a simple label printing program but, of
course, am having a small problem(s). I have my data setup following
a previous post on relating views. I have a view with names and I
use the selected name to then query another view for addresses. Each
name may have more than one address.

In the second view I select the address I am interested in and have
defined a report with the layout that I want. Problem is that if I
print someone with more than one address all their addresses are
printed, not just the address I selected. Anyone know of any
examples of how to do this? Or a better approach I should be taking?

I thought about using scatter to an object but then I didn't know how
to reference that object in the report designer. I'm thinking it is
a scoping issue, I don't quite know how to make the scattered object
global.
To print the labels we have a fancy thermal label printer with 4" x 5"
labels. I've only been using the print preview so I don't know if it
will work for sure or not. With that in mind, is there anyway to
hard code the printer so that the user doesn't have to select it each
time?
Also, we want to print only one label at a time, not a set of
records, just the person and address combination the user selects.

Hope all this makes sense and that someone can offer some
suggestions. I'm using VFP 9.0sp1 btw.

Thanks in advance,
Linn


.

Relevant Pages

  • Re: Determine copy number within Report
    ... Add a page break after each page and repeat the invoice as many times as ... In other words, if it is a 3 page invoice, make a 3 page report. ... Use something similar to printing multiple copies of the same label to ...
    (microsoft.public.access.reports)
  • Re: print of report is different than preview
    ... The knoweldgebase article you referred to works for a single-page report. ... However, it does not work if you are printing reports that spill over onto several pages, unless you actually print all the pages. ... Print a Quantity of a Label ... the first label and not as the preview showed. ...
    (microsoft.public.access.reports)
  • Re: Fields in Label dont give correct information
    ... tables where the data was stored in the query the query would not run. ... half the time with very few errors (other than that label problem I had.) ... report all of the information shows up on the report the way I want it to. ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Desperate! Pagination problem
    ... The label textboxes in the subreport were getting split across the page ... because sometimes there is no user data for that label and we don't want the ... When I run Access 2000 next to Access 2003 for the same data, same report, ... There are textboxes in the Subreport1 Detail that function as labels for the ...
    (microsoft.public.access.reports)