A report has many different groups of multiple pages each. Each group starts
on a new page. The report is printed on both sides of the paper. I would like
to be able to have each group start on a right hand page, that is, to be
printed on an odd numbered page. something like iif(page mod0 is true then
force to next page).
All suggestions will be gratefully received.
Chuck
.... 4 4544
In the Sorting'n'Group ing dialog, enter your grouping header twice (i.e. on
2 rows).
Add a page break control to the new header, and in its Format event, toggle
the Visible property of the page break control. (They do have a Visible
property, althougn the Intellisense does not show it).
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Chuck" <li*****@school link.net> wrote in message
news:so******** *************** *********@4ax.c om... A report has many different groups of multiple pages each. Each group
starts on a new page. The report is printed on both sides of the paper. I would
like to be able to have each group start on a right hand page, that is, to be printed on an odd numbered page. something like iif(page mod0 is true
then force to next page).
All suggestions will be gratefully received.
Chuck
On Fri, 25 Jun 2004 13:51:28 -0400, Chuck <li*****@school link.net> wrote:
Allen Browne's suggestion seems so simple. However, I'm not smart enough to
understand how to do it. If it makes any difference, I'm using Access 97.
I tried to follow the help directions for making a conditional page break.
Everything seemed to program OK, howerer, When I tried to preview the report
the following error message game up:
The object doesn't contain the Automation object 'CondPgBreak'
You tried to run a Visual Basic procedure to set a property or method for an
object. However, the component doesn't make the property or method
available for the Automation operations.
Check the component's documentation for information on the properties and
methods it makes available for Automation operations.
Does this means that Access doesn't contain 'CondPgBreak' as an object or that
my installed Access components do not recognize VB (VBA) code?
Do I have to write some code to define the 'object'?
Chuck
.... A report has many different groups of multiple pages each. Each group starts on a new page. The report is printed on both sides of the paper. I would like to be able to have each group start on a right hand page, that is, to be printed on an odd numbered page. something like iif(page mod0 is true then force to next page).
All suggestions will be gratefully received.
Chuck ...
Hi Chuck
You already have a group header, with its Force New Page property set to
Yes. To force this group to start on an odd page:
1. In report design view, open the Toolbox (View menu), and drag the Page
Break Control from the Toolbox into this group header section.
2. Add this line of code to the Format event procedure of the group header:
Me.PageBreak1.V isible = ((Me.Page Mod 2) = 0)
replacing "PageBreak1 " with the name of your page break control.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Chuck" <li*****@school link.net> wrote in message
news:46******** *************** *********@4ax.c om... On Fri, 25 Jun 2004 13:51:28 -0400, Chuck <li*****@school link.net> wrote:
Allen Browne's suggestion seems so simple. However, I'm not smart enough
to understand how to do it. If it makes any difference, I'm using Access 97.
I tried to follow the help directions for making a conditional page break. Everything seemed to program OK, howerer, When I tried to preview the
report the following error message game up: The object doesn't contain the Automation object 'CondPgBreak'
You tried to run a Visual Basic procedure to set a property or method
for an object. However, the component doesn't make the property or method available for the Automation operations.
Check the component's documentation for information on the properties
and methods it makes available for Automation operations.
Does this means that Access doesn't contain 'CondPgBreak' as an object or
that my installed Access components do not recognize VB (VBA) code?
Do I have to write some code to define the 'object'?
Chuck ...
A report has many different groups of multiple pages each. Each group
startson a new page. The report is printed on both sides of the paper. I
would liketo be able to have each group start on a right hand page, that is, to be printed on an odd numbered page. something like iif(page mod0 is true
thenforce to next page).
All suggestions will be gratefully received.
Chuck
On Sun, 27 Jun 2004 11:08:40 +0800, "Allen Browne" <Al*********@Se eSig.Invalid>
wrote:
Allen,
Please excuse the delay in this responce. Holidays, Kids, and Grand kids says
it all.
You made it simple enough that even I could understand it. It works perfectly.
Thank you.
Chuck
.... Hi Chuck
You already have a group header, with its Force New Page property set to Yes. To force this group to start on an odd page:
1. In report design view, open the Toolbox (View menu), and drag the Page Break Control from the Toolbox into this group header section.
2. Add this line of code to the Format event procedure of the group header: Me.PageBreak1.V isible = ((Me.Page Mod 2) = 0) replacing "PageBreak1 " with the name of your page break control. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Gary D. Rezek |
last post by:
Hi All,
First of all I'm mostly an MS Access guy (and novice learning MSSQL guy) and put on this project because of personnel changes,
etc and because of db experience. I've only been doing this for about 2 months.
I need to know how to "force" a download (patch) from an ASP page.
I am developing an on-line internet registration page for students in the Residence Halls. Part of this project is getting their
Res Hall/room number/port, MAC...
|
by: Brian Jorgenson |
last post by:
On my web page, I have a few hyperlinks with target frame of _blank.
The hyperlink brings up a second window, but everytime I click on thie
hperlink, it keeps bringing up a new window and not defaulting the the
first active window. How do I make a hyperlink point to the active
window? I don not want the hyperlink to default to the same page. I do
want a second window but only a second window and not multiple pages.
|
by: VB Tester |
last post by:
Hey All
I have an interesting question. I have a WEB application that requires an "Active" data connection. For example, the client application makes a request to the database. Throughout the "Session", if any changes are made to the data that the user has, the server should force a PostBack
In ADO, adOpenDynamic recordset is the behavior I am trying to mimick. I know that with ActiveX, J# and java this is not that hard, what about ASP.Net...
|
by: theyas |
last post by:
I have a page that I get to by selecting the part number and serial number of
an item in my database. The pages then generates a set of files. Some of
these files have unique names (containing part/serial data within the name)
and others of these files (for historical/hysterical reasons) always have the
same name (regardless of which item they are for). Basically, all of these
files are generated from the database and provide the...
|
by: scottyman |
last post by:
I can't make this script work properly. I've gone as far as I can with
it and the rest is out of my ability. I can do some html editing but
I'm lost in the Java world. The script at the bottom of the html page
controls the form fields that are required. It doesn't function like
it's supposed to and I can leave all the fields blank and it still
submits the form. Also I can't get it to transfer the file in the
upload section. The file name...
| |
by: divya |
last post by:
I have a page name edit.asp which should expire immediately .The user
cannot open this page directly he has to provide a password for
entering this page.thus when the user enters edit.asp , it has a button
EDIT ,which when user clicks directs him to another page (done.asp).
Now the problem is that from this page (done.asp) if he clicks on the
back button on the toolbar then edit.asp opens.But I don't want it to
open It should show page...
|
by: Nathan Sokalski |
last post by:
Ever since I found out that they didn't give us a way to install both IE6
and IE7 on the same machine, I have been more frustrated and annoyed with
Microsoft than I ever have been with any company (and for someone who has
loved Microsoft as much as me, that takes something pretty bad!). I am a web
developer, and only have access to one computer, which makes it hard to test
for both IE6 and IE7. But even for people that have access to...
|
by: PooFlinger1 |
last post by:
I am writing an application which will install a number of updates
(silently) as well as installing Norton and Spysweeper silently.
Problem is that after spysweeper installs, it performs a forced reboot
of the PC. How would I abort the FORCED shutdown?
|
by: Andy B |
last post by:
I have an instance of an object that needs to be accessed by all members of
a page like page_load, button_click events and so on. Where in the
codebehind would I put the creation of the object instance?
|
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: 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,...
|
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: 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.
| |
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...
| |