how add time from 00:00:00 to 23:59:00 to a combo box as items

[seshu]

Hi everybody
This is seshu i have small doubt in adding times to a combobox
form 00:00:00 to 23:00:59 because there are two comboboxes in my table and i want to use them as from time to to time
please some one of help me out
regards
seshu

[Killer42]

Hi everybody
This is seshu i have small doubt in adding times to a combobox
form 00:00:00 to 23:00:59 because there are two comboboxes in my table and i want to use them as from time to to time
please some one of help me out

First, you might want to consider using a DateTimePicker control rather than a combobox. Doing it your way, each combobox will have 86,400 entries. Is that possible?

But if you're determined to load them up that way, it should be fairly simple. What about the following. (Sorry, I usually check code in VB as I go, but my PC is having problems and VB won't run so I'll just type it straight out here.)

Dim TheTime As Date,StartTime As Date
TheTime = TimeValue("00:00:00") ' (I think TimeValue is the right function)
StartTime=TheTime
Do
  ComboBox.Add Format(TheTime, "hh:nn:ss")
  TheTime = DateAdd("s", 1, TheTime
Loop Until Day(TheTime) <> Day(StartTime)
 

[seshu]

will this work for time i dont think so
if possible be some more clear
please sir

[seshu]

sorry sorry its working and iam also able to make chages to code

[Killer42]

sorry sorry its working and iam also able to make chages to code

Glad to hear it.

When we refer to a "date" value in VB (or VBA, or Access) it quite often contains both date and time information. Can be a bit confusing at times.