Click here to Skip to main content
15,923,689 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionForm Loading.. Pin
icowa14-Sep-05 21:15
icowa14-Sep-05 21:15 
AnswerRe: Form Loading.. Pin
enjoycrack15-Sep-05 0:38
enjoycrack15-Sep-05 0:38 
AnswerRe: Form Loading.. Pin
Briga15-Sep-05 23:02
Briga15-Sep-05 23:02 
GeneralRe: Form Loading.. Pin
icowa17-Sep-05 2:18
icowa17-Sep-05 2:18 
GeneralRe: Form Loading.. Pin
Briga18-Sep-05 21:57
Briga18-Sep-05 21:57 
GeneralRe: Form Loading.. Pin
icowa19-Sep-05 16:26
icowa19-Sep-05 16:26 
GeneralRe: Form Loading.. Pin
Briga19-Sep-05 21:53
Briga19-Sep-05 21:53 
QuestionSimple Problem Pin
tatchung14-Sep-05 20:59
tatchung14-Sep-05 20:59 
Hello again friends!!

I've a fairly simple problem w/c im unfortunately stuck at. Well, i'v 2 forms. form1 is the main page which shows some companies' names as a link. form2 is the page which allows you to edit, update and/or delete the given company. now here's my problem...everything works fine except for my date picker. Upon clicking my "setdate" button it shows the calendar and actualy sets the coresponding text box with the date you pick but when i try to save the form the date doesn't save at all. everything else including the company name, adress, tel number, etc is saved accordingly only the textbox with the date picked is not. Any ideas why not? here's my query on insert:

Public Function fInsert(ByVal strName As String, ByVal strID As Integer, ByVal strInbound As Integer, ByVal strOutbound As Integer, ByVal strDstart As String, ByVal strDend As String, ByVal strRemarks As String)
        Try
            strSQL = "Insert into Splits"
            strSQL += " (SplitID, SplitName, Inbound,"
            strSQL += " Outbound, DateStarted, DateEnded, Remarks)"
            strSQL += " Values ('" & strID & "',"
            strSQL += " '" & strName & "',"
            strSQL += " '" & strInbound & "',"
            strSQL += " '" & strOutbound & "',"
            strSQL += " '" & strDstart & "',"
            strSQL += " '" & strDend & "',"
            strSQL += " '" & strRemarks & "')"

            Dim cmdInsert As New OdbcCommand()

            cmdInsert.CommandText = strSQL
            cmdInsert.Connection = cnn
            cmdInsert.ExecuteNonQuery()
        Catch e As OdbcException
            Throw e
        End Try
        Return True
    End Function



Tanx so much!

Kampai!!!

-- modified at 3:03 Thursday 15th September, 2005
AnswerRe: Simple Problem Pin
ciacia14-Sep-05 21:42
ciacia14-Sep-05 21:42 
GeneralRe: Simple Problem Pin
tatchung14-Sep-05 22:10
tatchung14-Sep-05 22:10 
QuestionUsing NetSessionDel in VB.Net Pin
Paul_Taylor14-Sep-05 20:59
Paul_Taylor14-Sep-05 20:59 
QuestionPassing ADODB.Connection Object to Function Pin
shoaibnawaz14-Sep-05 20:40
shoaibnawaz14-Sep-05 20:40 
AnswerRe: Passing ADODB.Connection Object to Function Pin
ciacia15-Sep-05 0:00
ciacia15-Sep-05 0:00 
Questionftp problem from dotnet? Pin
Tridip Bhattacharjee14-Sep-05 19:57
professionalTridip Bhattacharjee14-Sep-05 19:57 
AnswerRe: ftp problem from dotnet? Pin
Vasudevan Deepak Kumar14-Sep-05 22:24
Vasudevan Deepak Kumar14-Sep-05 22:24 
GeneralRe: ftp problem from dotnet? Pin
Tridip Bhattacharjee21-Sep-05 3:02
professionalTridip Bhattacharjee21-Sep-05 3:02 
Questionhow to do scheduling writing code? Pin
Tridip Bhattacharjee14-Sep-05 19:56
professionalTridip Bhattacharjee14-Sep-05 19:56 
AnswerRe: how to do scheduling writing code? Pin
LeenaSo14-Sep-05 20:14
LeenaSo14-Sep-05 20:14 
QuestionSendKeys and Internet Explorer Please Help Pin
Daniel Lopez14-Sep-05 18:27
Daniel Lopez14-Sep-05 18:27 
AnswerRe: SendKeys and Internet Explorer Please Help Pin
rwestgraham15-Sep-05 9:55
rwestgraham15-Sep-05 9:55 
Questionsubtracting decimal values in textboxes Pin
BORN...again!14-Sep-05 15:49
BORN...again!14-Sep-05 15:49 
AnswerRe: subtracting decimal values in textboxes Pin
Steve Pullan14-Sep-05 16:11
Steve Pullan14-Sep-05 16:11 
GeneralRe: subtracting decimal values in textboxes Pin
BORN...again!14-Sep-05 16:21
BORN...again!14-Sep-05 16:21 
GeneralRe: subtracting decimal values in textboxes Pin
Dave Kreskowiak14-Sep-05 16:30
mveDave Kreskowiak14-Sep-05 16:30 
GeneralRe: subtracting decimal values in textboxes Pin
Steve Pullan14-Sep-05 16:57
Steve Pullan14-Sep-05 16:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.