harukofumiyo
New Member
Hi i am trying to use excel to create a beautiful database (instead of using Access). i have a workbook with 3 tabs; GPEntryForm, GPResult and GPForm. In the GPEntryForm, this is the user form that user will key in.
(1) However, how can i use the previous, next, save, delete and generate button to record the entry?
Example, if i enter the details in the entry form, when i click next and save, it would save to GPResult tab. If i click on previous, it will show me the previous result (in the GPEntryform).
(2) Also, once i have entered if i clicked on generate, all my details will be in the GPForm and ready to print. When i go to GPForm, i click on the print icon, it will print.
(3) Isnt possible that we could see the entry (GPResult) by clicking previous record/next record button in GPEntryForm tab?
(4) When i click on the delete icon, the entry in the GPResult will automatically delete the particular trainee that was selected in GPEntryForm tab.
Thank you very much!
(1) However, how can i use the previous, next, save, delete and generate button to record the entry?
Example, if i enter the details in the entry form, when i click next and save, it would save to GPResult tab. If i click on previous, it will show me the previous result (in the GPEntryform).
(2) Also, once i have entered if i clicked on generate, all my details will be in the GPForm and ready to print. When i go to GPForm, i click on the print icon, it will print.
(3) Isnt possible that we could see the entry (GPResult) by clicking previous record/next record button in GPEntryForm tab?
(4) When i click on the delete icon, the entry in the GPResult will automatically delete the particular trainee that was selected in GPEntryForm tab.
Thank you very much!
