Cara Membuat Program Akuntansi Dengan Visual Basic

Menampilkan dan menbaca file database excel kedalam form visual basic 6.0 dengan listviewTip dan Trick Visual Basic. Cara Membuat Aplikasi Kasir Menggunakan Vba Di Microsoft Excel Lengkap Youtube. Program aplikasi Kasir V11 ini merupakan program aplikasi kasir yang update dari posting excel pada blog ilmu excel yang telah di hapus dan saya posting di blog jago office ini. Cara membuat program kasir dengan visual basic 2008.

• View
  213

• Download
  0

Embed Size (px)

DESCRIPTION

membuat warna

Text of Membuat Warna Visual Basic

Example 18

Example 18.1

The Code:Dim strColor As String

Private Sub RadioButton8_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton8.CheckedChangedstrColor = 'Red'End Sub

Private Sub RadioButton7_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton7.CheckedChangedstrColor = 'Green'End Sub

Private Sub RadioYellow_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioYellow.CheckedChangedstrColor = 'Yellow'End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.ClickLabel2.Text = strColorEnd SubAlthough the user may only select one item at a time, he may make more than one selection if those items belong to different categories. For example, the user wish to choose T-shirt size and color, he needs to select one color and one size, which means one selection in each category. This is easily achieved in VB2008 by using the Groupbox control under the containers categories. After inserting the Groupbox into the form, you can proceed to insert the radio buttons into the Groupbox. Only the radio buttons inside the Groupbox are mutually exclusive, they are not mutually exclusive with the radio buttons outside the Groupbox. In Example 18.2, the users can select one color and one size of the T-shirt.Example 18.2

Dim strColor As StringDim strSize As String

Private Sub RadioButton8_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton8.CheckedChangedstrColor = 'Red'End Sub

Private Sub RadioButton7_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton7.CheckedChangedstrColor = 'Green'End Sub

Private Sub RadioYellow_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioYellow.CheckedChangedstrColor = 'Yellow'End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.ClickLabel2.Text = strColorLabel4.Text = strSizeEnd Sub

Private Sub RadioXL_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioXL.CheckedChangedstrSize = 'XL'End Sub

Private Sub RadioL_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioL.CheckedChangedstrSize = 'L'End Sub

Private Sub RadioM_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioM.CheckedChangedstrSize = 'M'End Sub

Private Sub RadioS_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioS.CheckedChangedstrSize = 'S'End Sub

jadi coding ini buat nampilin nomor otomatis dengan format tanggal/bulan/tahunn+nomor urut..

gimana codingnya di vb.net ??

neh..

——————————————————————
Shared Function NomorBaru() As String
Dim intValue As Integer = 1
Dim Nota As String = Date.Now.ToString(“ddMMyy”)
Dim rValue As String
Using objConnection As New OleDb.OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0;” & “Data Source=” & Application.StartupPath + “Master.mdb ; ” & “User Id=admin;”)
objConnection.Open()
Dim objCommand As OleDb.OleDbCommand = objConnection.CreateCommand()
objCommand.CommandText = String.Format(“SELECT NoService FROM [SO] WHERE NoService LIKE'{0}###’ ORDER BY NoService DESC”, Nota)
Dim objValue As Object = objCommand.ExecuteScalar()
If objValue IsNot Nothing Then
If objValue IsNot DBNull.Value Then
Dim strvalue As String = objValue.ToString().Remove(0, 6)
Integer.TryParse(strvalue, intValue)
intValue += 1
End If
End If
objCommand.Dispose()
End Using
rValue = Nota & intValue.ToString(“00#”)
Return rValue
End Function
—————————————————————————

ket :

warna Merah : untuk Database Yg Digunakan
warna Hijau : untuk nama Field yg digunakan
warna kuning : untuk Nama tabel yg digunakan

Terima kasih..

Cara Membuat Software Akuntansi Dengan Visual Basic

mudah2an berguna dah..