Updating fields in a table

[Peter_Sawasdee]

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 have 5 (five) collegues. The main table (Tbl_Capacity) consists the fields
I created a query from the 3 tables with the following fields:
DayID (Aut), MonthID (Num), EmployerID (Num) and Day01 (Num) up to the field Day31 (Num).
When I create a form based on the qurey the record pointer stays on record 1. When I select a day, the color changes for all collegues. I would like to being able select the availability for all 5 collegues for every day of every month. So I can select an overview per month month and see at what moment per month collegues are available (or not) for new projects.
Hope someone can help me out with this.
Thanks in advance.

 

[Rx_]

A little more clarity would help.
(I resemble that remark myself.)

Are you trying to build a scheduler?
Have you reviewed the Sample Databases section on this forum?
The Sample Databases have often help me get started or get some ideas.
From there, if you get some more specific questions it will increase your odds of responses.
- regards

 

[Peter_Sawasdee]

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 be from a logisticsprojectplan into a purchaseyearplan, capacity of procurement ppl included. For this I would like to know how to use VBA in MS-Access 2007v.
Thanks

 

[Peter_Sawasdee]

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 in VBA is not working. Or should this be solved using macro's?
Thanks.

 

[Rx_]

should be the object.property - then some event to update it. What objects are changing? form, control, button, record...
I do think there are some demo databaes to download from this site that show a color change for an object based on its value.

 

[Peter_Sawasdee]

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 which turns the value of the field to 0 (FALSE) or -1 (TRUE).

 

[Peter_Sawasdee]

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.