Visual Basic :: Time And Date Drop Down List

ActiveX Combo Box - Date/time List
Hi,
I'm trying to use an activeX combo box to select a date/time from a list and expect the selected date to display in the linked cell.
The list is fine but when I select an entry the combo box entry changes to excel's number representation of date/time not the dd/mm/yy hh:mm
that the selection list provides.

Can the system be made to show date/time - I already have the spreadsheet working using bog standard excel Combo boxes but ActiveX is giving me a headache
I'm using WIN/OFFICE 2K if that makes a difference.

Any pointers would be appreciated, Thanks!

Retrieve A List Of Files Changed Since A Certain Date/time
I am trying to find out an efficient way of retrieving a list of files that have been changed since a certain date/time. Ofcourse it is possible to get the full list of files in a directory and one by one check for the date and time it has been changed but I am wondering if there is a quicker way of building up such a list. The standard filelistbox only has a pattern method of decreasing a list of files for all I know. Maybe there is a way using API functions?

Any suggestions are welcome...

I want to use this to collect files from some servers on a frequent basis but I do not want to copy all of them again and again.

Retrieving Dir List From Server And File Date/time
Is there some simple code to use a WinSock control to get a complete file list from an HTTP location and the files date and time?

Thanks in advance.

REQ Help: Calculating Elapsed Time From Date/time Began From Date/time Ended
I have four controls, two are Date-Time Pickers set for Date and the last two are text boxes set for Time with the "...If Not IsTime()..." validation.

It is the standard Date and Time problem began, Date and Time problem ended.

I am trying to calculate the elapsed time between these in "" DAYS "" HOURS ""MINUTES.

I coded this in Lotus Notes yet exporting my knowledge to VB is problematic.

Has anyone a code snippet of how to do this in VB - yes, I know about the DateDiff.

Many, MANY thanks!

How To Check If The Current Date/time Is >15 Mins More Than Another Date/time?
Say you have the date/time stored in a string like so:
"2008-06-05 01:58:30"

How can you check if the current date/time is > the date/time stored in the string + 15 minutes?

How To Drag Drop From List Box To Either Text Box Or List Box
hello everyone i need to know how to drag drop text from a listbox to another listbox.....

i was able to set it up for a list box to a text box but when i would add another name to it it would erase the previous one...

and really i need it to be a list box so that the user cant type in it...

at the same time i need to know if while you are dragging and droping the file is it possible to grey out the text in the box you are dragging it From.....thanks

Same List Box Drag & Drop And Re-order List
List Box Control Question (Not Listview control)

Can someone show me how to drag and drop a list item
from one position to another in the same list box and have the item list automatically reorder itself?

Thanx!

JC
nnpc@att.net

Server Date/time Instead Of Windows Date/time
Dear VB Experts,

We are developing a Client/Server application whereby the VB executables will reside at the PC.

Server run on HP-UX 10.20. Database is Informix-Online.

One of our task is to utilise the server date and time for timestamp instead of using the Windows date and time.

How do we do that ?

Thanks in advance.

RWS

Drag N' Drop From List Box To List Box
I have an application that has eight list boxes that pointing to specific directories on eight different machines. The list boxes display the files that are currently on these eight directories and sometimes they need to be moved manually from one machine to another. Currently I have to use network neighborhood to drag n' drop, but I would like to implement this feature into my application so that my users can drag and drop from within the application.

I still consider myself a newbie with programming so detailed information would be appreciated.

Thank you in advance everyone.

-Nielubie (a.k.a. Pete)

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Conquering a difficult goal is a lot more rewarding then a simple goal.
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

Edited by - Nielubie on 10/31/2004 2:56:44 PM

Drop Down A Drop Down List?
Is it possible to hit a command button and have a drop down list drop down so the user can see all the choices without clicking on it first?

Thanks,

Dan

Grouping By Date Where Date Field Is Date/time
I have an SQL7 database storing datetime data, and totaliser reading, new records are added every 5 minutes.

I have written the following sql to give me the the min and max totaliser reading for each day - which works fine - except that the resultant Date field is a text field not a date field so the order statement generates an incorrect listing if the data selected sarts in one month and ends in the next, eg.

select left(Date, 12) as Date, Min(Reading) as Day_Start, Max(Reading) as Day_End from Steam where tag_no = 2 and (Date <= '24-November-2005 00:00:00' and Date >= '22-October-2005 00:00:00') Group By left(Date, 12) order by Date asc

Is there another function I can use to extract just the date from the date/time field as a date data type?

I cannot alter the database as its structure is predetermined by the remote field device supplying the data.

Setting Long - Short Date Format In Date Time Settings
How can i set the Date Time Setting Format in Control Panel

i m usiing window Xp

also i want the date format in dd/MM/yyyy

Drop Down List
I'm trying to walk a user through a form. I would like to make them pick from a drop-down list. How do I get the Macro to go the the cell that contains the drop-down list, pause until the user picks the entry from the list and then continue to the next field with another drop-down list. Please help.

Thanks.

Drop Down List
I am trying to create a drop down list of hyperlinks in word or excel. I have no idea of how to accomplish this. Any help provided will be appreciated.

Drop Down List?
Hey, im trying to make a drop down for a web browser such as File, Edit, Help, etc. How would you do this?

Drop Down List Box
I'm working on an ASP.NET web application with a drop down list box (in a web user control), in which at runtime, a number is added (x+1), etc. for each element in an xml data list. Is there a way to then have a select case function for each item added to the drop down box?

thanks,
Eric

Drop Down List
How can the printer collection be displayed in a Drop Down List? Also, when a printer is selected how can it be set as the default printer in that program only without changing the default for all programs.

Drop Down List
hii.. hw can i build a form with two drop down lists( combo boxes type 0), one for students and the other for their study center code. when this form is loaded fill the lists from the arrays. if the user pulls down one of the list and clicks on a student the corresponding study center code is displayed in the text box of the other list?
thnx for rplyin..

Drop Down List Box
i would like a drop down list box or just a list box on my program that lists all the topics available to read about. What i want is once the user highlights a topic then hits a button it will load up a certain form. Is this possible??

Drop Down List
hello guys

i've create a drop down list with some items in it.I want to click on one of them and open a toolbox that has some buttons,icons,e.t.c. clicking on another item of that drop doun list i want to open diferrent toolboxes and so on.

Greetings from far far far away

Drop Down List
How do I create a Drop Down List? Not to be confused with ListBox or ComboBox....

I want the drop down list to contain four choices Site1, Site2, Site3 and Site4

is there a control ordo I have to write some code??

any ideas???

VBA - Drop Down List
hi to all
I am trying in VBA. I am very poor to use VBA.

How do i get Dropdown List Box value when i click the Button.

i tried like
sheet1.shapes("combo1").name
But no use..

Please help me

Cheers

Drop Down List
How do I make a drop down select list?

Drop Down List
I want to create my front screen just as Windows Explorer. Address bar is to be placed. From my point of view it is an Image combo but after writing something on the bar drop down list appears. If any body has tried it please give me your inputs as it is very important in my project.

Drop Down List
Is it possible to have a drop down list with pictures next to the text (like the colours menu attached).
It would be even better if there was just a plain list box with pictures next to text.
and is there also a way to get the picture blocks bigger?

Thanx in advance
-THe_SHadoW

IIS App And Drop Down List...Please Help...
I only have one problem... I want to have a page with 1 drop down list and a submit button... I am writing an IIS app and need to know how to tell which selection the user has selected. Any examples would be helpfull. Like, a drop down list with 2 entries and the code that captures the selection posting a simple message stating which was selected.

Thanks to all for any help. Do I need to use javascript or can I do it within the VB IIS app?

AmigaZoid

Drop-down List In RTB
Using a RichTextBox component in a Form, I want to create a drop-down list to modify the letter's size. How can I do it?

Drop Down List
Hello everyone,

I have an easy one for you here. I am trying to make a drop down list with Sir Names in them, i.e, "Mr.", "Dr.", etc. I think that I need to use a drop down list box for this right? Because in a combo box the user can type in a new field and I would not want that. So my question is can I make a list box a drop down and how.

Thank you,
Chris

Drop Down List Box
I have a drop down list box connected to a access data base.
My question:
What is the code to let the user start to type something at the top of the list and will as they type search the list finding the nearest match with in the list. Any help is greatly appreciated.

How To Add To A Drop Down List
How Do I add another item(function) to a drop down menu list.

I have a Menu drop down called Reports

I want to add another item. I am very new to VB

thanks in advance.

Date Time Picker >> Fuction To Calculate A Specific Date
I have two Date Time Picker controls.

What needs to happen is when user selects a date in DTPicker1 then a date 7 months later, on the following tuesday is displayed in DTPicker2.

Any help with this would be great.

Date Time Picker Control: How Do Set The Displayed Date To Null?
I have a front end database form with date fields using the MS dtp control. The fields are unbound, but populated using a data class. The problem is that on many occasions the date field is Null, ie no data available. On display the dtp control always defaults to a set date, usually today (this is a property function of the control). What I can't seem to do is to display no date, or to delete the date displayed. Any thoughts would be very gratefully recieved. API perhaps?

I'm trying very hard not to have to write an Active-X control based on the dtp (mainly because of multilingual support and different localisation issues regarding dd/mm/yyyy (used by 90% of the world's population, and mm/dd/yyy - used by the remaining 10% in the US - sorry just had to get that jibe in for those of us who despair at having to go in to custom formatting in Excel simply to get dd/mm/yy )

Many thanks

Date & Time Values In Date And String Format Differ
The program (debug) output below lists the last modification time of two files. File 1 is stored on a NTFS medium, file 2 sits on a FAT medium.

In order to be able to compare these dates, I need to round the odd seconds of the NTFS file up (FAT files have only even second values).

The lines after the file headers show the date & time value before and after the rounding, in date, double precision and string format.

file 1 (NTFS)
= 2005-07-12 08:57:09 = 38545,3730208333 = 2005-07-12 08:57:09
after rounding up
= 2005-07-12 08:57:10 = 38545,3730324074 = 2005-07-12 08:57:10

file 2 (FAT)
= 2005-07-12 08:57:10 = 38545,3730324074 = 2005-07-12 08:57:10

The strange thing is that when comparing these values, they appear to be different (!) both in date and double data format, not in string format.

2005-07-12 08:57:10 > 2005-07-12 08:57:10 (date format)
38545,3730324074 > 38545,3730324074 (double precision format)
2005-07-12 08:57:10 = 2005-07-12 08:57:10 (string format)

Any idea where this difference comes from?

Rounding up was done with DateAdd.

VB version 6, on XP.
Boiled down code has been attached.

How To Get List Of Files In File List Box Depending On Date
Hey,

I want to know how to get list of files in File List Box depending on particular date.

Please tell me how to do it.

With regards,

Praveena.

How Can I Get A Drop Down Date Picker Like The Attached?
Does anyone know how its done?

Please view the attached jpg file, thank you

Drop Down List Combo Box
I want the user to select one of many options. So first I used I drop down combo box. I didn't like it because the user could enter something. So I changed it to a drop down list combo box. The user can't add anyhting now. My question is how do I reset the textbox? When I start the program the box is blank but once the user selects something is there any way to reset it? I can't make it equal to "".
Any ideas?
Thanks, AL

Picking A From A Drop List
How can I have a Macro prompt the user for a value that is part of a dropdown list and make the macro pause at that cell until selection is made. I'm trying to "Step" the user through a form.

Thanks

Mike

Drop Down List In A Cell
I am trying to accomplish the following:
Excel Workbook has two sheets. The second sheet has accounts and account numbers in Columns A and B.
I would like to have these account numbers included in a drop down menu in cell B5 on the first sheet. I have not been able to accomplish this. I have been able to make this work when everything is on one sheet using the following code:

Dim tmpForm As String

Public Sub Add_Menu()

tmpForm = "=A35:$A48"

Range("B5").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:=tmpForm
.InCellDropdown = True
.ShowInput = True
.ShowError = True
End With
End Sub

Any suggestions would be greatly appreciated.

Drop Down List And Worksheet_change Bug?
Hi,
I'm having a problem and it's to do with worksheets_change and data validation. I know there was a bug in older versions of xl but I'm using 2003 and the problem there (from my reading) was that it wasn't recognising changes to lists as changes to the worksheet.
Anyway the problem is that I want to show and hide rows in a sheet depending on the value selected from a dropdown box. What I've done is as follows:

Private Sub Worksheet_Change(ByVal Target As Range)
'Make sure the right things are displayed
Select Case Range("list").Value
Case "first one"
Rows(8).Hidden = False
Rows(9).Hidden = True
Case "second one"
Rows(8).Hidden = True
Rows(9).Hidden = False
End Select
End Sub

Where list is a cell with data validation set to list.

It recognises (when the list is changed) that there has been a change in the worksheet, kicking off the sub, but it doesn't actually do the hide/unhide.

Anyone got any ideas?

Thanks
Si

Drop Down List Trouble!
Hi, heres my scenario

In MS EXCEL I have a sheet called "TeamDetails" which contains 4 cells which contain the name of 4 snooker teams. They are not located adjacent to each other however. n e ways i have another sheet called "MatchSchedule". Here using one cell i wish to right click the cell and from the menu create a drop down list.

Now the problem is how do i select the name of the teams from the other sheet to appear inside the drop down list????

Drop Down List Combo
hi, i think i shoud use a dropdown list combo since the user cannot then enter any values outside the range, so less errors!
but how do i enter a value in the text field? since it is not possible to add text into this kind of combo? i mean for instance a combo with values 1 tp 5 but with 3 preselected, so that the combo is not empty?

Ultragrid Drop Down List
Hello All,

I was trying to figure how to create a drop down list for a grid I have created. The drop down list will only be used for one column on this grid, but each cell in this column will used this same list to select options from. The options of this drop down list will contain a recordset I am passing into to it. Does anyone have any suggestions on how I can code this, because I am having alot of difficulty with it at the moment. Thanks for any help you can give.

Autocompleting A Drop Down List
I have a cell linked to a range so that when you click on the cell you have to pick one of the options from the drop-down list (the drop-down list contains the items in the range).

Is it possible to set up Excel so that if a user begins to type in the cell it will autocomplete to one of the items in the range.

For example, let's say the items in the range were "orange" and "apple". Right now the user has to either type one of these items as exactly as it is entered or select the item from the drop down list. Is it possible to set up the cell so that the user can start typing "or" and excel goes ahead and completes it with "orange"? Kind of like when you are typing a web address in Internet Explorer.

A Drop-down List In MSflexgrid
I want to use a drop-down list in one of the cells of each row of the MSflexgrid. How should I go about it??

Drop Down List/combo
this is what i want to do
i dunno how to make it ezr but i am planning to use 1 dropdown list to store a name and once you select that name it will display the address and postal code in other field

EG:

JOHN MURPHY (selected)

(display)
9847 nowhere rd (different dropdownl list/textbox)
new york, new york (different dropdownl list/textbox)
12345 (different dropdownl list/textbox)

if i want to do this i need to store the data into a file...how would I be able to do this?
anyone able to help?
icq 1397831 asap!!!
thank you in advanced

Drop Down List Question
I have a dropdownlist databinded and it has many values "Please select..." , "Milwaukee", "Chicago".... and many other citys.

So how do I show an error if they click the submit button without changing it from "Please select..."?

Thanks and if you need any other info please let me know,
Schmidty

I am using .Net 2003

The Most Effective Way To List In A Drop-down Box?
What is the most efficient way to list items in a drop-down box? Is it through a textfile/ access file/ or putting it in the program? I've got a 26 name list that may vary in the future. I'm thinking of putting a drop-down box on my form and the data pulling from a text file.

If that is the most efficient - What would be some of the code to do that and MORE IMPORTANTLY- when and where should I put it?

I would think pull it up (OPEN "textfile) in Form_Load and use array variables to represent the data. let's say Dim A(26) as String: For I = 1 to 26: INPUT#1, A(I):NEXT I. Now how to list those variables in the Drop-down box? And where - Private Sub List_Box()?????????

Thanks for any info.

Stephen

Time And Date Drop Down List

How do I add the drop down list for user to choose the time (such as in the MS Outlook calender, when we try to make the schedule recurrance).