Experience summary of Student information management system

After the database video has been read, the actual operation of the Red Book on the five examples. After the example is done, the impatient start of the Student information management system, straight

The Student information management system to do intermittent. While working on the Student information management system, there are five examples to be remembered on one side.

As a result, the Student information management system front was dragged for up to two weeks. In the middle of both English learning, as well as a summary of database examples. It's all done, though.

, but it feels bad. So next time, be sure to finish one thing before you start the next thing.

And in the knocking system, made a big mistake, is a one-time knock out all forms, and then adjust the interface debugging error. It turns out

I don't know where to look at the beginning of the mistake, besides, there must be a correlation between the forms. A form error can cause several forms to be affected, so

Be sure to remember that the next time you do the program, be sure to knock out a form, debug a form, debug after the next form.

It solves several important problems in the process of Student information management system:

One: Database connectivity issues.

The system is done, packaged, and tested well. After repeated testing on your own computer, there is no problem, after that, go to the computer room test

As a result, the results database is not connected.

Also thought is the computer room computers do not have a network, so can not access the database, and later in the classmate computer test, but also not connected. Again in their own

Test on a computer, or no problem. Finally know the remote access to the computer, the connection database is not its own computer name, is the computer's IP address.

After the change, once again installed in the school computer, very sure to be able to connect this time, the results let me disappointed, find a lot of information is not resolved

Later asked Master to help solve, ah yo, is to put the security on the computer to close .... The result goes in ...

Other computers accessing the database on my computer must be a breach of security. It was intercepted, so there's no sign-up. When accessing a database offsite,

Be sure to turn off security on your computer.

Second: The first acceptance problem.

1, the form title has not changed, there is one or Form1.

The 2,list list box can only be selected for not filling.

3,msgbox prompt box, when prompted to successfully operate, should not be the exclamation prompt.

4, each form pops up, the size ratio should be appropriate, the position should be consistent.

5, judge the password consistent inconsistent, should not use the trim function.

6, after setting the MsgBox prompt, to unload the form, either, just handle it and empty the previous operation.

7, text box input to add a limit, limit the length of the input string.

8, there is a parent form, and the rest should be subforms.

It was a very low-level mistake to make a mistake this time. You can avoid it if you use a snack. Don't overlook these little details. Details determine success or failure.

Three: Two change issue:

The above problem is easy to solve, when changing the style of the list box. Got into some trouble.

To make the list select only the contents of the drop-down list box, you can only set its Style property value to 2. But this in the run Times error, prompting to say text

property is read-only. Looking for a reason, the result is a list assignment in the code (call Viewdate). In Viewdate, set the Recordset object objRS the recordset

Value is assigned to the List.text. This conflicts with the style read-only property.

Problem solving: Define a function that returns the index value of the corresponding string in the combo control.

' *************************************************************************
' * * Function name: GetIndex
' * * Output    In: Combo (ComboBox)        -
' * *        : ByVal strvalue (String)-
' * * output    : (Integer)-
' * * Function Description: Returns the index value of the corresponding string in the combo control
' * *:    Li Di
' * * Date    : 2012-08-21
' * * Modified by:
' * * Date    :
' * * Version    : V1.0.0
' *************************************************************************
public Function GetIndex (combo as ComboBox, ByVal strvalue as String) As Integer
    Dim index As Integer
    
    If combo. ListCount <= 0               Then ' if there is no content, then return-1
        getindex =-1
        Exit Function
    End if for
    
    index = 0 to combo. ListCount-1       ' traverse the entire list box
        If trim (strvalue) = Trim (combo. List (index) then
            getindex = Index
            Exit function
        End If
    Next
End Function

When you assign a value, the function is called directly.

Cmbgrade.listindex = GetIndex (Cmbgrade, M_rstclassinfo. Fields (1). Value)

There is also a problem, if, when the form is loaded, the list box does not load, and the program runs, it still goes wrong. So

To load the list contents in the Load event.

Also, the startposition of the form is not valid after the other form is a subform. So how do you make the form centered?

Workaround: The property cannot be set, then write two lines of code.

Me.left = (screen.width-me.width)/2       ' around center
me.top = (screen.height-me.height)/2      ' Up/down Center

When the second acceptance, there is no problem. Oh.

Student Information Management system. Exposed a lot of problems, know a lot of deficiencies. Learn a lot from it, and harvest a lot.