Print Access 97 Mailing Labels in the "middle" of a sheet of label

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I start printing mailing labels in the "middle" of a sheet of Avery
labels for an Ink Jet printer?
 
Thank You for your reply.

I do not have the ability to do any programming within Access. I was hoping
that there was some addition or upgrade to Access 97 to specify where (which
label position) it should start printing on a sheet of labels.

Is this capability available in newer versions of Access? Where can I find
a list of the differences between "97" and the current version?

If I turn the partial sheet of labels around (top to bottom), is their
someway to "tell" Access to temporarily print the first "x" number of records
in the current query to complete that sheet. Then, after that, "tell" it to
start printing at the "x+1" record for the remainder of the records to the
subsequent full sheets?
 
The only way to do this in the newer versions is to manipulate the events -
same as A97.
 
Allen Browne said:
The only way to do this in the newer versions is to manipulate the events -
same as A97.
Click to expand...

[snip]

Here is what I do. My label sheet contains 15 labels. I created a table with
one field (numeric) and 14 entries (the numbers 1 to 14). I then created a
union query where the first 14 rows are blank fields except for the values 1 to
14 in the [LabelPosition] field and all of the rows after that is my data that I
want to print on the labels all having the value 15 in the calculated field of
[LabelPosition]

With this set up it is a simple matter to open the report with a filter of
"LabelPosition > 5" and the printing will then begin on the 6th label position
on the first sheet (for example). This offset only affects the first sheet. I
provide a small GUI of the 15 label sheet on the screen where the user can click
on the first label position they want to use. I even tell them how many label
sheets to load into the printer based on this selection and the total number of
records to be printed.\

The only code is to set a public variable to the "less than" value that the
filter uses, but even that could be a form reference to a hidden control.
 
Once again, "Thanks a million",

One final question (I hope) --

Are there any known problems with Access 97 and the other Office 97
components after installing MS's "Service Pack 2" for my Windows XP
Professional? I haven't done that yet, because I'm concerned about "losing"
Office 97 after installing the SP2.
 
No problem. I'm using Access 97 (as well as other versions) on Windows XP
SP2, both Home and Pro versions.
 
Once Again, A Very Big "Thank You".

I have the CD for SP2 and am now willing to use it. I was concerned that
Office 97 might be "too old" for SP2.
 
Back
Top