[AccessD] Blank Lines On Report

Rocky,

  There is another method space down the page.  See method #3 in

http://support.microsoft.com/default.aspx?scid=kb;en-us;208979

  Everyone always forgets about the MoveLayout, NextRecord, PrintSection
Properties.  Too bad as you can do some very fancy things with them.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Thursday, February 20, 2003 12:32 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Blank Lines On Report


Neal and Gustav:

That worked! A union query joining the query from the original report and a
table of blank lines, then another query taking the top 35 from the union
query, which fills one page.

Thank you.

Rocky

----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Rocky Smolin - Beach Access Software" <accessd at databaseadvisors.com>
Sent: Thursday, February 20, 2003 8:16 AM
Subject: Re: [AccessD] Blank Lines On Report


> Hi Rocky
>
> You could make a union query where you select the records as now and X
> number of similar empty records from a dummy table. X is the maximum
> amount of records that one page can hold.
>
> Then feed this query to another where you Select Top X ..
> Use this as source for your report.
>
> /gustav
>
> > I need to put some blank lines at the end of a report to fill up the
page.  The report is a list of patients for a doctor on rounds with a couple
of other fields to fill in.  The fields have solid,
> > visible borders and make a lovely grid.  I can get the number of records
in the report so I know how many additional lines I need to fill out the
page.
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com