473,326 Members | 2,813 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

how to keep information in access footer section in same place on pre-printed form

how do I keep the information in the footer section of a access report from expanding when the detail section changes?

The information in the detail section is description for an invoice. It could be 1 or many lines.

In the report footer section are the totals for the detail section, sales tax, sub total, invoice total.

it prints ok when we have just one line in the detail section, but when more then one line, it moves the footer section down
Mar 25 '11 #1
3 2012
TheSmileyCoder
2,322 Expert Mod 2GB
Hi Gary and welcome to BYTES

Im a bit unsure what you mean.
Please clarify whether you are talking about a:
Group Footer
Page Footer
Report Footer

Footers do not normally expand when the detail section changes, so that leaves me unsure on what you mean, could you try to clarify.
Mar 25 '11 #2
The information in the detail section is description for an invoice. It could be 1 or many lines.

In the report footer section are the totals for the detail section, sales tax, sub total, invoice total.

it prints ok when we have just one line in the detail section, but when more then one line, it moves the footer section down
Mar 25 '11 #3
NeoPa
32,556 Expert Mod 16PB
The only section that prints relative to the bottom of the page is the page footer section.

I would suggest setting Cancel to True for all but the last page of the report. The only way I've found to determine this is to ensure that you have a TextBox control somewhere in your Page Footer that has the .ControlSource of "=[Pages]" (.Visible can be set to False if you don't want it to show). This appears to be necessary for code in the event procedure to have access to the correct value. After that is done use the following code to ensure it is only displayed on the last page :

Expand|Select|Wrap|Line Numbers
  1. Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
  2.     Cancel = (Me.Page < Me.Pages)
  3. End Sub
You'd have to ensure the values shown reflected those from the Report Header though of course ;-)
Mar 25 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: success_ny | last post by:
I would like to be able to display either one or the other HTML table in the same place. I.e., there are 2 buttons on the screen. When the user clicks one button, the table A is displayed below....
4
by: Bon | last post by:
Hello all Would it be possible to migrate the MS Access 2000 to MS SQL Server 2000? My application is using MS Access 2000 as database and as user interface such as forms. Now, I want to...
3
by: Terry | last post by:
Id like to connect to a table in a different database in the same instance. Create database db1 Create database db2 Connect to db1.... Create table test1 ( Name varchar(10), age INT)
17
by: vish | last post by:
Hi all, I know this might look strange at first look, but i am looping thru a dataset created using to different tables from database.These two tables have some fields with the same names. ...
1
by: kkk1979 | last post by:
Hi, I am trying a report which needs to be grouped by invoice number, transdate. The existing report already grouped by invoice number.Now I am trying to include transdate in the list. But the...
18
by: Dennis | last post by:
Greetings. I want to run the two versions of Access on the same machine (2003 & 2007). I still need 2003 for most of my work, yet I need to start learning 2007. In my previous attempts at this,...
1
by: Joshua | last post by:
I would like to show and hide multiple DIV's on a page. I would like them to be centered and in the same place (so i can have a div of info for each tab). I'm testing on firefox and I'm not able...
1
by: Ganeshb | last post by:
i have 3 levels of data wil get from database in a hierarchical manner like... Country State District. By default i display all countries which i want. If i click the any of the...
7
by: Geoff Cox | last post by:
Hello, I have the code below in which the play1.gif image is visible and when the associated sound has been played the the 2 images same1.gif and different1.gif appear. Once one of these has...
3
by: luttkens | last post by:
I've got a script to access my database called mysql.class.php. So from every other script that is talking to the database, this file i included, like this for instance: <?php...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.