Separate speaker notes to accompany AccessFind
This will show the internal code to deal with the FIND program covered in a prior class.
Please note that this is a revised version.
There is no binding of data to the database through properties. It is all done in the code.
This slide shows the DIM statements in the general area and the beginning of the Form_Load. Note that the Form_Load continues for the next two slides.
Refer to the previous example for explanation of features that were covered there.
Note that rsStudent00 contains data through a SQL SELECT while rsMajor00 contains data in the major00 table.
Both rsStucourse00 and rsCourse00 are using data from a table as opposed to selecting information from the table with SQL.
This shows the find of a student.
Again remember the very good technique of adding an empty string to fields from a database that is being put into a text box. It is a technique that I do not always follow but it is a good habit to get into!
Now I am getting information from the rsStucourse00 recordset and related information from the rsCourse00 recordset.
Note that two ways of specifying a particular course are illustrated. One is .Fields("coursecd") and one is !coursecd.
For further information on this logic, please try the original presentation.
This shows the output that resulted from entering 222 as ID # and then clicking on Find.
This shows the output using the combo box. If a course is selected, it will show in the combo box when it is not open.
This shows the combo box instead of the list box. Also note that there is no binding in the properties.
With the combo box, I needed to use Space to separate columns instead of the vbTab used in the last example.