two copies of same report on 1 page

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

Guest

i made a check voucher slip (report) on the upper half of a letter-sized
paper. i wanted to make an exact copy of it on the other lower half of the
same paper to serve as a duplicate copy to be filed. and maybe put a dotted
dash bar in between them as a scissor way.

my problem is, how would i do that. how would i make an exact duplicate to
be place on the other lower half of the paper?

thank you for the time.
 
wendell said:
i made a check voucher slip (report) on the upper half of a
letter-sized paper. i wanted to make an exact copy of it on the
other lower half of the same paper to serve as a duplicate copy to be
filed. and maybe put a dotted dash bar in between them as a scissor
way.

my problem is, how would i do that. how would i make an exact
duplicate to be place on the other lower half of the paper?

thank you for the time.
Click to expand...


It's very difficult to answer this problem.
It's heavy for you to get the answer.
I can tell you it, but after J have to kill you...
To you the choise... if you choise not pass to another post...

Are you still reading, ok. But you know what follow it
Are you ready?

Copy/paste

;-P
--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it
 
MA said:
It's very difficult to answer this problem.
It's heavy for you to get the answer.
I can tell you it, but after J have to kill you...
To you the choise... if you choise not pass to another post...

Are you still reading, ok. But you know what follow it
Are you ready?

Copy/paste

;-P
--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it
Click to expand...

Dear Mr. MA , I really appreciate your suggestion. It really shows how deep
is your knowledge of access reports.
I'll check your former answers in order to find others important tips!
I only hope not to be killed after reading 'em.


p.s. I also appreciate you are improving your english, next time at CISA you
will interview Mike Davis personally and I'll be glad to hear you.
 
Wendell,

Copy all of the controls that you want to be duplicated, and then paste and
move them to where you want them to appear on the lower half of the page.
 
I would create another report and paste the current report twice on the new
report. This method would require you to only maintain one copy of your
controls.
 
Dear Mr. MA , I really appreciate your suggestion. It really shows
how deep is your knowledge of access reports.
I'll check your former answers in order to find others important tips!
I only hope not to be killed after reading 'em.


p.s. I also appreciate you are improving your english, next time at
CISA you will interview Mike Davis personally and I'll be glad to
hear you.
Click to expand...

;-P

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it
 
Duane said:
I would create another report and paste the current report twice on
the new report. This method would require you to only maintain one
copy of your controls.
Click to expand...

what's your gain?
In any case you will have 2 object.
The only gain could be for further modification of any control, ma in that
case you will copy and past again everything
and you'll be ok


--
Duane Hookom
MS Access MVP

"wendell remolador" <wendell (e-mail address removed)>
wrote in message
Click to expand...

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it
 
wendell remolador" said:
i made a check voucher slip (report) on the upper half of a letter-sized
paper. i wanted to make an exact copy of it on the other lower half of the
same paper to serve as a duplicate copy to be filed. and maybe put a dotted
dash bar in between them as a scissor way.

my problem is, how would i do that. how would i make an exact duplicate to
be place on the other lower half of the paper?
Click to expand...


If the report has no grouping, then the idea of just
duplicating the controls will work. If you do use grouping
then it gets more complicated.

If for some reason, the report has a page header/footer,
then I don't think you can do it within the report without
replacing the page section with something else.

Bottom line is that we need some specific details about the
report before coming up with a specific recommendation.
 
A possibility is FinePrint from www.fineprint.com. This software operates
as a Postscript printer driver and "intercepts" your output (you set *it* as
the printer --- and after it does it's stuff, the output finally gets
printed). I've used this for different situations (not exactly yours) and
it may be able to handle what you're trying to accomplish. There's a freee
dornload you can test with and if youo purchase it, the cost is about
$40-$50... Bob.
 
The gain is that when you want to adjust the control in the voucher, you
only maintain one copy. If you prefer to maintain two copies of the exact
same information then do it.

I attempt to "normalize" all objects in Access including code, forms,
reports, queries,... I try to avoid repeating controls, code, queries,
fields, tables,...
 
Duane said:
The gain is that when you want to adjust the control in the voucher,
you only maintain one copy. If you prefer to maintain two copies of
the exact same information then do it.

I attempt to "normalize" all objects in Access including code, forms,
reports, queries,... I try to avoid repeating controls, code, queries,
fields, tables,...
Click to expand...

Probably your are right, in special mode if you need to have 3 copy of same
report.


--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it
 
wendell said:
the outcome in preview mode would look like this...
http://www.geocities.com/wendellremolador/voucher2.jpg

pls take note that the detail section can contain 3 or more entries.
i will still be adding the manager's signature below chech/account# and the
scissor line.
Click to expand...


Well that is a little tricky. Let's start by creating a
little table named Copies. Add one field named Num to the
table, no need for anything else. Save the table's design,
then open the table and add two records with 1 and 2 in the
Num field.

Create a new report and set its record source to the Copies
table. No headers and no footers.

Now drag your existing report into this new report's detail
section. Make sure the height of the subreport **control**
in the new main report is about half a page and set it's
CanGrow and CanShrink properties to No.

Run the report. You should get two copies, one above the
other.
 
wow. like magic. its really a nice trick.

http://www.geocities.com/wendellremolador/voucher3.jpg <-- result

thank you thank you thank you very very much. it didnt cost a sweat at all.

Marshall Barton <-- my new guru. hehe.

sir Barton, one more thing, how did u know that trick? i cant seem to find
it in the help file. :) though i depend mostly on that. i could use that
trick in some of my other access files. :D
 
Marshall said:
Well that is a little tricky. Let's start by creating a
little table named Copies. Add one field named Num to the
table, no need for anything else. Save the table's design,
then open the table and add two records with 1 and 2 in the
Num field.

Create a new report and set its record source to the Copies
table. No headers and no footers.

Now drag your existing report into this new report's detail
section. Make sure the height of the subreport **control**
in the new main report is about half a page and set it's
CanGrow and CanShrink properties to No.

Run the report. You should get two copies, one above the
other.
Click to expand...

very smart, repeat it with unbounding...
;-)

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it
 
wendell said:
wow. like magic. its really a nice trick.

http://www.geocities.com/wendellremolador/voucher3.jpg <-- result

thank you thank you thank you very very much. it didnt cost a sweat at all.

Marshall Barton <-- my new guru. hehe.

sir Barton, one more thing, how did u know that trick? i cant seem to find
it in the help file. :) though i depend mostly on that. i could use that
trick in some of my other access files. :D
Click to expand...


Very glad to hear the report is working for you.

How'd I know that trick? I guess it's mostly just a matter
of combining all kinds of basic features into new
situations. Kind if like inventing a new device using
off-the-shelf parts ;-)

Spending too much time hanging out in these newsgroups and
twelve years of experience using Access helps too ;-)
 
It's all "cartesian" thought processes.

Picture a query design view. Add all your tables of Access knowledge into
the top pane. This would be sql, reports, etc tables. Don't add any join
lines since this "limits" results. Drop the knowledge field from each table
into the grid. In the criteria, add the requirements like "duplicate",
"Report", "subreport", "Control C", ...

Then run the query to view the datasheet. You may be overwhelmed by the
number of returned "records". You may have to go back to the design view and
add more criteria. View the datasheet again and read across in a row to see
if there is a solution that will work.

If there is not a solution that works, you need to add to your tables of
knowledge. This is done by asking questions in a news group, reading a book,
checking Help,... Once you have added to your knowledge tables, rerun your
query to see if you have a solution.

When you can do all this fairly quickly in your head, you earn the title of
guru.
 
haha. that seems nice to hear mr Duane... rolf.

i wish i could see a place where there contains a collection of "newly
invented devices from off-the-shell parts." but then i guess you wont be
able to understand most of these new devices until such time that u need them
and/or it applies to u.

need to finish my stuff then. i think ill be hanging around here from time
to time. :D

good day.
 
mr. marshall,

i got a new problem. it is closely related to my other problem.

pls take a glimpse of this :
http://www.geocities.com/wendellremolador/payslip.jpg

i applied your trick but what currently happened is that, the report shows
all of the data first before showing its respective duplicates.

i'd like the report to show me the first employee's payslip and its
duplicate will be on the same page while the next employee's payslip and
duplicate be on another page and so on, so forth.

i cant seem to find how. i hope to hear from u soon.
 
Back
Top