Criteria for printing

[Prachi via AccessMonster.com]

I have a form that prints reports (snapshot) onclick of a button on it .The
number of reports goes on increasing on daily basis.I have to filter their
printing on one particular criteria say for example (i can get the user input
the range for one of its fields say page nos 25 - 30)so that it just prints
reports in that range instead of all the reports.My question is how do i go
about achieving this as I am a novice to VB and access.

 

[Jeff Boyce]

You may have already tried this...

If you open the report in PrintPreview mode, the user can select which pages
to print.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Prachi via AccessMonster.com]

I am sorry but I did not explain my doubt clearly.the page numbers was just
an example!!
I have to print a selected number of reports say based on a id no in the main
query that generates the reports.This id number range should be given by the
user.When I emant printing I meant printing to snapshot only those reports
that fall in the given range.Any suggestions!!

Thanks
Prachi

You may have already tried this...

If you open the report in PrintPreview mode, the user can select which pages
to print.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a form that prints reports (snapshot) onclick of a button on it .The
number of reports goes on increasing on daily basis.I have to filter their

[quoted text clipped - 5 lines]

go
about achieving this as I am a novice to VB and access.

 

[Jeff Boyce]

Perhaps I'm misunderstanding...

I'm not familiar with reports having an "id number range" -- what report id
number are you referring to?

When you "select" a number of reports, how are you doing that? How are
these reports related to the data/record you want to report about? How are
they related to each other, if at all?

One possibility if you always wanted to print the same 5 reports (example
only) would be to have report1 open report2 as it (report1) closes, and
report2 opens report3...

This may not be an approach you can use in your situation, though.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am sorry but I did not explain my doubt clearly.the page numbers was just
an example!!
I have to print a selected number of reports say based on a id no in the
main
query that generates the reports.This id number range should be given by
the
user.When I emant printing I meant printing to snapshot only those reports
that fall in the given range.Any suggestions!!

Thanks
Prachi

You may have already tried this...

If you open the report in PrintPreview mode, the user can select which
pages
to print.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a form that prints reports (snapshot) onclick of a button on it
.The
number of reports goes on increasing on daily basis.I have to filter
their

[quoted text clipped - 5 lines]

go
about achieving this as I am a novice to VB and access.

 

[Prachi via AccessMonster.com]

Thanks for replying.

I will explain this better.

I have a main(databse) query say final.
final has all possible fields drawn from a main database.
these fields are the control sources of the report I am printing out.
(For example
ID No:final.a1
Name:final.a2
Place:likewise
Occupation:
)

The database has a long list of records of individual with their
name,place,occupation etc.also Each of these individual has a Id number (say
that begins with 1-1000)depending on the number of records(all this is in the
database itself and the main query 'final')

As the number of records go on increasing (that is number of people) the
reports go on increasing.I want to print only the new ones instead of
printing all the reports together everytime.
that is why i want to input the ID no range say (print to snaphot for ID No 1
to ID No 10)and incorporate in my form to print only those reports specified
by me by a range

If this is still unclear I shall give an example:
suppose I print output to snapshot of reports from ID No 1 - ID no 10;
Now there is an addition of reports say total number of reports are 20
Since i have already printed out reports (1-10) I want to print them from (11-
20).

I hope this makes things more clear.

Perhaps I'm misunderstanding...

I'm not familiar with reports having an "id number range" -- what report id
number are you referring to?

When you "select" a number of reports, how are you doing that? How are
these reports related to the data/record you want to report about? How are
they related to each other, if at all?

One possibility if you always wanted to print the same 5 reports (example
only) would be to have report1 open report2 as it (report1) closes, and
report2 opens report3...

This may not be an approach you can use in your situation, though.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am sorry but I did not explain my doubt clearly.the page numbers was just
an example!!

[quoted text clipped - 25 lines]

 

[Jeff Boyce]

I believe I understand now.

When you say "reports", I suspect you are only using a single report
definition (i.e., one report), but printing that report for each of your
individuals, hence the records.

Here's one way you could do that:
* create a query that contains the fields you want printed in your report
* use that query as the source for your report
* modify the query to prompt for a selection criterion under the RecordID
field. It might look something like:
Between [Starting Record Number?] And [Ending Record Number?]

This way, every time you run the report, it (actually, its underlying query)
will prompt for the start/end ID numbers.

Does that get closer to what you are trying to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks for replying.

I will explain this better.

I have a main(databse) query say final.
final has all possible fields drawn from a main database.
these fields are the control sources of the report I am printing out.
(For example
ID No:final.a1
Name:final.a2
Place:likewise
Occupation:
)

The database has a long list of records of individual with their
name,place,occupation etc.also Each of these individual has a Id number
(say
that begins with 1-1000)depending on the number of records(all this is in
the
database itself and the main query 'final')

As the number of records go on increasing (that is number of people) the
reports go on increasing.I want to print only the new ones instead of
printing all the reports together everytime.
that is why i want to input the ID no range say (print to snaphot for ID
No 1
to ID No 10)and incorporate in my form to print only those reports
specified
by me by a range

If this is still unclear I shall give an example:
suppose I print output to snapshot of reports from ID No 1 - ID no 10;
Now there is an addition of reports say total number of reports are 20
Since i have already printed out reports (1-10) I want to print them from
(11-
20).

I hope this makes things more clear.

Perhaps I'm misunderstanding...

I'm not familiar with reports having an "id number range" -- what report
id
number are you referring to?

When you "select" a number of reports, how are you doing that? How are
these reports related to the data/record you want to report about? How
are
they related to each other, if at all?

One possibility if you always wanted to print the same 5 reports (example
only) would be to have report1 open report2 as it (report1) closes, and
report2 opens report3...

This may not be an approach you can use in your situation, though.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am sorry but I did not explain my doubt clearly.the page numbers was
just
an example!!

[quoted text clipped - 25 lines]

go
about achieving this as I am a novice to VB and access.

 

[Prachi via AccessMonster.com]

Yeah I think you understood my doubt.but the modifying query part is not very
clear.I shall research some of it myself and come back to u.
Thanks

I believe I understand now.

When you say "reports", I suspect you are only using a single report
definition (i.e., one report), but printing that report for each of your
individuals, hence the records.

Here's one way you could do that:
* create a query that contains the fields you want printed in your report
* use that query as the source for your report
* modify the query to prompt for a selection criterion under the RecordID
field. It might look something like:
Between [Starting Record Number?] And [Ending Record Number?]

This way, every time you run the report, it (actually, its underlying query)
will prompt for the start/end ID numbers.

Does that get closer to what you are trying to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks for replying.

[quoted text clipped - 65 lines]

 

[Prachi via AccessMonster.com]

thanks!! that works perfect!! I thought it will be something really
complicated!!
Thanks a lot once again

I believe I understand now.

When you say "reports", I suspect you are only using a single report
definition (i.e., one report), but printing that report for each of your
individuals, hence the records.

Here's one way you could do that:
* create a query that contains the fields you want printed in your report
* use that query as the source for your report
* modify the query to prompt for a selection criterion under the RecordID
field. It might look something like:
Between [Starting Record Number?] And [Ending Record Number?]

This way, every time you run the report, it (actually, its underlying query)
will prompt for the start/end ID numbers.

Does that get closer to what you are trying to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks for replying.

[quoted text clipped - 65 lines]