Thread: Label
View Single Post
  #2  
Old June 22nd, 2004, 02:26 PM
Jackie L
external usenet poster
 
Posts: n/a
Default Label

I do not know what your key fields are but I would put an unbound box on your form where you could input the number of used labels (from the first sheet), then create a loop statement to put that number of "blank" records into a temp table. Your temp table should be created with an autonumber as key, add the new records, then append your actual records to the temp table and print from there. Primary sort being the autonumber.

Hope this helps.

"SRIT" wrote:

Okay, this is a weird question, but right now, I have a
database which prints out labels for specified events
based on certain criteria. A report is generated which
contains a layout of twelve labels which I created
myself. I did not use the label wizard. I manually
created a nice layout for the tapes which is tiled out 12
times going across and then down the page. The report is
printed on label paper. Up to this point everything
works fine.
Okay, this is a weird question, but right now, I have a
database which prints out labels for specified events
based on certain criteria. A report is generated which
contains a layout of twelve labels which I created
myself. I did not use the label wizard. I manually
created a nice layout for the tapes which is tiled out 12
times going across and then down the page. The report is
printed on label paper. Up to this point everything
works fine.
But let's say I have a half-used page from a job I did a
few days ago. How can I make the report only print on
the bottom half of that first page and then move on to
the top of the next page?
Okay, this is a weird question, but right now, I have a
database which prints out labels for specified events
based on certain criteria. A report is generated which
contains a layout of twelve labels which I created
myself. I did not use the label wizard. I manually
created a nice layout for the tapes which is tiled out 12
times going across and then down the page. The report is
printed on label paper. Up to this point everything
works fine.
But let's say I have a half-used page from a job I did a
few days ago. How can I make the report only print on
the bottom half of that first page and then move on to
the top of the next page?
Okay, this is a weird question, but right now, I have a
database which prints out labels for specified events
based on certain criteria. A report is generated which
contains a layout of twelve labels which I created
myself. I did not use the label wizard. I manually
created a nice layout for the tapes which is tiled out 12
times going across and then down the page. The report is
printed on label paper. Up to this point everything
works fine.
Okay, this is a weird question, but right now, I have a
database which prints out labels for specified events
based on certain criteria. A report is generated which
contains a layout of twelve labels which I created
myself. I did not use the label wizard. I manually
created a nice layout for the tapes which is tiled out 12
times going across and then down the page. The report is
printed on label paper. Up to this point everything
works fine.
But let's say I have a half-used page from a job I did a
few days ago. How can I make the report only print on
the bottom half of that first page and then move on to
the top of the next page?
Since I started out not using the label wizard, is there
a way that I could create a layout for the label wizard
which would work better than what I'm doing right now?
Thank you very much!

But let's say I have a half-used page from a job I did a
few days ago. How can I make the report only print on
the bottom half of that first page and then move on to
the top of the next page?
Since I started out not using the label wizard, is there
a way that I could create a layout for the label wizard
which would work better than what I'm doing right now?
Thank you very much!

Since I started out not using the label wizard, is there
a way that I could create a layout for the label wizard
which would work better than what I'm doing right now?
Thank you very much!
Since I started out not using the label wizard, is there
a way that I could create a layout for the label wizard
which would work better than what I'm doing right now?
Thank you very much!
But let's say I have a half-used page from a job I did a
few days ago. How can I make the report only print on
the bottom half of that first page and then move on to
the top of the next page?
Since I started out not using the label wizard, is there
a way that I could create a layout for the label wizard
which would work better than what I'm doing right now?
Thank you very much!







Okay, this is a weird question, but right now, I have a
database which prints out labels for specified events
based on certain criteria. A report is generated which
contains a layout of twelve labels which I created
myself. I did not use the label wizard. I manually
created a nice layout for the tapes which is tiled out 12
times going across and then down the page. The report is
printed on label paper. Up to this point everything
works fine.
Okay, this is a weird question, but right now, I have a
database which prints out labels for specified events
based on certain criteria. A report is generated which
contains a layout of twelve labels which I created
myself. I did not use the label wizard. I manually
created a nice layout for the tapes which is tiled out 12
times going across and then down the page. The report is
printed on label paper. Up to this point everything
works fine.
But let's say I have a half-used page from a job I did a
few days ago. How can I make the report only print on
the bottom half of that first page and then move on to
the top of the next page?
Okay, this is a weird question, but right now, I have a
database which prints out labels for specified events
based on certain criteria. A report is generated which
contains a layout of twelve labels which I created
myself. I did not use the label wizard. I manually
created a nice layout for the tapes which is tiled out 12
times going across and then down the page. The report is
printed on label paper. Up to this point everything
works fine.
But let's say I have a half-used page from a job I did a
few days ago. How can I make the report only print on
the bottom half of that first page and then move on to
the top of the next page?
Okay, this is a weird question, but right now, I have a
database which prints out labels for specified events
based on certain criteria. A report is generated which
contains a layout of twelve labels which I created
myself. I did not use the label wizard. I manually
created a nice layout for the tapes which is tiled out 12
times going across and then down the page. The report is
printed on label paper. Up to this point everything
works fine.
Okay, this is a weird question, but right now, I have a
database which prints out labels for specified events
based on certain criteria. A report is generated which
contains a layout of twelve labels which I created
myself. I did not use the label wizard. I manually
created a nice layout for the tapes which is tiled out 12
times going across and then down the page. The report is
printed on label paper. Up to this point everything
works fine.
But let's say I have a half-used page from a job I did a
few days ago. How can I make the report only print on
the bottom half of that first page and then move on to
the top of the next page?
Since I started out not using the label wizard, is there
a way that I could create a layout for the label wizard
which would work better than what I'm doing right now?
Thank you very much!

But let's say I have a half-used page from a job I did a
few days ago. How can I make the report only print on
the bottom half of that first page and then move on to
the top of the next page?
Since I started out not using the label wizard, is there
a way that I could create a layout for the label wizard
which would work better than what I'm doing right now?
Thank you very much!

Since I started out not using the label wizard, is there
a way that I could create a layout for the label wizard
which would work better than what I'm doing right now?
Thank you very much!
Since I started out not using the label wizard, is there
a way that I could create a layout for the label wizard
which would work better than what I'm doing right now?
Thank you very much!
But let's say I have a half-used page from a job I did a
few days ago. How can I make the report only print on
the bottom half of that first page and then move on to
the top of the next page?
Since I started out not using the label wizard, is there
a way that I could create a layout for the label wizard
which would work better than what I'm doing right now?
Thank you very much!