Hints and Recipes for VB6: Difference between revisions

From Free Knowledge Base- The DUCK Project
Jump to navigation Jump to search
New page: == Date and Time examples with formatting options == strTimeStamp = Date & " " & Format(Time, "HH:mm:ss") strMsg = strMsg & "date/time of request: " & Date & " " & Time & vbCrLf str...
 
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 14: Line 14:
   End With
   End With
   cboDelimiter = "TAB"
   cboDelimiter = "TAB"
== Write/Create a new file using FileSystemObject ==
*must add 'reference' to "Microsoft Scripting Runtime"
  Dim fso As New FileSystemObject, fsoStream As TextStream
  Dim rec1, strLine, strFileSpec
  Dim cnt0 As Integer, tag1 As Integer
  strFileSpec = Environ("HOMEPATH") & "\My Documents\kaching.log"
  strLine = "kaching incident " & Date & " " & Format(time, "HH:mm:ss") & vbCrLf
  Set fsoStream = fso.CreateTextFile(strFileSpec, True)
  fsoStream.Write strLine
  fsoStream.Close
  Set fsoStream = Nothing: Set fso = Nothing
== Write if exists, create if doesn't exist using FileSystemObject ==
  If fso.FileExists(strFileSpec) Then
    Set fsoStream = fso.OpenTextFile(strFileSpec, 2)
  Else
    Set fsoStream = fso.CreateTextFile(strFileSpec, True)
  End If
 
  fsoStream.Write strLine
  fsoStream.Close
  Set fsoStream = Nothing: Set fso = Nothing
  ' strFileSpec, 1 : ForReading 2 : ForWriting  8 : ForAppending 
== Write to control on another form and display ==
  Dim lblCaught As Label
  Set lblCaught = frmKaching.lblCaught
  frmKaching.WindowState = vbNormal
  lblCaught = "You've Been Naughty!"
  frmKaching.Show


== Delay without using a Timer control ==
== Delay without using a Timer control ==
Line 61: Line 25:
   End Sub
   End Sub


== Quickly determine which option button is selected ==
Often OptionButton controls are arranged in control arrays. To quickly find the index of the only selected OptionButton control apply this little math trick.  The following example assumes there are 3 option buttons in a control array.
intSelected = Option(0).Value * 0 - Option(1).Value * 1 - Option(2).Value * 2


 
Note that the first operand is always zero, and you can simplify the above expression as follows:
 
intSelected = -Option(1).Value - Option(2).Value * 2
 
Credit to [http://msdnx.com/visual-basic-archive/23/43-36-236214.shtm Ed Lampman for this VB trick].


== Command Line Parameter ==


This example was taking from the Sales Logix Assistant Program:
Private Function CheckLauncherParamter()
' blnDebug
  If InStr(LCase(Command), "/verified") > 0 Then
    CheckLauncherParamter = True
    blnDebug = False
    mnuFileExit.Enabled = False
  ElseIf InStr(LCase(Command), "/debug") > 0 Then
    CheckLauncherParamter = True
    blnDebug = True
    mnuFileExit.Enabled = True
  Else
    CheckLauncherParamter = False
  End If
End Function




 


[[Category:Computer Technology]]
[[Category:Computer Technology]]
[[Category:Programming]]
[[Category:Programming]]
[[Category:VB6]]
[[Category:VB6]]

Latest revision as of 13:24, 12 February 2008

Date and Time examples with formatting options

 strTimeStamp = Date & " " & Format(Time, "HH:mm:ss")
 strMsg = strMsg & "date/time of request: " & Date & " " & Time & vbCrLf
 strSQLdate = Format(Date, "M/d/yyyy")

Combobox

 With cboDelimiter
   .AddItem "TAB"
   .AddItem "PIPE"
   .AddItem "SPACE"
   .AddItem "fancy!"
 End With
 cboDelimiter = "TAB"

Delay without using a Timer control

 Public Sub LongDelay(intSeconds As Long)
   Dim cnt As Double
   cnt = Timer + intSeconds
   Do While Timer < cnt
     DoEvents
   Loop
 End Sub

Quickly determine which option button is selected

Often OptionButton controls are arranged in control arrays. To quickly find the index of the only selected OptionButton control apply this little math trick. The following example assumes there are 3 option buttons in a control array. 

intSelected = Option(0).Value * 0 - Option(1).Value * 1 - Option(2).Value * 2

Note that the first operand is always zero, and you can simplify the above expression as follows: 

intSelected = -Option(1).Value - Option(2).Value * 2

Credit to Ed Lampman for this VB trick.

Command Line Parameter

This example was taking from the Sales Logix Assistant Program: 

Private Function CheckLauncherParamter()
' blnDebug
  If InStr(LCase(Command), "/verified") > 0 Then
    CheckLauncherParamter = True
    blnDebug = False
    mnuFileExit.Enabled = False
  ElseIf InStr(LCase(Command), "/debug") > 0 Then
    CheckLauncherParamter = True
    blnDebug = True
    mnuFileExit.Enabled = True
  Else
    CheckLauncherParamter = False
  End If
End Function


 

Retrieved from "http://wiki.robotz.com/index.php?title=Hints_and_Recipes_for_VB6&oldid=2166"