Student information management system experience summary

 

 

After reading the database video, we will start to use the five examples in the Redbook. After the example is completed, the student information management system started in a hurry.

The student information management system is interrupted. While working on the student information management system, I still have to remember five examples.

 

As a result, the front line of the student information management system dragged on for two weeks. There are both English learning and database examples. All completed

But it does not feel good. So next time, you must finish one thing before you start the next thing.

In addition, when typing the system, I made a big mistake: I knocked out all the forms at a time and adjusted the interface debugging error. The result is displayed.

At the beginning of the error, I don't know where to find it. Besides, each form must be associated. A form error may affect several forms.

Remember, the next time you program, you must complete a form, debug a form, and then proceed to the next form.

 

 

The student information management system solves several important problems:

 

I. database connection problems.

 

After the system is finished, it is packaged and tested on its own. No problem after repeated tests on your computer. Then, go to the computer in the data center to test

As a result, the result database cannot be connected.

 

I thought that the computer in the IDC had no network, so I could not access the database. Later I tested it on my classmate's computer, and I still couldn't connect. Again in your own

Test on the computer. At last, I know that when I remotely access a computer, the database is not my computer name, but the IP address of the computer.

 

After the change, I installed it on the school computer again. I am very sure that the connection will be available this time. As a result, I was disappointed and found a lot of information to solve the problem.

Later, I asked Master to help solve the problem. Alas, it was to disable the security protection on the computer ....... The results will go in...

 

Accessing the database on my computer from other computers is definitely a violation of security. It is intercepted, so no logon is performed .. When accessing the database remotely,

Be sure to disable security protection on your computer.

 

Ii. First acceptance issues.

1. The Form title has not been changed, and either is form1.

2. The list can only be selected and cannot be entered.

3. msgbox prompt box. when the operation is successful, no more exclamation point is prompted.

4. When each form is displayed, the size ratio should be appropriate and the position should be consistent.

5. Check that the passwords are consistent and do not use the trim function.

6. After setting the msgbox prompt, uninstall the form or clear the previous operation.

7. limit the length of the input string to be added in the text box.

8. There is a parent form, and the rest should be child forms.

 

This mistake is a very low-level mistake. As long as you use snacks, you can avoid them. Do not ignore these small details. Details determine success or failure.

 

 

Iii. Secondary change problem ..

 

The problem above is easy to solve, where when you change the style of the list box. I encountered some trouble.

To make the list only select the content in the drop-down list box, you can only set its style attribute value to 2. In this case, an error is reported, indicating text.

Read-only attribute. Find the reason. The result is to assign a value to the list (call viewdate) in the code ). In viewdate, recordset object objrs record set

The value is assigned to list. Text. This conflicts with the style read-only attribute.

 

Solution: define a function and return the index value of the corresponding string in the combo control.

 

'*************************************** * ************************************ Number of letters: getindex' ** input: Combo (ComboBox)-'**: byval strvalue (string)-' ** output: (integer)-'** function description: return the index value of the corresponding string in the combo control. *** OPERATOR: Li Shuang yao' ** Date: 2012-08-21 '** modifier:' ** 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 no content exists,-1 getindex =-1 exit function end if for Index = 0 to combo is returned. listcount-1 'traverse the entire list box if trim (strvalue) = trim (combo. list (INDEX) Then getindex = index exit function end if nextend Function

 

When values are assigned, the function is called directly.

 

cmbGrade.ListIndex = GetIndex(cmbGrade, m_rstclassinfo.Fields(1).Value)

 

In this case, a problem occurs. If the content in the list box is not loaded when the form is loaded, an error will still occur when the program is running. Therefore

Load the list content in the load event.

 

Also, after the other forms are child forms, the startposition of the form is invalid. In this case, how can we make the form center display ..

 

Solution: If the attribute cannot be set, write two lines of code.

 

Me. Left = (screen. Width-Me. width)/2' center me. Top = (screen. Height-Me. Height)/2'

 

 

There was no problem during the second acceptance. Haha.

 

 

Student information management system. Many problems are exposed and many shortcomings are identified. I learned a lot and gained a lot from it.