p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access VBA (http://p2p.wrox.com/forumdisplay.php?f=80)
-   -   Page Break Issues (http://p2p.wrox.com/showthread.php?t=45823)

AccessDev July 28th, 2006 06:16 AM

Page Break Issues
I have a logistics database that shows a report with all drops relative to the vehicle. I have a form that filters the query that is behind the report. This shows me all drops that are selected from a multi select list box from a form. I need to print each drop on a seperate piece of paper the report that show the drops selected is a sub form.

I am using Access 2003.

Does someone have some code that will do a For Each item selected in listbox print each drop number on a seperate piece of paper.

Thanks for any help and source code supplied

mmcdonal July 28th, 2006 09:48 AM

What is a drop? What is a vehicle?

What is the query that is behind the report?

What you need to do is to create a report that does only one record per page. This is easy enough if the data is consistent. However, if it is not (various lengths) then you can run a report for each "drop" in your list box. Just enumerate them and run the report where "[Drop] = " & "'" & sDrop(i) & "'"

Need more info.


AccessDev July 31st, 2006 05:24 AM

A drop is integer value and a vehicle is of a string value.

The report is a sub report and all data is consistant. I am having trouble with the enumeration process. I would be grateful for some pointers

Thanks for any help and source code supplied

All times are GMT -4. The time now is 03:36 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.