Problem with Continious Form

  • Thread starter Thread starter Adam
  • Start date Start date
Hi Ron,

The purpose of the form is to audit the advisor, as per the questions.

It is like a questionnaire, you enter your name at the top and answer
each of the questions. So your results will all be recorded against the
one Name.

The form is to add records.

There will be different questions for each "Team".

There is a response and score for each question.

And the notes field is relative to ALL of the questions, not each of
the questions.

Think I've answered each item?

Many Thanks for your assistance!

Adam
 
What about the Doc Reference - Date - Time, The Customer Name? Are all
of these relative to the test or are they relative to the question?

Ron
 
That is what I assumed in the changes I sent you. I guessed at it based
on the way you had your form laid out.

As in so many things in Access and windows, there seems to always be
more than one way to skin a cat. (or anything for that matter). I hope
the mdb gives you some ideas.

Ron
 
Yeah I'm trying to understand your forms and so on but it is REALLY
helping me. I can see why the tables should be normalized, i've had
headaches with databases before when people change there minds etc.
This totally overcomes this.

I'm goner take a look at it again tonight so I'll mail you.

Thank you for doing this though, this is really helping me!!!
 
Hopefully, the changes will help and you can see why - having gone
through the hassle the other way.

The only field I did not normalize was the "Question Series" in the
Questions Master file.

It could be done, but as of now it is not used much at all and it was
easier at the time.

"Easier at the time" - The very big alligator we keep putting in the
pool and then we wonder why we get bitten.

If converting over to another mdb AND to figure out where I put things,
most of the extra code is in OnCurrent, OnClick, OnDoubleClick,
AfterUpdate.

Enjoy - and Learn - hopefully from both my examples AND my mistakes AND
all the suggestions from others in the group.

Ron
 
Back
Top