[AccessD] Blank Lines On Report

Jim:

I'm a big fan of those properties which I discovered by accident very early
on when I first started with Access.  Reading Balter's book.  I actually
tried to something similar to this and gave up.  But the Union query worked.

Rocky

----- Original Message -----
From: "Jim Dettman" <jimdettman at earthlink.net>
To: <accessd at databaseadvisors.com>
Sent: Thursday, February 20, 2003 10:15 AM
Subject: RE: [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
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>