modifying 'Students&Classes'

  • Thread starter Thread starter Sector7G
  • Start date Start date
S

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?
 
(see in-line responses...)
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?
Click to expand...

Don't know how you are defining "at the beginning" -- but have you looked at
any underlying query source for the form? You can change the sort order in
the query.
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)?
Click to expand...

?Cutting off, as in throwing them out entirely, or as in only printing 27
per sheet? Does the missing row show up all by itself on the second page of
labels? Have you tried shrinking the size of the label report just a
'skosh'?
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?
Click to expand...

One approach would be to append students to a temporary table, for use in
generating labels. By setting a unique index on that temp table, you could
ensure that each student is "added" only once.
 
Back
Top