Modifying Sample Database

[Sector7G]

I am modifying the 'Students and Classes' practise
database in Access97. I am not a programmer, but I'm
trying to tweak the DB into something useful. I am stuck
on the following changes and appreciate any help or
suggestions:
1) On the classes form, a new class defaults to the end of
the list. Any way to make the newer classes show up at the
beginning of the form?
2) My printer is cutting off the bottom 3 labels (27 per
sheet). Is this an adjustment on the labels report or is
this a problem with the printer (new printer - works fine
with everything else)?
3)I have a checkbox on the Classes form which puts all
students from those classes together on onereport for
labels. How would I remove duplicate names from the labels?

 

[Douglas J. Steele]

What 'Students and Classes' practise database?

 

[Richard]

I am modifying the 'Students and Classes' practise
database in Access97. I am not a programmer, but I'm
trying to tweak the DB into something useful. I am stuck
on the following changes and appreciate any help or
suggestions:
1) On the classes form, a new class defaults to the end of
the list. Any way to make the newer classes show up at the
beginning of the form?
2) My printer is cutting off the bottom 3 labels (27 per
sheet). Is this an adjustment on the labels report or is
this a problem with the printer (new printer - works fine
with everything else)?
3)I have a checkbox on the Classes form which puts all
students from those classes together on onereport for
labels. How would I remove duplicate names from the labels?

Little more detail would be useful.

1. find out what the record source of the form is. it is probably
ordered by its primary key - try ordering the query or table using
whatver query you choose.

3. alter or group the record source so that each student only appears
once.

2. No idea what you mean. Try playing with the report measurements.




Richard
Its a good job Einstein never had to fill out one of these Government Grant applications or we never would have found out what e equalled. The West Wing