Force New Page
I have 3 groups for footers below is the groups which I have set force new page after section
At the moment after the grouping for customers its creating a new page after Order group where I would like the customer total on the same page as it was the last record for that group
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Everything is within the margins I've allowed (Narrow Margins.) I've checked the report header, footer, and detail. In each of those cases the "Force New Page"is set to "None."
However, every time I print this, I end up with a printed page and a blank page.
How can I eliminate the blank page, I'm using Access 2007 and Windows 7 Professional 64-bit.
I would like to have a new report w/header and page number starting at 1 again.
I would like it to trigger a new page for the report and then continue printing the sub report on the next page.
In the forms, I have a drop down menu with each departments listed. In the report, I have a 2 column report that looks great. Only problem is I want to force a page break for each of the departments listed in the original form (a total of 8 departments), so all of them do not run together on the report. I have been messing with it for a few days now and can't seem to get it to work. I am sure its easier then I think
I have 3 buttons I wish to link to pages, I have 3 pages foe example page 1, page 2 and page 3 all have subforms on there,
I would like so the user clicks on the button 1 and page 1 opens, click on button 2 then page 2 is selected very very new to vba so not sure how to referance it
any advise on how I can achive this
My question is; is there a way to have the page numbering start over with each new record?
For example record 1 may have Page 1 of 2 and Page 2 of 2. while record 2 may have Page 1 of 3, Page 2 of 3 and Page 3 of 3, record 3 may have just Page 1 of 1, etc.
Data entry is handled through a Split Form that displays the Spec information, which has a sub-form in the "Detail" section that displays a list of all the field devices that use that Spec.
So there will be a form for Temperature Sensors with models numbers and such, with a subform that lists the temperature sensors in the field with tag numbers and location information.
Depending on how many instruments are actually in the field, the subform often spills over onto a second or third page.
I have it set to start on a new page for each Spec by setting the Force New Page property of the Detail Section to "After Section". In the Page Footer I have it displaying a "Page X of Y" page number, but it numbers based on the total pages of all Specs.
My question is this: How can I make it display a Page Number and Total Pages at the bottom that Reset's for each Spec rather than a running total of Specs? Is there a way to make itwork with my current setup? None of the examples I have found apply since I do not have any Group level, and do not have an "On Format" event available for the Detail level.
I have a way to force a close but have to contact someone to reopen it.
I would like to be able to code a compact and repair to run during the night ideally without having to close access.
Access 2000 by the way