Training Database issue

[Guest]

I am designing an induction database, there are numerous forms that all open
up powerpoint presentations and excel spreadsheet for tests. These are all
designed and work well, however I want to have a record of who has done what
training module, to do this I would like a front form where a student selects
their name from a combo box, or if it is not there (they have not done
training before) the enter their name in a box.
Then when they progress through the other forms I want it to update my one
table which has pupil name, and the various training modules with yes/no
options in each one. if it is easier I could have it so it was a 0 for not
doing training and a 1 for completed module.

I imagine some code on the NEXT button between modules would be best to
update the record. Any advise on how to do this would be great as I am
stumped.

 

[Larry Linson]

If the students are logged in with their own network ID, you can use the API
code at http://www.mvps.org/access/api/api0008.htm to retrieve their network
name so they don't have to log in again.

If, of course, they are just using a shared computer already logged in with
a common ID, you'll need to include login features.

As you really did not describe the navigation mechanism, it would be
difficult to give any specific advice. Assuming you can do minimal VBA Data
Access Objects code, you can write code to update the test record at a point
when you know, or can reasonably assume, that the student has completed a
test/function.

Larry Linson
Microsoft Access MVP

 

[Guest]

Hi,

Thanks for you reply.
I would not be confident that the student would have their own network log
in as they would only just have started.
to clarify the navigation issue:

There will be a main switchboard which will be a choice of reports and a
begin training button, once the training button is clicked it will drop to a
new form that will be a input box and a combi box, if the student has had
training before they select their name from the combi box, if not they enter
it in the input box, I would like this to create a record or edit a record
depending on which meathod they use. They will click next and go to another
form which will be the main training switchboard, from there they will select
from either full training or pick a module they would like to cover there
choice drops them to another relivant form, this form has a button to launch
the training, once they have clicked on launching the powerpoint presentaion
I feel it is a safe bet that they have completed the training. so I would
really like more info about how to set up the record editing when they have
completed each module and also the main slection of thier name so that all
other actions they do only update their record. the table structure is as
follows:

Pupil number (Primary key), pupil name (this is what will be keyed/selcted
from the list), environmental (yes/no), h&s (yes/no), manual handling
(yes/no).

Hope this helps a little, if not please let me know what is needed.
Thanks!