bootwalker
New member
- Local time
- Today, 15:07
- Joined
- Apr 19, 2013
- Messages
- 7
Hi there, I have some troubles in one of my forms, in fact what i'm about to explain could be impossible to realize. Let me illustrate with the image on this link to show you the form : ht tp://hpics.li/017d706 (ht and tp seperatet to post the link in my 1st post^^)
My database has a few tables like customer, project, task, user, hours etc..
Uses have to log their working hours on a specific task of a project.
What they currently can do is add a log one at the time. What I would like is to create a form that allows the user to add multiple logs at once and to modefy existing ones.
These logs are savec in the table Hours (IDEntry, Entry date, hours, task, User, comment)
Now, to the form shown in the link above:
The User selects a Month in the combo box (usually the current month). The entry date labels automatically updates according to the month. What the form should do is to load the already existing records in the correct boxes. The user can then modefy them or add new ones in the empty boxes.
What I managed to do so far is to get the info in the boxes with a DLOOKUP function in the control source of every textbox. This is not the solution because the DLOOKUP does not allow to modefy data.
I also tried to bing the textboxes to a query record with the entry date label as criteria and that doesn't work either.
Now I am wondering if that is even possible to realize. Could someone point me in the right direction please, that would be great.
Thank you
My database has a few tables like customer, project, task, user, hours etc..
Uses have to log their working hours on a specific task of a project.
What they currently can do is add a log one at the time. What I would like is to create a form that allows the user to add multiple logs at once and to modefy existing ones.
These logs are savec in the table Hours (IDEntry, Entry date, hours, task, User, comment)
Now, to the form shown in the link above:
The User selects a Month in the combo box (usually the current month). The entry date labels automatically updates according to the month. What the form should do is to load the already existing records in the correct boxes. The user can then modefy them or add new ones in the empty boxes.
What I managed to do so far is to get the info in the boxes with a DLOOKUP function in the control source of every textbox. This is not the solution because the DLOOKUP does not allow to modefy data.
I also tried to bing the textboxes to a query record with the entry date label as criteria and that doesn't work either.
Now I am wondering if that is even possible to realize. Could someone point me in the right direction please, that would be great.
Thank you
