<DIV>Just try..</DIV>
<DIV> </DIV>
<DIV>Format(DateAdd("m", 1, Date), "mmmm") without the Datepart.</DIV>
<DIV> </DIV>
<DIV><BR><BR><B><I>Don Elliker <delliker@hotmail.com></I></B> wrote:</DIV>
<DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">Oh and BTW How does dateadd work?<BR>Format(DatePart("m",DateAdd('m',1,Date())),"mmmm")<BR>this is returning January and I expect August<BR><BR><BR>"Things are only free to the extent that you don't pay for them".-Don <BR>Elliker<BR><BR><BR><BR><BR><BR>>From: "Don Elliker" <DELLIKER@HOTMAIL.COM><BR>>Reply-To: Access Developers discussion and problem <BR>>solving<ACCESSD@DATABASEADVISORS.COM><BR>>To: accessd@databaseadvisors.com<BR>>Subject: [AccessD] Tooo funny Help has a sense of the ironic<BR>>Date: Fri, 25 Jul 2003 15:47:54 -0400<BR>><BR>><BR>>I got really ticked at the stupid 'no help' in A2K and I asked my question <BR>>in a rather rude fashion (as in "How the F##K does dateadd work") because I <BR>>forget from time to time -anyway....one of the subjects that came back was <BR>>"How to speak to a computer"<BR>><BR>>Laughed out
loud<BR>>_d<BR>>"Things are only free to the extent that you don't pay for them".-Don <BR>>Elliker<BR>><BR>><BR>><BR>><BR>><BR>>>From: Jim Hewson <JHEWSON@KARTA.COM><BR>>>Reply-To: Access Developers discussion and problem <BR>>>solving<ACCESSD@DATABASEADVISORS.COM><BR>>>To: "'Access Developers discussion and problem solving'" <BR>>><ACCESSD@DATABASEADVISORS.COM><BR>>>Subject: RE: [AccessD] Requery Control and move to another - Solved<BR>>>Date: Fri, 25 Jul 2003 13:46:48 -0500<BR>>><BR>>>Required only three lines...<BR>>>Once the ComboBox (column 1 of the ListBox) is changed, I refreshed<BR>>>Subform1,<BR>>>requeried the ListBox, then set focus to destination field.<BR>>><BR>>>Me.Refresh 'the ComboBox is column(1) of the ListBox<BR>>>Forms("frmMain")("ListBox").Requery<BR>>>subform2.setfocus 'destination field is first field in
subform<BR>>><BR>>>Thanks,<BR>>>Jim<BR>>><BR>>>-----Original Message-----<BR>>>From: Mitsules, Mark [mailto:Mark.Mitsules@ngc.com]<BR>>>Sent: Friday, July 25, 2003 12:57 PM<BR>>>To: 'Access Developers discussion and problem solving'<BR>>>Subject: RE: [AccessD] Requery Control and move to another<BR>>><BR>>><BR>>>Jim,<BR>>><BR>>>I'm not sure I can help yet, but do I have this right?<BR>>><BR>>>MainForm<BR>>>|__TabCtl<BR>>>|____ListBox.............(2. Requery this.)<BR>>>|____SubForm1<BR>>>|______ComboBox.....(1. AfterUpdate of this.)<BR>>>|______SubForm2<BR>>>|________DestField....(3. Then SetFocus to this.)<BR>>><BR>>><BR>>><BR>>>Mark<BR>>><BR>>><BR>>> > -----Original Message-----<BR>>> > From: Jim Hewson [mailto:JHewson@karta.com<BR>>> > <mailto:JHewson@karta.com>]<BR>>> > Sent:
Friday, July 25, 2003 1:08 PM<BR>>> > To: 'AccessD'<BR>>> > Subject: [AccessD] Requery Control and move to another<BR>>> ><BR>>> > I'm having difficulty requerying a control.<BR>>> > Access 2000<BR>>> ><BR>>> > After updating a combo box, I want to refresh a list box, then go to<BR>>> > another field on a subfrorm.<BR>>> ><BR>>> > The combo box is on subform1, which is on a tab control. The list box <BR>>>is<BR>>> > on the same tab as subform1<BR>>> > After updating subform1, I want to go to a field on subform2, which is <BR>>>a<BR>>> > subform of subform1.<BR>>> ><BR>>> > Update combo box located in subform1 on tab control<BR>>> > refresh list box on tab control<BR>>> > Go to field on subform2<BR>>> ><BR>>> > How can I do this?<BR>>> ><BR>>> > Thanks in advance.<BR>>>
><BR>>> > Jim<BR>>> > << File: ATT846049.txt >><BR>>>_______________________________________________<BR>>>AccessD mailing list<BR>>>AccessD@databaseadvisors.com<BR>>>http://databaseadvisors.com/mailman/listinfo/accessd<BR>>>Website: http://www.databaseadvisors.com<BR>>>_______________________________________________<BR>>>AccessD mailing list<BR>>>AccessD@databaseadvisors.com<BR>>>http://databaseadvisors.com/mailman/listinfo/accessd<BR>>>Website: http://www.databaseadvisors.com<BR>><BR>>_________________________________________________________________<BR>>The new MSN 8: advanced junk mail protection and 2 months FREE* <BR>>http://join.msn.com/?page=features/junkmail<BR>><BR>>_______________________________________________<BR>>AccessD mailing list<BR>>AccessD@databaseadvisors.com<BR>>http://databaseadvisors.com/mailman/listinfo/accessd<BR>>Website:
http://www.databaseadvisors.com<BR><BR>_________________________________________________________________<BR>Protect your PC - get McAfee.com VirusScan Online <BR>http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963<BR><BR>_______________________________________________<BR>AccessD mailing list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website: http://www.databaseadvisors.com</BLOCKQUOTE></DIV></mailto:JHewson@karta.com><BR><BR><DIV>
<DIV>
<P align=center><STRONG>Lonnie Johnson<BR></STRONG><STRONG>ProDev</STRONG>, Professional Development of MS Access Databases<BR>Visit me at ==> <A href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR><A href="http://www.galaxymall.com/software/PRODEV"><BR></A><BR> </P></DIV></DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo! SiteBuilder</a> - Free, easy-to-use web site design software