Hi All,
I have created a form which at some point will have users input items. it is basically recording how long does the user handle a task. it has start/stop button for timestamp.
the stop commandbutton will essentially do the below:
- Check if the listbox shows complete
- Open the dump file
- dump the data in the dump file
- save the dump file
- close the dump file
however, the form will be utilized by a group. each of them are dumping in the same dump file to minimize error in collating all data as each user may handle more than 100 entries each day.
My analysis is, the stop command button should be able to check as well if the dump file (RawDumpTask.xlsx) is open to other user, if so then it should wait till it closes and then do the actions in the list above. is this doable? in my research it says it is. below is the code I used.
The problem?Please Login or Register to view this content.
It seems like it is not doing it, i mean if the file is open from another user, it is waiting for the file to be closed then perform the task on the list but then again ask the user if he want's to override the changes made by other users. in which case, all changes will be lost. secondly, it seems when the same task were perform the second time, there will be an error. it will say that the file already existed and all changes will be lost (I am thinking that the dump file is not being closed properly - ).
Please help.
Thanks,
John
Bookmarks