Experience summary of Student information management system

After the database video has been finished, the actual operation of the Red Book on the five examples. After the example is done, the student's information management system is started in a hurry, straight

The resulting student information management system is done intermittently. While doing the student information management system, one has to remember five examples.

As a result, the Student information management system has dragged on for up to two weeks. There are both English learning in the middle and a summary of database examples. It's all done, though.

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

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

Wrong start don't know where to find, and, after all, there must be links between the forms. A form error can cause several forms to be affected, so

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

The process of doing student information management system solves several more important problems:

One: Database connectivity issues.

The system is done, pack it up, and test it yourself. No problem after repeated tests on your computer, then go to the computer room to test

As a result, the resulting database is not connected.

Also thought is the computer room has no network, so can not access the database, and later on the classmate computer test, also so not connected. Again in their own

Test on the computer, there is 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.

Modified, once again installed in the school computer, very sure this time will be able to connect, the result is disappointing to me, looking for a lot of information are not resolved

Then asked Master to help solve, ah yo, is the computer security to shut down ... The result goes in ...

It's definitely against security for other computers to access the database on my computer. It was intercepted, so there was no sign up. When you access a database offsite,

Be sure to turn off security protection on your computer.

Second: The first acceptance question.

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

The 2,list list box can only be selected and cannot be filled.

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

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

5, to determine the consistency of the password is inconsistent, should not use the trim function.

6, set the MsgBox prompts, to uninstall the form, or, to deal with, empty the previous operation.

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

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

It's a very low-level mistake to make a mistake this time. As long as you use snacks, you can avoid. Don't overlook these little details. Details determine success or failure.

Three: two change questions.

The above question is easy to solve, in which the list box's style is changed. 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 wrong, prompted to say text

property is read-only. Find the reason, and the result is to assign a value to the list in your code (call viewdate). In Viewdate, a Recordset object is objRS a recordset

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

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

' *************************************************************************
' * * Function name: GetIndex
' * * lost    Into: Combo (ComboBox)        -
' * *        : ByVal strvalue (String)-
' * * output    : (Integer)-
' * * Function Description: Returns the index value of the corresponding string in the combo control
' * *    : Li Di ' * *
days    : 2012-08-21 ' * *
modified person:
' * * days    :
' * * 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, 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, you call the function directly.

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

This will also cause a problem if, in form load, the list box does not load content, and the program runs without error. So

In the Load event, load the list contents.

Also, the startposition of the form is invalid after the other form is the subform. So how do I make the form center display ...

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

Me.left = (screen.width-me.width)/2       ' centered
me.top = (screen.height-me.height)/2      ' Center up and down

The second acceptance of the time, there is no problem. Oh.

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