How to let user update multiple data at once

[xaxier]

Hi guys,

I have created a new form based on the set of database. The problem is that the end users on my company would like to multiple update at once.

For example, User John have task A, B and C and for the task completion date, he wanted to update the task A, B and C under the same date ( since he completed the same time). At this point, my form only allowed update task by task and will not allowed multiple update at once. Is there anyway to let User John to update task A, B and C at once. This will make more sense when you are looking at 300 tasks and he need to update the task completion date 300 times?

thanks in advance

 

[John Big Booty]

How does the user determine which task he has completed?

 

[xaxier]

How does the user determine which task he has completed?

Easy, the moment he/she had completed his task, he/she just update it as done. To make it clearer, at this moment, the users are using excel, he/she just filter it by undone task and update it all at once ( excel allow drag the data along the column but not for access). Using access will definitely add in their work load since now they have to update it task by task instead of all at once ( in excel, by filter and drag)

 

[John Big Booty]

You could add a Yes/No field to your table, and filter all the users uncompleted tasks into a continuous sub-form, the user could then check the tasks that he has completed and then click a button that runs and update query based on the checked Yes/No field, and also set the Yes/No field back to unchecked.

 

[xaxier]

Hi John Big Booty,

Thanks a lot for your suggestion. Hope you will bear with me cause of my near to 0 level knowledge in programing. I have another question, as I have created a frontend form that will open the task form and it contained the following code.

Private Sub cmdOpenSecondForm_Click()



DoCmd.OpenForm "Multiple_update", , , "[LoginID] = '" & fOSUserName & "'"

End If
End Sub

this command is actually meant to enable the user to open the form and filter it according to his/her NT login in the network. If I need to add in extra step where I will filter by the task undone ( using a Yes/No datatype for the task) so that the user when click on this button, he will open his filtered open task ( Is not Selected in the checkbox) , how should I put this in? Can you please provide me an example code on how this suppose to run? I am seriously have no idea at all

 

[xaxier]

Hi guys,

any idea or solution?