Separate speaker notes to accompany AccessFind

Slide #1:

This will show the internal code to deal with the FIND program covered in a prior class.

Slide #2:

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.

Slide #3:

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.

Slide #4:

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.

Slide #5:

Both rsStucourse00 and rsCourse00 are using data from a table as opposed to selecting information from the table with SQL.

Slide #6:

This shows the find of a student.

Slide #7:

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!

Slide #8:

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.

Slide #9:

This shows the output that resulted from entering 222 as ID # and then clicking on Find.

Slide #10:

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.

Slide #11:

This shows the combo box instead of the list box. Also note that there is no binding in the properties.

Slide #12:

With the combo box, I needed to use Space to separate columns instead of the vbTab used in the last example.