[AccessD] Tooo funny Help has a sense of the ironic

Thanks Lonnie,
I did just that. I was (once again) overworking the problem and creating my 
own dilema.
_d


"Things are only free to the extent that you don't pay for them".-Don 
Elliker





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

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com