By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

Complete form only once for an individual.

P: 36
I have a form listing all students in an Access 2003 database. One control button [Initial Assessment] next to each students name has a macro which opens a new form designed specifically for the initial assessment. It also sets values in the new form, taking the Students ID, Forename, Surname, Course from the previous form listing all students. This was to reduce the re-typing of the same data.

As initial assessments are only intended to be done once. Is there some way i can alter my macro or add something to ensure that each student can only have one initial assessment done as it would only be when running the report that you find out if the student has had their initial assessment entered more than once.? The data for the initial assessment is stored in a table [tblinitass]

Any help would make life easier.

Croston Scottish
Oct 17 '07 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
I have a form listing all students in an Access 2003 database. One control button [Initial Assessment] next to each students name has a macro which opens a new form designed specifically for the initial assessment. It also sets values in the new form, taking the Students ID, Forename, Surname, Course from the previous form listing all students. This was to reduce the re-typing of the same data.

As initial assessments are only intended to be done once. Is there some way i can alter my macro or add something to ensure that each student can only have one initial assessment done as it would only be when running the report that you find out if the student has had their initial assessment entered more than once.? The data for the initial assessment is stored in a table [tblinitass]

Any help would make life easier.

Croston Scottish
Hi Croston,

Basically it's against the normalization rules to "move" the Student ForeName, SurName, etc. to a new entry in a [tblinitass]. When you need them, just join the table by the StudentID to extract the needed fields.
For inserting the initial assessment there are also multiple solutions.
I assume there will be more than one assignment and that the assignment data will be rather "similar". Thus a tblAssessments could be used and when defining a Student, the first entry can be inserted automatically when needed.
Personally I would create a Student form with the Assessments as a subform. When the subform is linked, then Access will synchronize the Assessments and fill the StudentID automatically for new entries.

Getting the idea ?

Nic;o)
Oct 17 '07 #2

P: 36
Cheers. I had a feeling that if i couldn't find a way through the macro then it was probably my bad initial design. Back to the drawing board!

Thanks again
Oct 18 '07 #3

nico5038
Expert 2.5K+
P: 3,072
Perhaps my "Object/Action" sample gives a nice template for solving your design problem:
http://www.geocities.com/nico5038/xS...tAction-97.zip

I use it often as a start and give my users also an instruction how to filter and sort:
http://www.geocities.com/nico5038/xR...nstruction.zip

Keep me posted !

Nic;o)
Oct 18 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.