473,657 Members | 2,358 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

printing forms with filter (multiple subforms)

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 start
making a report of the whole thing with passing filters and such. Is
there any way of just printing the form with what is displayed?

Cheers,
Thomas
Nov 13 '05 #1
1 1688
Hi
I think you would have to set the FilterOn propery for each subform
explicitly.
David

On 17 Nov 2004 04:05:22 -0800, th***********@h otmail.com (tremor)
wrote:
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 start
making a report of the whole thing with passing filters and such. Is
there any way of just printing the form with what is displayed?

Cheers,
Thomas


Nov 13 '05 #2

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

Similar topics

1
2256
by: John Mudd | last post by:
I come from the Access environment where all the windows form handles were hidden so pardon my question. In Access I could make "continuous" subforms and there was a subform "container" object I could place on a form and then reference the subform and easily link the two together with a master/child link. The mastery of just how it worked was hidden from the average user. I have the dataset side working fine with multiple
6
2243
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,...
1
1751
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
4
1697
by: Luisa Lopes | last post by:
Dear colleagues: I read somewhere that you could obtain the results of a query as a form. I have design a database for my books and waht I would like is to obtain the results of my queries (which use parameters for language, author, genre, etc) in the form of a bunch of the original forms I used for creating the book entries. I don't know if I explained the problem correctly. As a result of a query I
8
3087
by: Zlatko Matić | last post by:
Hello. How can I synchronize subforms content with current record in master form, if both form and subform are based on DAO code ? I assigned DAO recordset to forms by using QueryDef, on Load event. Thanks...
1
6955
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...
1
2843
by: Barb.Richards | last post by:
I have created an append query that pulls information from one database, and will append the selected information into a new table. The fields are setup like 'number' 'category' 'code' 'shares' and 'dollars'. Using the "backend" of this table I can filter the numbers by right clicking and using Filter For: then enter 1 or 2 or 3 and this will return results for all information that has 1 or 2 or 3 as a number. However, the problem I...
1
2410
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...
1
1188
by: patriciashoe | last post by:
I have a form that contains three related sub forms. The stored data can be from any number of years. At times I would like to filter the data so when the main form is open all the subform data shows the selected year. What is the best way to construct this? Right now I have a filter dropdown for one of the sub forms but there must be way to tie in all subforms. Thanks for pointing me in the right direction. Patti
0
8838
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, 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...
0
8739
jinu1996
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...
1
8513
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8613
tracyyun
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...
0
7351
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, 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...
0
4329
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2740
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
2
1969
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1732
bsmnconsultancy
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...

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.