473,397 Members | 2,077 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

How would you...(report vs numbered copy)

I have a record with with a quantity value. I have to print one record for
each quantiy with a counter, incrmementing on each copy. I wan't to avoid
to use many docmd.openreport instructions.

I succeeded by creating a temporary table, adding by code the job number and
the cumulative quantity value. But I am not satisfied. Is there a way to
do this without a temporary table, from within the report's code only? TIA.
Nov 13 '05 #1
3 1214

Saintor wrote:
I have a record with with a quantity value. I have to print one record for each quantiy with a counter, incrmementing on each copy. I wan't to avoid to use many docmd.openreport instructions.

I succeeded by creating a temporary table, adding by code the job number and the cumulative quantity value. But I am not satisfied. Is there a way to do this without a temporary table, from within the report's code

only? TIA.

One of the arguments of PrintOut is the number of copies you want to
print... just pass that in your print command.

Nov 13 '05 #2
But you won't get an incrementing number on each copy.


<pi********@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Saintor wrote:
I have a record with with a quantity value. I have to print one

record for
each quantiy with a counter, incrmementing on each copy. I wan't to

avoid
to use many docmd.openreport instructions.

I succeeded by creating a temporary table, adding by code the job

number and
the cumulative quantity value. But I am not satisfied. Is there a

way to
do this without a temporary table, from within the report's code

only? TIA.

One of the arguments of PrintOut is the number of copies you want to
print... just pass that in your print command.

Nov 13 '05 #3

Not sure if I understand correctly, but I would probably try to make a loop,
calling the report with an openargument passing the number (newer access
versions only).

Alternatively make an unbound textbox on your form, and change the value
every time before you print the report. In the report reference this control
with something like
=Forms("FormX")![FieldY]
Alternatively, make a public variable in a module (not a form module) and
fill that from your form, and read that from your report (inserting it in
the appropriate place).

Good luck,

Bas.

"Saintor" <sa******@REMOVETHIShotmail.com> wrote in message
news:C_********************@wagner.videotron.net.. .
But you won't get an incrementing number on each copy.


<pi********@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Saintor wrote:
I have a record with with a quantity value. I have to print one

record for
each quantiy with a counter, incrmementing on each copy. I wan't to

avoid
to use many docmd.openreport instructions.

I succeeded by creating a temporary table, adding by code the job

number and
the cumulative quantity value. But I am not satisfied. Is there a

way to
do this without a temporary table, from within the report's code

only? TIA.

One of the arguments of PrintOut is the number of copies you want to
print... just pass that in your print command.


Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Wayne Aprato | last post by:
I have a report that shows the results of a query. One of the fields is an autonumber field from the query which shows for instance: 120, 121 , 122 for 3 records. Is there a way to have another...
7
by: Georges Heinesch | last post by:
Hi. I have a problem with alternating background colors in a report. The code below shows, that the first line should always be white (default global boolean value is false). However it depends...
1
by: VBSponge | last post by:
Hi all. In A2K i have a report with a control bound to to calculate the page count for the report. I need to retrieve this page count from the report, and build it into a TOC containing this an...
2
by: Will | last post by:
I have a 1 page report which I want to print numerous copies of. The number of copies will be specified by the user. My problem is that I want each report to print the copy number of number of...
3
by: Randy Harris | last post by:
I can swear I saw an answer to this a while back but can't locate it. I need to pad lines on a report (print 20 lines, even if there are only 15 records - the last 5 lines blank). Any...
5
by: Mike | last post by:
Hello All, I have a report based upon a query. I have added a control to report footer that calcs the total cost of the inventory: =SUM(). When this total calculation is NOT on the report,...
0
by: Bob | last post by:
Hi all, Using an embedded report, I suddenly started getting the message Report blah is ambiguous in namespace widget. (Or words to that effect). Expanding the report object showed it had another...
4
by: Bruce | last post by:
Surely someone has done this before, and I am guessing there is a simple solution that is eluding me. I have a simple report based on a recordset. For each record there is a field (RecNum) that...
12
by: Studiotyphoon | last post by:
Hi, I have report which I need to print 3 times, but would like to have the following headings Customer Copy - Print 1 Accounts Copy - Print 2 File Copy -Print 3 I created a macro to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.