To delete the Record during runtime
Step 1:
Click the Delete Button if you want to delete a record from the database:
Step 2:
Click the Refresh Button. The current record will be deleted from the database.
To insert the New Record during runtime
Step 1:
You can run the program now. Click the ADD Button to add a new record to the database:
Step 2:
Enter the data in the text box. No need to key in Customer Number because it is an auto number:
Step 3:
Click the Save Button to save the new entries to the database file:
Step 4:
Click Refresh Button and click the Last Button. You will see your new record that you have just entered.
To work with the Close Button to close the program
Step 1:
To close the program during runtime, you can add a button to the form:
Step 2:
Set caption of the button properties:
Caption=Close
Step 3:
Double click on the button and write down the programming codes:
Private Sub Command9_Click()
Close
End Sub
By clicking on the 'Close' button, a user can close the program directly.
To work with the Refresh Button to refresh database
Step 1:
To refresh the database, you can add a button to the form:
Step 2:
Set the caption of the button properties:
Caption=Refresh
Step 3:
Double click on the button and write down the programming codes:
Private Sub Command8_Click()
Adodc1.Refresh
End Sub
After clicking on the 'Refresh' button, the data will be refreshed to reflect the most updated data from the database file.
