I've been trying to create a simple excel system where in I can encode data and saved it to Worksheet Database without overwritting each data, but if file already exist by searching the case id all the information should be appearing to Worksheet Entry and I can able to modify the data and a text "File Exist" will appear. The case id will be the reference id. If file does not exist then I can save all the information entered in Worksheet Entry to Worksheet Database and a text "New file" will appear and it will not overwrite other information in Worksheet Database. In worksheet Pending all the information contained are all in pending status and data will be extracted in Worksheet Database same with Worksheet Closed. If case id#already exist the case id cannot be modified but the other information pertaining to the case id being search can be modified.
Don't know where to start..............:-(
Bookmarks