I have been working on this project for more than a year now. I only attended one Hands-on VB6 class, and I designed the application using a MSFlexGrid and making it work like a worksheet. I use text fields. Combo, and DatePicker objects on top of the flex grid to enter and modify data. The user enters the date (Datepicker), the user id defaults to the Login, time from and to, Leave descripton (Combo), the Contact Nbr, and Contact Name. I had my colleagues test the program, and they always find bugs on it. I'm using random access file to store the records.
The program works fine if the user enters data in sequence from left to right, won't click the fixed rows, or any unusual clicking on the flex grid. Of course, that is not acceptable.
I need your opinion on whether I should just change the program so that the MSFlexGrid is used only for display, and let the editing on separate text fields outside of the grid.