2 Things - blank rows and form buttons

[Chrisopia]

1) I'm creating invoices in the report, however the end user would prefer if there was some blank rows, just so all invoices look the same.
i.e. 7 fixed rows... if theres more than 7 records, then a 2nd sheet is started.

2) Form Buttons... how do I create a button in a form to open up the current customer, but in the Customer Report? I once knew how to, but then completely forgot!

oh yeah, last thing my reports keep telling me my report is too wide... I've changed my printer margins but it wont go any lower than 6.01mm for A4 paper (210 x 297)... I made everything in the report and subreports a maximum width of 19.6... and it's still too big!? The page prints out fine, and everything is in the right place but then a 2nd blank page always wants to come out!?

 

[llkhoutx]

Use hidden rows which become visible on the requisite row count.

 

[Chrisopia]

row count? Where's that?

Also I need to know how to print from a report, using a button on the form...
it seems to want to print them all instead of selecting a specific record!?

 

[llkhoutx]

You count rows in a section of a report, particularily the Detail section, by adding a control to the secton with its "Control Source" property set to -1 and its "Running Sum" property set to "Yes" (without the quotes). That control increments with each report line.

An easy way to build a report triggered by a button is to add a button to your form (via the toolbox icons) and follow the prompts for building a report. I don't have Access available at the moment and forget the exact sequence. It's in one of the button wizard menus.

 

[Chrisopia]

You count rows in a section of a report, particularily the Detail section, by adding a control to the secton with its "Control Source" property set to -1 and its "Running Sum" property set to "Yes" (without the quotes). That control increments with each report line.

An easy way to build a report triggered by a button is to add a button to your form (via the toolbox icons) and follow the prompts for building a report. I don't have Access available at the moment and forget the exact sequence. It's in one of the button wizard menus.

So I tried that... cant find a "Running Sum".... though i did find it once by fluke and not sure how:S but there wasn't a yes option, just "no", "Group all" and "group by" or something... I tried both with the source to -1, nothing happened. Must be doing it wrong?

Also the report button wizard only makes a general report... it's not making a report of the current record, just all of them.

 

[llkhoutx]

"Running Sum" is a property of the control.

 

[Chrisopia]

yup Ive found the funning sum... but theres no option for yes, just No, Over Group, and Over all...

Over Group does nothing... the control just shows a -1?
Over All counts (with a - signs in front) the rows?

Am I using the right control :S

Also theres no option to use hidden rows, or declare how many rows to show!?

I'm very confused!?

 

[Terri58ds]

Blank Rows: I had the same issue with fixed number of lines last week and found the answer on this forum under the topic "Fill page with blank field" topic number 31873
http://www.access-programmers.co.uk/forums/showthread.php?t=31873 There was a sample DB attached but seems to be removed now.

Other references on this forum were to a Microsoft article Q119073 which is now moved to http://support.microsoft.com/kb/119073

From these articles I got it working for me in a flash.

Report too wide: Although all your controls may be a max of 19.6 wide your report page may be too wide. Look at the square at the top left corner. If there is a green triangle in the corner, click it and from the ! error symbol select "Remove Extra Report Space". If your ruler does not reduce to 19.6 then select "Select Control furtherest to the Right" and edit that control.

HTH
TerriAnn

 

[Rich]

Blank Rows: I had the same issue with fixed number of lines last week and found the answer on this forum under the topic "Fill page with blank field" topic number 31873
http://www.access-programmers.co.uk/forums/showthread.php?t=31873 There was a sample DB attached but seems to be removed now.

Other references on this forum were to a Microsoft article Q119073 which is now moved to http://support.microsoft.com/kb/119073

Yes because I'm leaving and taking all my useless examples with me, however if anyone wants a sample while I'm still here please feel freeto pm me for a copy

 

[Rich]

I've added it quickly here, I don't have time at the minute to set up the file sharing site, enjoy