User Profile

jimmylee · Feb 21 '08, 06:41 AM

Code:

dim intDateDiff as integer

           intDateDiff = datediff(format(dtpPicker1.value,"mm/dd/yyyy"),format(Now,"mm/dd/yyyy")

jimmylee · Feb 18 '08, 09:22 AM

Code:

vb
Date = Date + 1
Text1.Text = WeekdayName(Weekday(Date))

jimmylee · Feb 11 '08, 09:43 AM

[code=vb]
Private Sub Command1_Click( )
Dim email
Set email = CreateObject("c do.message")

With email
.to = "someone@domain .com"
.cc = "someone@domain .com"
.subject = "something"
.From = "someone@domain .com"
.textbody = "Some thing"
.AddAttachment ("C:\aspsmartup load.dll")
.send
End With...

jimmylee · Feb 11 '08, 08:26 AM

1.query statement
select * from table1 between startdate = 'dtppicket1.val ue' and enddate ='dtppicket2.va lue'

connect recordset to your datagrid
and then refresh....

jimmylee · Feb 11 '08, 08:15 AM

Here

Dim oFSO As FileSystemObjec t
Dim sPath As String
Private Sub Command1_Click( )
Set oFSO = New FileSystemObjec t

sPath = InputBox("Provi de starting folder path")
Set oFolder = oFSO.GetFolder( sPath)

If oFSO.FolderExis ts(sPath) Then

For Each oFile In oFolder.Files
MsgBox "File " & oFile.Name & " last changed...

jimmylee · Feb 11 '08, 07:49 AM

Dim objFSO As FileSystemObjec t
Private Sub Command1_Click( )
Set objFSO = New FileSystemObjec t
objFSO.CreateTe xtFile "C:\testaa. txt"
End Sub...

jimmylee · Feb 11 '08, 07:34 AM

install the crystral report cd.
read and study examples of crystral report project...

jimmylee · Feb 5 '08, 07:44 AM

hey friend,

pls use varchar datatype.

jimmylee · Feb 5 '08, 07:17 AM

don't use combo box.
because date time is not infinity. so. I worry you are so tired.
pls use datetimepicker control.
it is so easy to use and more effective.

jimmylee · Feb 5 '08, 07:13 AM

Private Sub Command1_Click( )
Dim email
Set email = CreateObject("c do.message")

With email
.to = "someone@domain .com"
.cc = "someone@domain .com"
.subject = "something"
.From = "someone@domain .com"
.textbody = "Some thing"
.AddAttachment ("C:\aspsmartup load.dll")
.send
End With

...

jimmylee · Feb 4 '08, 09:12 AM

I mean not sql statment.

how many tables in sql datase. how to code in visual basic.

jimmylee · Feb 4 '08, 07:43 AM

you have to change
rs.Open "select * from tbl", cn, adOpenDynamic, adLockOptimisti c...

User Profile

Profile Sidebar

I have got error Microsoft VBScript runtime (0x800A01FB)

Leave a comment:

backup SQL database at runtime

Getting this error while uploading file...

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

how to count how many table in database at runtime in visual basic 6.0

back up sql database at runtime.