Hello everybody,
It's a really nice day but I can't get out into my garden because this problem is DRIVING ME MAD!
The message, "The process cannot access the file because it is being used by another process" is familiar to many, judging by a search of the message board. Try as I might, though, I can't track down what is causing it in part of a payroll system I am working on. I would be very, very grateful for any help you can give me, probably by telling me what a stupid and obvious mistake I have made.
I've zipped up a small subset of the application. Please open the database called "database". This should ask you for a password. Type "test" (no quotes).
You now have an empty screen, with File, Utilities and Help as drop-down menus.
Click File and then click Employees. This will take you to a form for maintaining employee records. Don't do anything for now.
Click the Close button (bottom right). Now, from the drop-down File menu, select Weekly processing, then View pay records (there are no other options as I've removed them). In the dialog-type box, accept the default date and click Continue. This will take you to a form called Pay records. Just click the Close button (bottom right) as before, then Close the dialog box.
OK. Now repeat the above, but when you are in the first (employee maintenance) form, click the little arrow graphic which is at the very top-right of the form, next to where it says Displaying current. Pressing this displays All employee records, including those who have now left this employment.
Now go back to the drop-down and select Weekly processing then View pay records and then the Continue button. It is here that I get the error. The difference is that, in the Employee maintenance form clicking the little arrow graphic re-indexes and filters the EMPLOYEE table. Everything else works perfectly. A second attempt to access the Pay records form usually works.
If you click the Help drop-down you can click Debug to go to the Control Panel. The employee maintenance form is called empMaint. You can look at my code attached to the "little arrow" there. The dialog-type box (where you input the date) and the Pay records form are called weeklyGetDate and weeklyCalc, respectively.
I'd be really grateful for any suggestions.
Thanks in advance,
Martin.
It's a really nice day but I can't get out into my garden because this problem is DRIVING ME MAD!
The message, "The process cannot access the file because it is being used by another process" is familiar to many, judging by a search of the message board. Try as I might, though, I can't track down what is causing it in part of a payroll system I am working on. I would be very, very grateful for any help you can give me, probably by telling me what a stupid and obvious mistake I have made.
I've zipped up a small subset of the application. Please open the database called "database". This should ask you for a password. Type "test" (no quotes).
You now have an empty screen, with File, Utilities and Help as drop-down menus.
Click File and then click Employees. This will take you to a form for maintaining employee records. Don't do anything for now.
Click the Close button (bottom right). Now, from the drop-down File menu, select Weekly processing, then View pay records (there are no other options as I've removed them). In the dialog-type box, accept the default date and click Continue. This will take you to a form called Pay records. Just click the Close button (bottom right) as before, then Close the dialog box.
OK. Now repeat the above, but when you are in the first (employee maintenance) form, click the little arrow graphic which is at the very top-right of the form, next to where it says Displaying current. Pressing this displays All employee records, including those who have now left this employment.
Now go back to the drop-down and select Weekly processing then View pay records and then the Continue button. It is here that I get the error. The difference is that, in the Employee maintenance form clicking the little arrow graphic re-indexes and filters the EMPLOYEE table. Everything else works perfectly. A second attempt to access the Pay records form usually works.
If you click the Help drop-down you can click Debug to go to the Control Panel. The employee maintenance form is called empMaint. You can look at my code attached to the "little arrow" there. The dialog-type box (where you input the date) and the Pay records form are called weeklyGetDate and weeklyCalc, respectively.
I'd be really grateful for any suggestions.
Thanks in advance,
Martin.
Comment