SETHA SITE INFORMATION

  • Increase font size
  • Default font size
  • Decrease font size
SETHA SITE INFORMATION

How to Create MDI Form and Menu Bar in Visual Basic 2008

E-mail Print PDF

This article shows you how to create MDI Form with Menu Bar in Microsoft Visual Basic 2008. From this article, you will know:

  • How to create MDI Form?
  • How to create Menu Bar?
  • How to click on each menu item to open child form in MDI form?

  1. Create MDI Form
    Create New Form (Project Menu -> Add New Item -> Windows Form)
    Change Properties of Form as below
    • WindowState: Maximized
    • isMdiContainer: True
  2. Create Menu Bar
    Drag MenuStrip Control to MDI Form
    Add Menu Item and Sub Menu Item (See in Video Below)
  3. Write Code
    Click on Menu Item to show Form in MDI Form (see example below)
            frmStudent.MdiParent = Me
            frmStudent.Show()
    

See video below

 

How to Insert, Delete, Update Data in MS-Access 2010 Using MS-Access Blank Form

E-mail Print PDF
Before reading this article you might need to read two prerequisites article as below:
  1. How to Create New Blank Database in Microsoft Access 2010
  2. How to Create Table in Microsoft Access 2010
This article shows you how to:
  • Create Form (Non-wizard Form) in Microsoft Access 2010
  • Design your own Form using TextBox, ComboBox, Command button and Subform control
  • Write VBA (Visual Basic for Application) Programming to Insert, Delete and Update data in MS-Access Table
  • Use SQL statements to Insert, Delete and Update Data in MS-Access Table

Download Sample Here
 
See video below
Part 1:

Part 2:
 

How to Create Table in Microsoft Access 2010

E-mail Print PDF

After you created new blank database you will see one table is created named Table1 which is not yet save. If you do not prefer to continue with that default table just click on the x button on the right hand side without saving.

Create New Table in Microsoft Access 2010
  • Click on Create Tab
  • Click on Table Design Button
  • You will see the table designation windows appear
  • Enter fields name and its data type as below:
  • Set field stdid to Primary Key (Not allow duplicate data for stdid) by Right Click on that field and choose Primary Key
  • Click <Ctrl-S> to Save the Table
 

How to Create New Blank Database in Microsoft Access 2010

E-mail Print PDF

This article shows you how to create new blank database in Microsoft Access 2010. This article is targeted to the beginner of Microsoft Access 2010.

  • Open Microsoft Access 2010 from Start Menu
  • Click on the Blank database (on the middle page of MS-Access start page)
  • Enter Database File Name (example: student.accdb) (on the right page of MS-Access start page)
  • Click button Create
  • One database is created
  • Continue to create table in Microsoft Access 2010
 

INSERT, DELETE, UPDATE AND SELECT Data in MS-Access with VB 2008

E-mail Print PDF

This article shows you how to write Visual Basic code using ADO.Net to manipulate data with Microsoft Access 2003 format. From this article you will know how to:

  • Use DataGridView control to get data from database
  • Use ADO.Net to Insert, Delete, Update, and Select data in MS-Access Database
  • Use SQL Statement for Inserting, Deleting, Modifying, and Selecting Data


Download Sample Code Here
  • Create Visual Basic 2008 Project: VB-Access
  • Assume that, we have a database file named data.mdb
  • Place the data.mdb file into ..\bin\Debug\ folder
    (Where the project executable file (.exe) is placed)
  • In data.mdb, there is a table named: student which consists of the following fields
    FieldData TypeDescription
    stdidNumberStudent's ID
    stdnameTextStudent's name
    genderTextGender
    phoneTextStudent's phone number
    addressTextStudent's address
  • Create New Form: frmStudent (as in image above)
  • Write code (Download Sample Code Here)

See video below
Part 1:

Part 2:
 


Page 11 of 19