Recent content by 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...

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.

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...

Hello, Attached is a sample DB of how I thought to program is. Hope to receive some tips how to solve the problem of changing colors of all fields in stead 1 field.

Hi, the colors do change in my form but the field changes for all records as the field has the same name for all records. i have 5 employers now (future max 10) so max records is 5 x 365 routines. I can program this in VBA but then I think this will cause some problems. I use an on/of switch...

Hello Rx, In addition, the form is finished already only the color issue need to be solved. Is there a VBA routine do do this? Do while or somthing like that? The current form shows the option values 0 or -1 false or true, but as all fields have the same name for all collegues the color lines...

Hi, Yes in a way I am. It must be integrated with an overview of all projects currently under work and devided over my collegues depending on their agenda. So a standard scheduler as stand alone is not an option unfortunately. I did check some templates so far. In the end the whole project must...

Hello all, I am facing some problems with the following. I want to update fields a file called Tbl_Cap[acity_per_month (related to a file Tbl_Werknemers) using colors (green and red) to show peoples available to handle new projects. I have created 3 (three) files which are related. Currently I...

My name is Peter van Tilburg. I am contractmanager for the Dutch Government. I started using MS Access back in 1985. Before starting with MS Access I worked with dBase 3+. Over the years, I have been working with the various versions of Access but never got into VBA basics. Solving any issues...