Hi:
I have a form, which contains a sub form (Employee main record and payment record). It all
shows up fine in a screen view, but when I come to print it I find that I cannot get the
sub form to print on the same page as the form. I have sized the whole thing, and in
theory it should fit into a single 8 1/2 x 11 page, but it just wont perform. I have the
sub sheet components set to "can shrink". Are there any special things that one should be
aware of when printing a form with a sub form, or do I just need to hack around and see
what will work?
Thanks and regards
John Baker
4  8451 
In general, printing from forms is "iffy".
For better results, create a report for printing.
Since you can save a form as a report, this isn't hard to do.
HTH
- Turtle
"John Baker" <Ba******@Veriz on.net> wrote in message
news:le******** *************** *********@4ax.c om... Hi:
I have a form, which contains a sub form (Employee main record and payment
record). It all shows up fine in a screen view, but when I come to print it I find that I
cannot get the sub form to print on the same page as the form. I have sized the whole
thing, and in theory it should fit into a single 8 1/2 x 11 page, but it just wont
perform. I have the sub sheet components set to "can shrink". Are there any special things
that one should be aware of when printing a form with a sub form, or do I just need to hack
around and see what will work?
Thanks and regards
John Baker
Thanks:
I had no idea you could save a form as a report. How do you do it, and what are the
implications when the contents of the form are based on a query?
Thanks for the tip however.
Regards
John Baker
"MacDermott " <ma********@nos pam.com> wrote: In general, printing from forms is "iffy".
For better results, create a report for printing.
Since you can save a form as a report, this isn't hard to do.
HTH
- Turtle
"John Baker" <Ba******@Veriz on.net> wrote in message
news:le******* *************** **********@4ax. com... Hi:
I have a form, which contains a sub form (Employee main record and payment
record). It all shows up fine in a screen view, but when I come to print it I find that I
cannot get the sub form to print on the same page as the form. I have sized the whole
thing, and in theory it should fit into a single 8 1/2 x 11 page, but it just wont
perform. I have the sub sheet components set to "can shrink". Are there any special things
that one should be aware of when printing a form with a sub form, or do I just need to hack
around and see what will work?
Thanks and regards
John Baker
Why not just create a report which is based on the same query as your sub form ?
David B
John Baker <Ba******@Veriz on.net> wrote in message
news:9d******** *************** *********@4ax.c om... Thanks:
I had no idea you could save a form as a report. How do you do it, and what
are the implications when the contents of the form are based on a query?
Thanks for the tip however.
Regards
John Baker
"MacDermott " <ma********@nos pam.com> wrote:
In general, printing from forms is "iffy".
For better results, create a report for printing.
Since you can save a form as a report, this isn't hard to do.
HTH
- Turtle
"John Baker" <Ba******@Veriz on.net> wrote in message
news:le******* *************** **********@4ax. com... Hi:
I have a form, which contains a sub form (Employee main record and payment
record). It all shows up fine in a screen view, but when I come to print it I find that I
cannot get the sub form to print on the same page as the form. I have sized the whole
thing, and in theory it should fit into a single 8 1/2 x 11 page, but it just wont
perform. I have the sub sheet components set to "can shrink". Are there any special things
that one should be aware of when printing a form with a sub form, or do I just need to hack
around and see what will work?
Thanks and regards
John Baker
"John Baker" <Ba******@Veriz on.net> wrote in message
news:9d******** *************** *********@4ax.c om... Thanks:
I had no idea you could save a form as a report. How do you do it, and what
are the implications when the contents of the form are based on a query?
Thanks for the tip however.
Right-Click the form in the db window and choose "Save as Report".
The biggest potential "gotcha" is that when you save a form as a report and that
form contains a subform you end up with a report that still has a subform
embedded in it. You need to save the subform as a report as well and then
change what the new parent report is pointing at.
When I first did this I opened the new report to tweak the design and then
double-clicked the sub and started changing that without realizing that I was
actually changing my original subform by doing so.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Tim Graichen |
last post by:
Hi!
I have a subform (ShedTableSubForm) at the bottom of my MAIN form. I would
like to do two things.
1) preview on screen a report (ShedReport) of the subform data the record
currently displayed in the main form
2) print a report (ShedReport) of the subform data for only the animal
displayed in the main form
|
by: John |
last post by:
Hi,
I have simple database based on 3 tables. Relationship is 'one to many'
between table 1 and 2, also between 2 and 3 table'one to many'.
I have made form where I enter data in all 3 tables. Form has 2 subform
based on relationships.
I want to make report to print data which is shown on form. I want to print
only data from form, not whole records from tables. Does anyone knows how to
do this? I have tried with report based on query,...
|
by: Ellen Manning |
last post by:
Using A2K. I've got a subreport that can have up to 3 lines of data.
The user wants all lines underlined even if there's no data. Any idea
how to do this? Below is an example of the desired results:
Fund #: 1234-56 Name: An Account Amount: $50.00
------- ---------- ------
Fund #: 8989-89 Name: Account 89 Amount: $76
------- ---------- ------
Fund #: Name: ...
|
by: slothboy |
last post by:
Hey guys,
I'm having a little trouble printing subforms. I've attached the
snippet of code that prints my form which contains various subforms.
It prints bounded controls on the subform just fine, but it does not
print unbounded controls. Any advice would be hugely appreciated.
I'm sure it is something extremely simple, but I'm a bit new to Access
2000. Thanks so much.
stDocName = Me.Name
|
by: ChadDiesel |
last post by:
I've been posting questions here the last week, but if you don't know my
situation:
I have a "Print Labels" button on the subform that sends the appropriate box
information on the subform to a report called "Labels." This is how we are
going to print our shipping labels. I also have a label which is a report
called "Destination_Label" that contains the address where the shipment is
to be delivered. While each box label in the "Label"...
| | |
by: Earl Anderson |
last post by:
Using WinXP & AccessXP, I'd like to automatically have the records that I've
just printed in a report automatically updated to have the 'print date &
time' immediately inserted into a 'Date/Time' field in the table of all of
the 'just printed' records. The crude way would be to run an Update Query
immediately before or immediately after printing on those records in the
report, but how would I have this done automatically when hitting the...
|
by: paquer |
last post by:
Hello'
How do I get the subform to print along with the main form?
I want my user's to be able to go in the field with a printout of the
info they need to populate in the database. So when they get back in
the office they can input the data field by field.
The reason I want them to take the actual form & subform is there is
prepopulated data they need in the field.(which is on the form).
& I want the paper version to look exactly like...
|
by: paquer |
last post by:
I have forms that are used in the office as well as in the field.
I want user's to be able to print out an exact copy of the form for
"in the field" data entry. (Yes we are still stuck in the 90's. We use
pencils in the field.) not PDA's.
Thier is "header" information on the Main Form. They use the Subform
for Data Entry. The Record on the Subform is created at the time of
the job via a Command Button on the main form.
Ive run into many...
|
by: Dave |
last post by:
Hello!
What's the best way to make a button print *just* the selected
(displayed) record of a subform, when that subform is currently part
of a larger form?
Thanks!
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
