<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=992033520-04062003><FONT face=Arial color=#0000ff size=2>Worked
great and by making first column width to 0 I only see the month name and not
the number. Thanks</FONT></SPAN></DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Jim DeMarco
[mailto:Jdemarco@hshhp.org] <BR><B>Sent:</B> Wednesday, June 04, 2003 2:32
PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD]
Month name in list box to number<BR><BR></FONT></DIV>
<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>