Introduction Þ Visual Basic is a tool that allows you to develop Windows (Graphic User Interface – GUI ) applications. The applications have a familiar appearance to the user. Þ Visual Basic is event-driven ; event driven meaning code remains idle until called upon to respond to some event (button pressing, menu selection). Visual Basic is governed by an event processor. Þ The original Visual Basic for DOS and Visual Basic for Windows were introduced in 1991. Steps in Developing Application There are three primary steps involved in building a Visual Basic application: 1. Draw the user interface 2. Assign properties to controls 3. Attach code to controls Rule for Variable Variables are used by Visual Basic to hold information. Þ No more than 40 characters Þ They may include letters, numbers, and underscore (_) Þ The first character must be a letter Þ You cannot use a reserved wor...
Save, Edit and Delete Example into Access Database Using VB6.0 ‘——————————————————————- ‘ Instraction For Safe Project Load ‘ Components Add Your Project ‘ 1) Add Microsoft ADO Data Control 6.0 (OLEDB) ‘ 2) Add Microsoft Windows Commom Controls-2.6 Your Project ‘——————————————————————- Dim db As ADODB.Connection Dim rst As ADODB.Recordset Dim id As Integer Private Sub Form_Load() ‘Open Database Connection Set db = New ADODB.Connection db.Open “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\s4sajoy SampleCode\SampleDB.mdb;Persist Security Info=False” Set rst = New ADODB.Recordset rst.Open “select * from tblSample Order By SerialNo DESC”, db, adOpenStatic, adLockOptimistic, adCmdText If rst.RecordCount = 0 Then id = 1 Else id = rst(“SerialNo”) + 1 End If rst.Close lblID.Caption = id End Sub Private Sub cmdAdd_Click() If Trim(txtName.Text) = “” Then MsgBox “input name”, vbInformation Else Set rst = New ADODB.Recordset ...