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

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" <delliker at hotmail.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>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 <JHewson at karta.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] 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
>> > <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