I have a tutorial program that consists of many forms which are all linked by control buttons ( next page, previous page, etc.). I have a password textbox linked to a data control which querries and saves data to an Access database.
when the user enters the correct password, a time/date stamp in entered in the database (and corresponding textboxes) and the program opens. Their passwords are "saved" are bookmarked by the following code:
Dim CurrentPassword as String
Current = Data1.Recordset.Bookmark
If Data1.Recordset!TimeIn1 = "TimeIn" Then
Data1.Recordset!TimeIn1 = Now
NextForm Form1, FrmEntry
and so on . . . . .
. When the user exits the program, they are prompted to enter their password once again and another time/date stamp is entered in the data base (and corresponding textboxes) using similiar code. I have a special password to access the textboxes which are linked to the data control and which allow me to add/delete passwords and view the time/date stamps for each password. This system allows me to keep track of the time the students spend on the program. What I want to do is keep track of how much of the tutorial program the students complete. I have attempeted this by adding code to the exit button for select parts of the program. When they exit the comand button executes the following code:
CurrentPassword = Form1.Data1.Recordset.Bookmark
Form1.Data1.Recordset!Lesson1 = "Yes"
And on the next form, etc. . . .
By viewing the texboxes corresponding to the various lessons, I can tell which students have completed which lessons. At long as their is only one password, this works great. However, when I enter all the students passwords into the database, the program can't keep track of the passwords with the Data1.Recordset.Bookmark. Instead, the program assigns the "Yes" for the completed lesson to whichever password is at the "top" of the list in the database instead of searching out the password which is in use. I've tried a lot of different ways to get the program to "remember" the password but to no avail. Help! Please bear in mind that I am a newbie programmer so keep you explanations simple or provide some code if possible. I'm sorry for such a long explanation but I wanted to communicate clearly what works and what doesn't. I'm sure there is a simple solution for this problem. Thank you in advance for you help.