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 the database version.
4  6171 
Okay, So I got access to do what I want pretty much.
I created a Command Button to print it all out using the following
code;
Private Sub Print_Field_For m_Click()
DoCmd.Printout acSelection
End Sub
This prints out the Master form & subform. Although there are many
records for the subform, & it is printing out all subform records. I
want it to print out only the current subform record. How would I
modify this code to do so?
On Mar 30, 12:16 pm, paq...@gmail.co m wrote:
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 the database version.
Setting the can grow property of the subform control to "No" will keep the
form expanding. If you want to show only some subset of records, update the
subform record source.
<pa****@gmail.c omwrote in message
news:11******** **************@ p15g2000hsd.goo glegroups.com.. .
Okay, So I got access to do what I want pretty much.
I created a Command Button to print it all out using the following
code;
Private Sub Print_Field_For m_Click()
DoCmd.Printout acSelection
End Sub
This prints out the Master form & subform. Although there are many
records for the subform, & it is printing out all subform records. I
want it to print out only the current subform record. How would I
modify this code to do so?
On Mar 30, 12:16 pm, paq...@gmail.co m wrote:
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 the database version.
Can Grow works fine if the partticular record you want to print
happens to be first in the list. If you want the second record you
cant get it individually.
acSelection prints the Current "Main Form" & all it Sub Records.
How to I get it to print only the active 'Main' & 'Subform' records.
On Mar 30, 2:24 pm, "paii, Ron" <p...@packairin c.comwrote:
Setting the can grow property of the subform control to "No" will keep the
form expanding. If you want to show only some subset of records, update the
subform record source.
<paq...@gmail.c omwrote in message
news:11******** **************@ p15g2000hsd.goo glegroups.com.. .
Okay, So I got access to do what I want pretty much.
I created a Command Button to print it all out using the following
code;
Private Sub Print_Field_For m_Click()
DoCmd.Printout acSelection
End Sub
This prints out the Master form & subform. Although there are many
records for the subform, & it is printing out all subform records. I
want it to print out only the current subform record. How would I
modify this code to do so?
On Mar 30, 12:16 pm, paq...@gmail.co m wrote:
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 the database version.- Hide quoted text -
- Show quoted text -
You will need to identify the visible sub form records, then adjust your sub
form's source query to show only those records. As for identifying the
visible sub form records someone else may need to help you.
<pa****@gmail.c omwrote in message
news:11******** *************@w 1g2000hsg.googl egroups.com...
Can Grow works fine if the partticular record you want to print
happens to be first in the list. If you want the second record you
cant get it individually.
acSelection prints the Current "Main Form" & all it Sub Records.
How to I get it to print only the active 'Main' & 'Subform' records.
On Mar 30, 2:24 pm, "paii, Ron" <p...@packairin c.comwrote:
Setting the can grow property of the subform control to "No" will keep
the
form expanding. If you want to show only some subset of records, update
the
subform record source.
<paq...@gmail.c omwrote in message
news:11******** **************@ p15g2000hsd.goo glegroups.com.. .
Okay, So I got access to do what I want pretty much.
I created a Command Button to print it all out using the following
code;
Private Sub Print_Field_For m_Click()
DoCmd.Printout acSelection
End Sub
This prints out the Master form & subform. Although there are many
records for the subform, & it is printing out all subform records. I
want it to print out only the current subform record. How would I
modify this code to do so?
On Mar 30, 12:16 pm, paq...@gmail.co m wrote:
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 the database
version.- Hide quoted text -
- Show quoted text -
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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: M Wells |
last post by:
Hi All,
I am developing an Access 2003 project application with the back end
in SQL Server 2003.
I have a master form that tracks projects, and several subforms on it
that track various aspects of the project. On the masterform I have
two unbound listboxes that I populate with information regarding the
current record in one of the subforms.
|
by: Jack |
last post by:
Hi all,
I searched the archives and found everyone happy with Stephen's
MouseWheel On/Off code except for those with subforms. Stephen's page
indicates that he has added code to handle subforms ("Bug Fix for
SubForms with ScrollBars. Bug fix for SubForms without visible
ScrollBars.") - BUT I still can't get it to work on my app with my
subforms.
I'm using Access 2000, It works fine on the main forms but not on the
|
by: Jack |
last post by:
Gday everyone,
I'm dearly hoping Stephen Lebans is going to update his masterpeice to
stop the mouse wheel scrolling to work on subforms *he has indicated
this to me but of course beggers can't be choosers here so I have no
idea when this would be done*. I'm just wondering if anyone has gotten
around the problem some other way?
--Original Thread---
|
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: tremor |
last post by:
I'd like to print a form based on the filters currently applied to it
(these are again based on selections in combo-boxes). The form has
multiple subforms, and as I try to print it, it prints all records in
each of these, not just the ones i have showing based on the filters
set. These filters are set in the VB code, as child/master
dependencies wouldn't cut it in this case.
I'm sort of pressed on time here, so I really don't want to...
|
by: JonC |
last post by:
I have a database where the user selects recordsets via a form with 2
levels of nested subforms. The recordsets are filtered using a series
of linked combo boxes and I would like to be able to print the slected
recordset from the form. The problem is that when I try and print the
form the combo boxes reset to their default values and so only the
first recordset is displayed. Is there any way around this? I have
tried opening a report of...
|
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: tmh86 |
last post by:
I am currently building a database within Access 2007. I have a form that is populated via vba coding and thereform is not stored in a specific table.
I have created a button that essentially runs through all objects on the form and changes their formatting settings to that of an access report(Making the text blue etc). I did this because i have many different forms that i would like to able to print and thought this would be a quicker way...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
