End If End Sub
Private Sub Command2_Click() Dim strql As String
Set db = OpenDatabase(App.Path + \
strsql = \·¿ÎÝ»ù±¾ÐÅÏ¢ (סַ,É豸,·¿Îݽṹ,·¿ÎÝÃæ»ý,³öÊÛÐÅÏ¢) values ('\Text1.Text + \Text5.Text & \db.Execute strsql db.Close Text1.Text = \Text2.Text = \Text3.Text = \Text4.Text = \Text5.Text = \MsgBox \Ìí¼Ó³É¹¦\End Sub
Private Sub Command3_Click() Dim strsql As String
If MsgBox(\ÊÇ·ñÒªÐ޸Ĵ˼Ǽ\ÐÞ¸Ä\Set db = OpenDatabase(App.Path + \
strsql = \·¿ÎÝ»ù±¾ÐÅÏ¢ set סַ = '\É豸 = '\\·¿Îݽṹ = '\·¿ÎÝÃæ»ý = '\³öÊÛÐÅÏ¢='\Text5.Text + \End If
db.Execute strsql db.Close Text1.Text = \Text2.Text = \Text3.Text = \Text4.Text = \Text5.Text = \MsgBox \Ð޸ijɹ¦\End Sub
Private Sub Command4_Click() Dim strqsl As String
Set db = OpenDatabase(App.Path + \
strsql = \·¿ÎÝ»ù±¾ÐÅÏ¢ where סַ = '\db.Execute strsql Text1.Text = \Text2.Text = \Text3.Text = \Text4.Text = \Text5.Text = \MsgBox \ɾ³ý³É¹¦\End Sub
Private Sub Command5_Click() Form5.Show Unload Me End Sub
Private Sub Command6_Click() frmMain.Show Unload Me End Sub
Private Sub Form_Load() Dim strsql As String
Set db = OpenDatabase(App.Path + \ strsql = \·¿ÎÝ»ù±¾ÐÅÏ¢\ Set rs = db.OpenRecordset(strsql) End Sub
4.5 ÎïÒµÊշѹÜÀíÄ£¿é
ÎïÒµÊշѹÜÀíÓÃÊǶÔÐ¡ÇøÄÚÎïÒµÊշѵÄ×ܹÜÀí£¬Ö÷Òª¹¦ÄÜÒ²ÊǶÔÈç (סַ¡¢Ë®·Ñ¡¢µç·Ñ¡¢¿í´ø·Ñ¡¢ÎïÒµ¹ÜÀí·Ñ¡¢ÊÕ·Ñʱ¼äµÈÐÅÏ¢) µÄÌí¼Ó¡¢Ð޸ġ¢É¾³ý¡¢²éѯ¼°Í³¼Æ¼Ç¼¸öÊý¡£Ìí¼Ó¡¢Ð޸ġ¢É¾³ýÕâЩ²Ù×÷±ØÐë±£´æºó²ÅÄÜÉúЧ¡£¼Ç¼½Ï¶à£¬Í¨¹ý¼òµ¥µÄ²éѯ¿ÉÒÔ·½±ãµÄÕÒµÄÄ¿±ê¼Ç¼£¬²éѯ½á¹ûÒѱí¸ñ·½Ê½ÏÔʾ¡£±í¸ñÏÔʾ½á¹ûµÄͬʱ£¬Èç¹û»¹³öÏÖ¶àÌõ¼Ç¼£¬¿ÉÒÔ¸ù¾Ýij¸ö×ֶζԼǼ½øÐÐÅÅÐò£¬ÕâÑù¿ÉÒÔ¸øÓû§´øÀ´¸ü´óµÄ·½±ãºÍÌá¸ß²éÕÒЧÂÊ¡£
½çÃæ½ØÍ¼ÈçÏÂ:
±¾Ä£¿é´úÂëÈçÏ£º
Private Sub Command1_Click() If rs.EOF = False Then Text1.Text = rs(\סַ\ Text2.Text = rs(\Ë®·Ñ\ Text3.Text = rs(\µç·Ñ\ Text4.Text = rs(\¿í´ø\ Text5.Text = rs(\À¬»øÇåÔË·Ñ\ Text6.Text = rs(\ÎïÒµ¹ÜÀí·Ñ\
Ïà¹ØÍÆ¼ö£º