Insert Null Value into Date/Time Field

Submitted by admin on
This simple project will simply insert a null value to a date/time field if the checkbox within DateTimePicker is False. In order to determine if the Checkbox is true/false you need to use the isNull function. Private Sub CmdInsert_Click() Dim cn As New Connection Dim strSQL As String cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Data.mdb;" strSQL = "INSERT INTO NOSOld

Load Data in Datagridview Obejct Oriented using Oledbconenction

Submitted by xiankaylle on
This is a Short and effective sample for you ,If you want to use Datagridview and Load data from database you might use this.This is an Object Oriented Program hope this will helps you guys enjoy! It also change the Row color. Sorry for late posting ^_^ "Very Busy in my Office works!" God Bless!Love your Work! "Human Kowledge belongs to the WORLD but WISDOM belongs to GOD!" NOTE:This Program was

ExamDiff – Free Visual Tools for Comparing Two Files

Submitted by admin on
In my previous blog I discuss the benefits of using TortoiseSVN - Source Control Software to backup your source code. If you are not using TortoiseSVN, I would like to recommend ExamDiff as an alternative in comparing two different version of your files or source code. Take note that this kind of tools is part of TortoiseSVN and you do not need to use ExamDiff for differentiating two files

Populating Elements

Submitted by kevern010101 on
  1. Option Explicit
  2.     Dim conn As ADODB.Connection
  3.     Dim rs As ADODB.Recordset
  4.    
  5.    
  6.    
  7.    
  8. ' pupulate element
  9. ' @author: Kevern
  10. ' @date: checkDate 07/28/2009
  11. Public Sub init()
  12.     Set conn = New ADODB.Connection
  13.     Set rs = New ADODB.Recordset
  14.         conn.connectionString = ConnectionStringModule.connectionString
  15.             With conn