Selection citeria in tables

[Peter_Sawasdee]

Hello Everyone,

I'm super new to VBA and Access automation tools. I've done more of database creation, and reporting.

Anyhow, any help would be super appreciated.

Objective:
Automate Supplier Selection and Contract Award Citeria, Sub-criteria and Scores of both.

Vision: Using combo boxes that when clicks user is to choose his choice or adding a new criteria, sub-criteria, scores of both included.
Overall the total score of Criteria and Subcriteria should be max. 100%. Adding new criteria should result in equal divided subscore based on the relation of all records in the table(s).
This table will be a template and the users will fill in the project depending criteria to realize a contract awarding proces prior to awarding the contract.

Attempts:
I've tried looking for code, but I just don't understand it well enough since the variables are usually tailored to specific cases.
Tried to transform Access database Noordenwind ('97) but due to very low knowledge of VBA was not a success.

This is a process I'll need to repeat for every procurement proces therefore it would be very important (handy as well) to make this proces more transparent for legal issues.

Anyways, thanks in advance for any help you guys can give me

 

[Frothingslosh]

What the hell? This is more or less a cut and paste of ace2014's "Need Code to Automate ImportExportSpreadsheets", right down to writing style.

 

[Peter_Sawasdee]

Correct. his style is very clear and I wanted to be sure everybody would understand what I wrote. Beside that English is not my native language.
Sorry for using his style but no other reasons than what I wrote above.
Thanks anyway.

 

[Frothingslosh]

Oh, no worries, I was just a bit freaked out there.

Anyway, I think you need to restate what you're looking for, in plain English. Assume the people you're talking to not only know nothing about your business (the references to criteria 'scores', etc), but don't know anything about access. Once we know in plain text what you're trying to do, we can look into helping you implement it.

 

[Peter_Sawasdee]

Hello everybody, suggested by Frothingslosh here is my request in plain (not native), English.

I am looking for assistance to build a database to set up a flexible scoring system for awarding purchase contracts.

Example:
Slection criteria:
such as turnover value, financial stability, experience in the nature of a possible contract, etc.

Contract awarding criteria:
such as technical capacity, certificates required for a possible contract etc.
Awarding contract sub-criteria related to the main selection criteria.

All criteria and sub-criteria to be added into a database shall be filled in for each procurement project as well as the scores/weighing points.
The Program must be able to count the scores and keep main- and sub-criteria in relation with oneanother in order not to exceed max scores/points.

Example:
technical capacity = 50% of the total score of 100%
required certificates 15% of the max of 100%
Experience = 10% of the max of 100%
economical score = 25% of the max of 100%

If the % one of these criteria's is changed the other criteria % must be adapted accordingly with a % so max of all criteria shall stay 100%.

sub-criteria related from and to the main criteria.
Related to technical: % up to the max of 50%
and so on for every possible sub-critaria.
Adding them all together will give the max of 100% in an ideal situation. Independent of the number of criteria records (main and subs) the total shall never exceed the max 100% in the aforementioned ideal situation.
The total % of all Sub-criteria of a main criteria shall not exceed the % of that related main criteria.

If the % one of these sub-criteria's is changed the total of other sub-criteria % of a main citeria must be adapted accordingly with a % so max shall not exceed the % of that related main citeria.

I hope this will help you to help me with a program.
Thanks in advance so far.

Peter