[AccessD] Month name in list box to number

Jim DeMarco Jdemarco at hshhp.org
Wed Jun 4 14:38:45 CDT 2003


>> sDummy = lstMonth.Value & " 1, 20003"<<
 
Whoa,  I went way into the future here.  Sorry meant 2003 for the year!

Jim DeMarco 


-----Original Message-----
From: Jim DeMarco 
Sent: Wednesday, June 04, 2003 3:32 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Month name in list box to number



Chester,
 
Two choices that I see:
 
1. Use "1;January;2;February"... as your list boxes row source and binding to the first column.  Then just refer to lstMonth.value to get the month number.
 
or 
 
2. Or if your list box contains one column with month text, in code:
dim sDummy as String
     sDummy = lstMonth.Value & " 1, 20003"
and call Month(sDummy) to get the month number.  The day and year values passed in via the string do not have to change ever since you're only interested in the month value.

HTH, 

Jim DeMarco 
Director of Product Development 
HealthSource/Hudson Health Plan 

-----Original Message-----
From: Kaup, Chester A [mailto:kaupca at chevrontexaco.com]
Sent: Wednesday, June 04, 2003 3:19 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Month name in list box to number



I have a form with a list box filled with month names. Ex January. I have a table that has data stored by month number. How can a convert the month name to a number to find the appropriate record in the table. I can do it with a select in code but thought there might be an easier way to query the table based on the selection from the form. Thanks

No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.





***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You".
***********************************************************************************




***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030604/2f6a62e7/attachment-0001.html>


More information about the AccessD mailing list