<!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=750013819-04062003><FONT face=Arial color=#0000ff
size=2>>></FONT><SPAN class=019022819-04062003><FONT face=Arial><FONT
color=#0000ff><FONT size=2> sDummy = lstMonth.Value & " 1, 20003"<SPAN
class=750013819-04062003><<</SPAN></FONT></FONT></FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=750013819-04062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750013819-04062003><FONT face=Arial color=#0000ff
size=2>Whoa, I went way into the future here. Sorry meant 2003 for
the year!</FONT></SPAN></DIV>
<P><FONT face=Arial size=2>Jim DeMarco</FONT> </P>
<P><BR><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Jim
DeMarco <BR><B>Sent:</B> Wednesday, June 04, 2003 3:32 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Month name in list
box to number<BR><BR></P></FONT>
<BLOCKQUOTE>
<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></BLOCKQUOTE></FONT></CODE><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>