Hi,
I've runned into some other problems with my database. I hope someone can help me.
My first problem is: I have two forms, one is Activiteiten(activities) the other Medewerkers(people). In Activiteiten I have a dropdownlist with all the workers from Medewerkers. There is a field on both forms, 'geplande tijd'(planned time), which when entered on activiteiten should change on Medewerkers too(both forms are open on the same time) The data for both forms comes from two different tables. But I have no clue how to do this. I've tried it with an add-query but it generated new records which is not good. And I've tried it in Visual Basic, but that didn't work either.
My second problem is how to make a graph with time on the x-scale. I want to have a sum of all time needed for an activity in a graph, but Access says that a date/time field can not be summed. How do I do this?
Thanks in advance,
Florens
I've runned into some other problems with my database. I hope someone can help me.
My first problem is: I have two forms, one is Activiteiten(activities) the other Medewerkers(people). In Activiteiten I have a dropdownlist with all the workers from Medewerkers. There is a field on both forms, 'geplande tijd'(planned time), which when entered on activiteiten should change on Medewerkers too(both forms are open on the same time) The data for both forms comes from two different tables. But I have no clue how to do this. I've tried it with an add-query but it generated new records which is not good. And I've tried it in Visual Basic, but that didn't work either.
My second problem is how to make a graph with time on the x-scale. I want to have a sum of all time needed for an activity in a graph, but Access says that a date/time field can not be summed. How do I do this?
Thanks in advance,
Florens
