For people dealing with projects and software, apart from the the obligatory Dilbert stuff, I can highly recommend Geek & Poke http://geek-and-poke.com/ . Some of them are absolutely hilarious, some incomprehensible.
I need an example of data because I still suspect some things. 2-3 students, each with different requirements and accomplishments. Just enough to get the gist of how this thing is supposed to work but getting into all corners of this. Your desire of pre-making all those record for each student...
You might want to backup a bit and not getting lost in the finer Access details explain what this is about.
Because I smell something very very fishy here. To assign qualifications/passes your envisaged way, if perceived correctly, is not the customary way of doing such things in Access...
No idea how to manipulate the template, whatever there might be of one. You could always reopen the produced HTML file afterwards as pure text, and line by line replace all CELLSPACING=0 with CELLSPACING=1
I have up/down , but should be the same as next/previous, play with it, call it from Current event handler:
Public Sub SetMoveButtons(MyForm As Form)
With MyForm
If Not .NewRecord Then
.RecordsetClone.MoveLast 'this to get proper record count...
I've personally witnessed over a period of 1½ years how stagiaires and their work were treated in a French high-tech company. Worse than the disposable Mexicans in one of the maquilladoras on the US border.
I hope your company appreciates your efforts more.:D
In any case, after all this BS -...
So our magic eyesight can see all the code you're running and identifies line 42 as the likely culprit.
If you want a better bet, you might consider providing something solid to look at.
This is really a poor and ambiguous formulation. Say what you do and what happens in response to that, never use the totally informationless "I cannot", because that contains no useful information for you helpers.
What office version do you have what pdf reader do you have what windows do you...
These operations you do in a form. No access to tables for users. You have cascading comboboxes (search) and the Not In LIst event for a combo, to insert new stuff. Look in the manual.