hwmueller
Technical User
- Jan 16, 2001
- 155
Hi
I am currently programming a database which involves students entering their student id (primary key) and name. Followed by this they have to select their modules from two tables – one for each semester. Each table has 7 checkboxes and each module or checkbox is allocated either 10 or 20 credits. The student has to select 30 credits per semester. Thus the constraints per semester are that should the student select more than 30 credits an error message will be displayed asking the student to revise his or her selection. Also some modules cannot be selected together as they share similar material. Once again an error message appears. Now to my problem!
To start the code which validates the selections the user clicks a button called ‘submit’. If all is selected properly a second message box should appear displaying the user’s selections and an OK or REVISE button. If OK is clicked then the record is stored in the tables and a new record (DoCmd.GoToRecord, , acNewRec) is opened for the next user. If REVISE is selected the user should be able to make the required changes. Clicking submit again will start the process over. Similarly if an error has been made, for example more than 30 credits selected, the user should be able to return to the form to make those changes after clicking OK on the message box displaying the error. How do I program the above????!!
Thanks very much to whoever takes the time to give this a go!
Hans
I am currently programming a database which involves students entering their student id (primary key) and name. Followed by this they have to select their modules from two tables – one for each semester. Each table has 7 checkboxes and each module or checkbox is allocated either 10 or 20 credits. The student has to select 30 credits per semester. Thus the constraints per semester are that should the student select more than 30 credits an error message will be displayed asking the student to revise his or her selection. Also some modules cannot be selected together as they share similar material. Once again an error message appears. Now to my problem!
To start the code which validates the selections the user clicks a button called ‘submit’. If all is selected properly a second message box should appear displaying the user’s selections and an OK or REVISE button. If OK is clicked then the record is stored in the tables and a new record (DoCmd.GoToRecord, , acNewRec) is opened for the next user. If REVISE is selected the user should be able to make the required changes. Clicking submit again will start the process over. Similarly if an error has been made, for example more than 30 credits selected, the user should be able to return to the form to make those changes after clicking OK on the message box displaying the error. How do I program the above????!!
Thanks very much to whoever takes the time to give this a go!
Hans