Printing a sequence of reports

[OveB]

Hi,
I am a novice but try to find out how to print partial reports from a base
with pictures and their descriptions. The individual pictures (one or more
for each record) are looked up from a folder by events coding, Picture names
contain the record#). The base grows and I see that when opening the Report
the reports are browsed through and will take more time as the base grows
further. I am aware of and also use the possibility to introduce a condtion
for Record# under Data Properties in Design, say >=10 and <=20 to get only
those printed. However, the browsing still appears and more important, I
want to avoid that the end user has to go into the Design. He must though be
able to tell the program which record# to print.- I would very much
appreciate to get your advice about this, preferably in detail as I know
very little about VB. I use Access 2000.
Greetings from Sweden
Ove

 

[Fons Ponsioen]

The best way would be to base your report on a query
rather than a table. In the query you can easily specify
a criteria for the specific data field.
For instance if you have a field named Record# in the
criteria field you could enter ">=[Enter start Record] and
=< [Enter last record]" (without the double quotes).
when you than run the query (and also the report based on
this query) it will ask you to enter the start and last
record.
I hope this helps.
Fons

 

[OveB]

Works fine! Thanks a lot!
Ove

The best way would be to base your report on a query
rather than a table. In the query you can easily specify
a criteria for the specific data field.
For instance if you have a field named Record# in the
criteria field you could enter ">=[Enter start Record] and
=< [Enter last record]" (without the double quotes).
when you than run the query (and also the report based on
this query) it will ask you to enter the start and last
record.
I hope this helps.
Fons

-----Original Message-----
Hi,
I am a novice but try to find out how to print partial reports from a base
with pictures and their descriptions. The individual pictures (one or more
for each record) are looked up from a folder by events coding, Picture names
contain the record#). The base grows and I see that when opening the Report
the reports are browsed through and will take more time as the base grows
further. I am aware of and also use the possibility to introduce a condtion
for Record# under Data Properties in Design, say >=10 and <=20 to get only
those printed. However, the browsing still appears and more important, I
want to avoid that the end user has to go into the Design. He must though be
able to tell the program which record# to print.- I would very much
appreciate to get your advice about this, preferably in detail as I know
very little about VB. I use Access 2000.
Greetings from Sweden
Ove


.

 

[OveB]

Sorry, I was to rapid to report success. Well, I get one copy of each
Record# on the printer and the preview as desired but för each # something
flashes 2 or 3 times both after answering the last question about the last
record and at stepping the preview.. Could it be that something remains
after all changes, unvisible but still working. In other words do I need
some sort of cleaning code.
Regards
Ove

Works fine! Thanks a lot!
Ove

The best way would be to base your report on a query
rather than a table. In the query you can easily specify
a criteria for the specific data field.
For instance if you have a field named Record# in the
criteria field you could enter ">=[Enter start Record] and
=< [Enter last record]" (without the double quotes).
when you than run the query (and also the report based on
this query) it will ask you to enter the start and last
record.
I hope this helps.
Fons

-----Original Message-----
Hi,
I am a novice but try to find out how to print partial reports from a base
with pictures and their descriptions. The individual pictures (one or more
for each record) are looked up from a folder by events coding, Picture names
contain the record#). The base grows and I see that when opening the Report
the reports are browsed through and will take more time as the base grows
further. I am aware of and also use the possibility to introduce a condtion
for Record# under Data Properties in Design, say >=10 and <=20 to get only
those printed. However, the browsing still appears and more important, I
want to avoid that the end user has to go into the Design. He must though be
able to tell the program which record# to print.- I would very much
appreciate to get your advice about this, preferably in detail as I know
very little about VB. I use Access 2000.
Greetings from Sweden
Ove


.