473,320 Members | 1,724 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

seperate page/document for each record?

I'm trying to create invoices using reports and I have
(Clients>Projects>Jobs>Expenses) four headers on the report. I need it to
seperate the pages by only allowing it to start an a new client heading on a
new page

I also then want to 'print' each invoice (report pages) to a seperate file -
as these will be 'printed' as PDFs

Thanx in Advance
Dan
Nov 13 '05 #1
5 2305
To start a new client on a new page, set the NewPage property of your
Clients header to BeforeSection.

To create separate files, you'll need to do more, though.
One approach would be to write a loop which runs through your Clients and
runs a filtered report for each one.

HTH

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:Fb**************@newsfe4-gui.ntli.net...
I'm trying to create invoices using reports and I have
(Clients>Projects>Jobs>Expenses) four headers on the report. I need it to
seperate the pages by only allowing it to start an a new client heading on a new page

I also then want to 'print' each invoice (report pages) to a seperate file - as these will be 'printed' as PDFs

Thanx in Advance
Dan

Nov 13 '05 #2
How would I go about writing a loop to run through the clients and do a
filtered report for each S:

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:p3****************@newsread2.news.atl.earthli nk.net...
To start a new client on a new page, set the NewPage property of your
Clients header to BeforeSection.

To create separate files, you'll need to do more, though.
One approach would be to write a loop which runs through your Clients and
runs a filtered report for each one.

HTH

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:Fb**************@newsfe4-gui.ntli.net...
I'm trying to create invoices using reports and I have
(Clients>Projects>Jobs>Expenses) four headers on the report. I need it
to
seperate the pages by only allowing it to start an a new client heading
on

a
new page

I also then want to 'print' each invoice (report pages) to a seperate

file -
as these will be 'printed' as PDFs

Thanx in Advance
Dan


Nov 13 '05 #3
Which part is difficult for you?
Writing a loop?
Obtaining a list of all clients?
Filtering your report?

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:7q***************@newsfe3-win.ntli.net...
How would I go about writing a loop to run through the clients and do a
filtered report for each S:

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:p3****************@newsread2.news.atl.earthli nk.net...
To start a new client on a new page, set the NewPage property of your
Clients header to BeforeSection.

To create separate files, you'll need to do more, though.
One approach would be to write a loop which runs through your Clients and runs a filtered report for each one.

HTH

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:Fb**************@newsfe4-gui.ntli.net...
I'm trying to create invoices using reports and I have
(Clients>Projects>Jobs>Expenses) four headers on the report. I need it
to
seperate the pages by only allowing it to start an a new client heading
on

a
new page

I also then want to 'print' each invoice (report pages) to a seperate

file -
as these will be 'printed' as PDFs

Thanx in Advance
Dan



Nov 13 '05 #4
All - I've not a clue where to start any decent web pages you know?

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:oe*****************@newsread2.news.atl.earthl ink.net...
Which part is difficult for you?
Writing a loop?
Obtaining a list of all clients?
Filtering your report?

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:7q***************@newsfe3-win.ntli.net...
How would I go about writing a loop to run through the clients and do a
filtered report for each S:

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:p3****************@newsread2.news.atl.earthli nk.net...
> To start a new client on a new page, set the NewPage property of your
> Clients header to BeforeSection.
>
> To create separate files, you'll need to do more, though.
> One approach would be to write a loop which runs through your Clients and > runs a filtered report for each one.
>
> HTH
>
> "Dan Kean" <we*******@sms.uk.ro> wrote in message
> news:Fb**************@newsfe4-gui.ntli.net...
>> I'm trying to create invoices using reports and I have
>> (Clients>Projects>Jobs>Expenses) four headers on the report. I need
>> it
>> to
>> seperate the pages by only allowing it to start an a new client
>> heading
>> on
> a
>> new page
>>
>> I also then want to 'print' each invoice (report pages) to a seperate
> file -
>> as these will be 'printed' as PDFs
>>
>> Thanx in Advance
>> Dan
>>
>>
>
>



Nov 13 '05 #5
If you honestly don't know how to write a loop, you have a fairly steep
learning curve ahead of you.
If you're serious about pursuing this, I'd suggest that you look for a book
or video on VBA programming, or perhaps find a course at your local
community college or computer center.
If you're in any sort of hurry for this, though, and have the financial
resources available, you may find it in your interest to rent a consultant
for a few hours to take care of this for you.

HTH

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:qR**************@newsfe5-gui.ntli.net...
All - I've not a clue where to start any decent web pages you know?

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:oe*****************@newsread2.news.atl.earthl ink.net...
Which part is difficult for you?
Writing a loop?
Obtaining a list of all clients?
Filtering your report?

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:7q***************@newsfe3-win.ntli.net...
How would I go about writing a loop to run through the clients and do a
filtered report for each S:

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:p3****************@newsread2.news.atl.earthli nk.net...
> To start a new client on a new page, set the NewPage property of your
> Clients header to BeforeSection.
>
> To create separate files, you'll need to do more, though.
> One approach would be to write a loop which runs through your Clients

and
> runs a filtered report for each one.
>
> HTH
>
> "Dan Kean" <we*******@sms.uk.ro> wrote in message
> news:Fb**************@newsfe4-gui.ntli.net...
>> I'm trying to create invoices using reports and I have
>> (Clients>Projects>Jobs>Expenses) four headers on the report. I need
>> it
>> to
>> seperate the pages by only allowing it to start an a new client
>> heading
>> on
> a
>> new page
>>
>> I also then want to 'print' each invoice (report pages) to a seperate > file -
>> as these will be 'printed' as PDFs
>>
>> Thanx in Advance
>> Dan
>>
>>
>
>



Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: DaveS | last post by:
Hello, I'm using Oracle 9.2 and would like to automatically save a copy of each deleted record in XML format to another database table. There would be one XML record for each deleted record. ...
2
by: RWC | last post by:
Hello, I have a page connected to an SQL table. The page loops through, creating a row for each record, displaying in image, the ID of which is set to the record id. When I click a button to...
4
by: deko | last post by:
I can't move a multi-page report to the last record unless I keep the popup form (that defined it's subreports) open. DoCmd.OpenReport "rptStandard", acViewNormal DoCmd.Close acForm,...
4
by: Jeff Harbin | last post by:
I've got an ACCESS 2000 application that I'm developing. One of the outputs of this app will be to generate a series of 'jobs' which corresponds to a record in the database. Each record will be...
3
by: laryten | last post by:
Hi, Is there a way to update the same web page instead of getting a new page each time we click the submit button? The simplest thing to do is to delete the current page (or go back to the...
3
by: Lord0 | last post by:
I *think* I need to be able to validate subsets of an XML document using different schema. The functionality I'm trying to implement is this. a) External suppliers produce an XML document...
7
by: SHC | last post by:
I'm in need of some javascript to load two pages into two seperate iframes which are on two seperate and different pages. Rather complicated I know (and easier done in one frameset), but caused...
1
by: =?Utf-8?B?R2VvcmcgRmxlaXNjaGVy?= | last post by:
Hello, I've got a problem which I can not locate. I will try to describe it and would be glad, if someone had an idea how to identify the cause of the problem. Situation: My application...
7
by: iheartvba | last post by:
Hi, I have a report with only a header and a footer, I want to put a sub report in as the reports detail, the sub report has 3 records and then a Sum at the end, for the sum I have created a...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.