Report problem

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hi Guys,
I have a form where you can enter employee details. Each employee has to
be trained on 9 different jobs so there were too many controls to fit on a
single form, so i created a Tab Control to split it up into manageable
sections.
Altogether there's about 150 controls and when i try to create a report
based on the form, i'm told i've too many controls etc. I actually only need
to print the details from one of the 9 tabs at a time and the whole thing has
become a bit of a mess. Would anyone have a suggestion as to how i could
overcome this problem.

Please bear in mind i'm an amateur at this.

Tghanks guys,
Jen
 
Jen said:
Hi Guys,
I have a form where you can enter employee details. Each employee has to
be trained on 9 different jobs so there were too many controls to fit on a
single form, so i created a Tab Control to split it up into manageable
sections.
Altogether there's about 150 controls and when i try to create a report
based on the form, i'm told i've too many controls etc. I actually only need
to print the details from one of the 9 tabs at a time and the whole thing has
become a bit of a mess. Would anyone have a suggestion as to how i could
overcome this problem.

Please bear in mind i'm an amateur at this.

Thanks guys,
Jen
Click to expand...



I've just been thinking it over......should i have the details of each job
in separate tables and linked together using relationships ?
 
I think you have a normalization issue. "9 different jobs" should create at
least 9 different records in a related table.
 
Yes i think you're right.....part of the problem was i 'inherited' this
database about 75% complete and it looks like the guy was heading in the
wrong direction with one or two things. I'm going to split the jobs into
different records and pull them together with a query when necessasry.

Thanks for your help on this,
Jen
 
Back
Top