<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Month name in list box to number</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff
size=2>Chester,</FONT></SPAN></DIV>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff size=2>Two
choices that I see:</FONT></SPAN></DIV>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff size=2>or
</FONT></SPAN></DIV>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff size=2>2. Or
if your list box contains one column with month text, in
code:</FONT></SPAN></DIV>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff size=2>dim
sDummy as String</FONT></SPAN></DIV>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff
size=2> sDummy = lstMonth.Value & " 1, 20003"</FONT></SPAN></DIV>
<DIV><SPAN class=019022819-04062003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<P><FONT face=Arial><FONT size=2><SPAN
class=019022819-04062003>HTH</SPAN>,</FONT></FONT> </P>
<P><FONT face=Arial size=2>Jim DeMarco</FONT> <BR><FONT face=Arial
size=2>Director of Product Development</FONT> <BR><FONT face=Arial
size=2>HealthSource/Hudson Health Plan</FONT> </P>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Kaup, Chester A
[mailto:kaupca@chevrontexaco.com]<BR><B>Sent:</B> Wednesday, June 04, 2003
3:19 PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] Month name in list box to number<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>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</FONT></P>
<P><FONT face="Times New Roman" size=1>No trees were killed in the sending of
this message. However a large number of electrons were terribly
inconvenienced.</FONT><BR></P><BR></BLOCKQUOTE><CODE><FONT SIZE=3><BR>
<BR>
***********************************************************************************<BR>
"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".<BR>
***********************************************************************************<BR>
</FONT></CODE>
</BODY></HTML>