Controlling paper size when printing on label by function call



Hello newsgroup,

I'm finally done with my folder-archiving tool, still there are some
flaws.

To label the folders, I use a Dymo LabelWriter 400 printer which works
great for my purposes.

I've created a report to print the labels. When I print (page 1 to 1
as I don't want to print all the records stored in the database) the
report out of the report preview, it prints my label just the way I
wanted to have it.
When I use a function to print the report (DoCmd.OpenReport
report,acViewNormal,,WHERE id = id,,) it suddenly prints the label I
wanted PLUS 3 empty labels, which is - as the Dymo has no reasonable
scrollback function - complete waste of labels.
I have a slight guess about the problem. As four labels would match
for an A4 page, it might be that he's just pulling as many labels as
he needs to fit an A4 page. But this is just a guess. When adding a
thin line it the footer, he prints parts of that thin line over the
last 3 labels.

So, anyone any idea how this weird situation could be solved?

thanks
Thorben Grosser

.



Relevant Pages

  • Mailing List code bug for FredG
    ... address labels and to start at a specific position on the first page. ... Then add a Report Header to the label report. ... Name this control SkipCounter ... then how many times to repeat each label. ...
    (microsoft.public.access.reports)
  • RE: Making a report that can leave records blank based on user inp
    ... > labels but also lets you skip the labels already used. ... > print multiple copies of the same report. ... Set the Height property for both the report header ... >> I am making a database of a large video archive. ...
    (microsoft.public.access.reports)
  • RE: Making a report that can leave records blank based on user inp
    ... I also have a DVD database that I designed in ms Access. ... >> labels but also lets you skip the labels already used. ... >> print multiple copies of the same report. ... Set the Height property for both the report header ...
    (microsoft.public.access.reports)
  • RE: Report Parameters and Filters
    ... also stops two labels of the same value being scanned. ... No the report is not filtered by the printed field, ... So that is why I tried to set the parameters in reports query from controls ... Dim cnn As New ADODB.Connection ...
    (microsoft.public.access.reports)
  • RE: Report Parameters and Filters
    ... also stops two labels of the same value being scanned. ... No the report is not filtered by the printed field, ... So that is why I tried to set the parameters in reports query from controls ... Dim cnn As New ADODB.Connection ...
    (microsoft.public.access.reports)