adreslabels

  • Thread starter Thread starter Dirk Van waes
  • Start date Start date
D

Dirk Van waes

Hi,
I have a form where I can make a selection of the records (clients) that I
want on my adreslabels. (selected by country, language, profession etc.)
Is it possible to print on the first label the selection I made instead of
the first adress? And if they are sorted by country, is it possible to print
a label with the name of the country before the real labels of that country?
How can I do that? I really don't see it.
Tia
Dirk
 
Hi,
I have a form where I can make a selection of the records (clients) that I
want on my adreslabels. (selected by country, language, profession etc.)
Is it possible to print on the first label the selection I made instead of
the first adress? And if they are sorted by country, is it possible to print
a label with the name of the country before the real labels of that country?
How can I do that? I really don't see it.
Tia
Dirk
Click to expand...

You can use the Sorting and Grouping feature of the Report to do this.
You can actually do both:

- In the Report Header section, display your search criteria by
putting textboxes with control sources which refer to your criteria
form: e.g. the Profession textbox might have a Control Source

=Forms![yoursearchform]![cboProfession]

- Use Sorting and Grouping to group by Country and put a textbox on
the group header with the value of Country.

- The Detail section of the report would simply be your address label.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Thanks John, You helped me a lot
greetings from Belgium
Dirk

John Vinson said:
Hi,
I have a form where I can make a selection of the records (clients) that I
want on my adreslabels. (selected by country, language, profession etc.)
Is it possible to print on the first label the selection I made instead of
the first adress? And if they are sorted by country, is it possible to print
a label with the name of the country before the real labels of that country?
How can I do that? I really don't see it.
Tia
Dirk
Click to expand...

You can use the Sorting and Grouping feature of the Report to do this.
You can actually do both:

- In the Report Header section, display your search criteria by
putting textboxes with control sources which refer to your criteria
form: e.g. the Profession textbox might have a Control Source

=Forms![yoursearchform]![cboProfession]

- Use Sorting and Grouping to group by Country and put a textbox on
the group header with the value of Country.

- The Detail section of the report would simply be your address label.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
Back
Top