Results 1 to 3 of 3

Thread: date problem

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 2000
    Location
    calcutta,india
    Posts
    48
    i am wanted to put blank date into access
    database.How to update date field with an
    empty text box.Shuld i first covert text box text
    to date data type.I am using vb 6.0,ado.

  2. #2
    Guest
    Type within a text box =NOW()

    This shall display a static date - Do you want it to be constantly updated??

  3. #3
    Hyperactive Member Asaf_99's Avatar
    Join Date
    Jul 2000
    Location
    Israel
    Posts
    335
    Originally posted by rlculver
    This shall display a static date - Do you want it to be constantly updated?? [/B]
    If so then put a timer and a textbox:
    Code:
    Private Sub Form_Load()
    Timer1.Interval = 100
    End Sub
    
    Private Sub Timer1_Timer()
    Text1.Text = Now
    End Sub
    By the way there are some more time functions:
    Text1.Text = Time
    Text1.Text = Date
    Text1.Text = Now
    Text1.Text = Hour(Time)
    Text1.Text = Minute(Time)
    Text1.Text = Second(Time)
    Text1.Text = Day(Time)
    Text1.Text = Month(Date)
    Text1.Text = Tear(Date)
    Text1.Text = Weekday(Date)

    Hope I helped...
    ,Asaf Sagi
    Asaf Sagi

    ICQ: 61917199
    E-Mail: sagiasaf@netvision.net.il

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width