473,756 Members | 1,752 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

report subform print control

This is Access 2003. Have a report that includes three subreports
stacked on top of one another (they display order items). In the
report On Open I build a recordset (to get a value from a foreign
table that determines which of the subforms is used to preview the
items) and On Activate I run a case select that sets visable =
true/false for each subreport. This displays and prints fine from a
preview. If I open the report directly to print it prints all 3
subreports, apparently skipping the On Activate.
So my question is where can I run my case select when opening a report
in Print without preview?
Nov 13 '05 #1
1 1780
You can execute code in the Open event, or you can execute it in each
record in the Format or Print events -- these fire whether you are in
Preview or in Print. I generally prefer the Print event because the
Format event may fire many times. It may seem a waste to execute the
code for each record, but unless it is very, very, very complex,
you'll never see the extra time it takes.

Larry Linson
Microsoft Access MVP

si*******@yahoo .com (Evets Htims) wrote in message news:<8b******* *************** ****@posting.go ogle.com>...
This is Access 2003. Have a report that includes three subreports
stacked on top of one another (they display order items). In the
report On Open I build a recordset (to get a value from a foreign
table that determines which of the subforms is used to preview the
items) and On Activate I run a case select that sets visable =
true/false for each subreport. This displays and prints fine from a
preview. If I open the report directly to print it prints all 3
subreports, apparently skipping the On Activate.
So my question is where can I run my case select when opening a report
in Print without preview?

Nov 13 '05 #2

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

Similar topics

25
10260
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the data in each record, which includes the ID of the father and the mother (who also have records in the table). One record per form. I have a Tab Control in the form, and in one of the tabs I have a subform (sfmSiblings) in which I wish to list...
3
2347
by: bbdata | last post by:
what would be an equivalent of OnCurrent event/Forms , in detail section of the Report? i have a subreport with just one (visible)field, bounded to a query. subreport is in detail section of main report. i want to display all the records in the query if the value of field X in main report is 1, and just one record from the query ( with an invisible field in sbReport set to 2), in any other case. can i change recordsource for subReport for...
5
2449
by: ChadDiesel | last post by:
My basic question is why does my print report button on my subform print a blank report when my cursor is on a blank entry line? Here is a more detailed explanation of my problem. I have a form that contains shipment destination information and a subform that contains boxes for that shipment. The main form is a table called Ship_Info, and the subform is a table called Label_Info. They both contain and are linked by a field called...
8
4907
by: stemo76 | last post by:
I have created a report with subform/subreports. I can see all the data on the screen but when I try to print it to a printer or adobe distiller I get 'The Microsoft Jet Database engine could not find the obect ". Make sure the object exists and that you spell its name and path name correctly.'. Everything prints expect for the last subform/subreport. If I remove that subreport it prints fine. The subreport prints by itself if I run it...
2
1317
by: Ron | last post by:
Hi, I've got a report that has a subreport on it. On the subreport I've got a label and control printing. I'd like to have both the label and the control print only if it's not the default for the control. The label/control is a lblDrLicNo/DrLicNo. Default for control is "1111" (string). I put the routine to make both label and control invisible if DrLicNo =
13
14941
by: Greg | last post by:
Most suggestions on this topic recommend to use a page footer and make it visible only on the last page. My problem is that the footer is half of the height of a page which means the detail would show on only the top half of each page with whitepace at the bottom of each page. How can I get the detail to fill each page with my "half page height" report footer at the bottom of the last page? Any suggestions to solve this would be...
4
5884
by: Henrootje | last post by:
I have a REPORT with in it a subFORM Now I have this label (lblMonth) that I want to change. How should I do this? What would be the proper event to do this? The lblMonth should contain the name of the month as jan 07 Any ideas?
12
3540
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 print the report three times, but do not know how
2
1774
geolemon
by: geolemon | last post by:
I'm still relatively new to Access - this question is due to my moderate experience with forms and my complete and total lack of experience with reports. I want to create a report (I use that term conceptually) that prompts an end user to input an assembly number, and kicks out a report that sums up what and how many of each component is used in an assembly. So, my first question is - how do I create a report that prompts a user for input?...
0
9431
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, 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...
0
9844
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
9819
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
9689
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...
1
7226
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 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...
0
5119
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...
1
3780
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
3326
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2647
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.