Problem to run Access database

[Steffen]

Dear all, I have a databases for Corporate culture, which I would like to use in the future for my clients. The problem is, I am out of access for over 10 years and now I come to a problem which I can't solve with my knowledge.

Backround of this database,

I would like to check the corporate culture according to Cameron & Quinn here in Russia (The questions are in Russian). For each question the worker need to fill percentage between 1% till 100 %, but all 4 question have a sum of 100%, not more not less.


For each form I create one table, each table have 4 question. E.g. 1a is for the first question in the first main group, followed by 1b and 1c and 1d. This are the questions for the real situation, and for the optima of every member of the comany I add as well 1a optima till 1d optima. This I have done for all 6 question parts. the questions are only written in the forms.


The relationship is easy, because one worker need to fill out all questions (the main key for one questionary are equal), see picture 2 (relations ships).

My problems:

1) I would like to go from form Fo_0_QN_CC to Fo_1_QN_CC from this one to to Fo_2_QN_CC till Fo_6_QN_CC. The jump from one to the next one is working, but the db dont would like to save the record (the datas which I add). The last question is the question 1-6 d_optima, on this I add an event after update:

But after it it comes the error:

Questions:

1) How can I save the input?
2) How can I check the input, if the input of the 4 questions are higher or less of 100% the worker has to redu the input?
3) After jump to "open next window" buttom, the last window need to be closed, this is also not working with the same error massage?

I guess thats a peanuts for some one who do it every day. Please help me, attached I have as well the database, the start window for the database is fo_0_QN_CC. Please be so kind and help a old men. Thanks in advance.

 

[DHookom]

I would create normalized tables where each response to a question created a record in a table. An unbounded form would present the group of four questions to be answered. Add a command button that checks the math requirements and appends (or updates) the appropriate four records in the normalized table.

 

[The_Doc_Man]

First and foremost, DHookom is right. You have denormalized tables that contain numbers 1 through 6 in otherwise similar structures - suggesting that there is something common to them all and you use those numbers to delineate that something. This is a big no-no for normalization. The thing represented by the 1-to-6 should be a FIELD in a SINGLE table and it can have values from 1 to 6.

The difficulty here is that when you have tables like that, the data of unique records must depend solely on the key (or keys, for compound-key cases). But here, the name of the table differentiates between two related datasets that SHOULD be together and differentiated by a field. This rule derives from the concept of relationships, which require a way to identify WHY the records are different, which is managed by keys/indexes.

I have a second comment to consider that is related to normalization. Your denormalized structure is obvious in the in the relationship diagram. Your table with the "6" in its name presents an alternate path between two tables, the -1- and -5- tables if I read that correctly. I'm going to guarantee that a query involving any "multiple-path" situation will never be possible to update without some really complex SQL. That divergent path creates a JOIN ambiguity that Access will refuse to resolve because Access doesn't know what you wanted to do, i.e. which relationship path you wanted to exercise. As good as the graphic interface can be, it is dumber than a box of rocks. Your best course of action would be to restructure those tables by normalization in order to be able to create an updatable query of the indicated data.

EDITED BY THE_DOC_MAN: By way of clarification, the two "paths" are the link that goes from table -1- to table -5- through table -6-, or the link from -1- to -5- through -2-, -3-, and -4- - all via apparently unique relationships.

 

[mike60smart]

Dear all, I have a databases for Corporate culture, which I would like to use in the future for my clients. The problem is, I am out of access for over 10 years and now I come to a problem which I can't solve with my knowledge.

Backround of this database,

I would like to check the corporate culture according to Cameron & Quinn here in Russia (The questions are in Russian). For each question the worker need to fill percentage between 1% till 100 %, but all 4 question have a sum of 100%, not more not less.


For each form I create one table, each table have 4 question. E.g. 1a is for the first question in the first main group, followed by 1b and 1c and 1d. This are the questions for the real situation, and for the optima of every member of the comany I add as well 1a optima till 1d optima. This I have done for all 6 question parts. the questions are only written in the forms.


The relationship is easy, because one worker need to fill out all questions (the main key for one questionary are equal), see picture 2 (relations ships).

View attachment 119181View attachment 119182

My problems:

1) I would like to go from form Fo_0_QN_CC to Fo_1_QN_CC from this one to to Fo_2_QN_CC till Fo_6_QN_CC. The jump from one to the next one is working, but the db dont would like to save the record (the datas which I add). The last question is the question 1-6 d_optima, on this I add an event after update:
View attachment 119184

But after it it comes the error:
View attachment 119183

Questions:

1) How can I save the input?
2) How can I check the input, if the input of the 4 questions are higher or less of 100% the worker has to redu the input?
3) After jump to "open next window" buttom, the last window need to be closed, this is also not working with the same error massage?

I guess thats a peanuts for some one who do it every day. Please help me, attached I have as well the database, the start window for the database is fo_0_QN_CC. Please be so kind and help a old men. Thanks in advance.

Hi
Your best layout for what you are trying is a Tabbed Subform.

See the attached example.