<html><div style='background-color:'><DIV>
<P>Very cryptic Jim...how does this tell me the records been clicked?<BR>_d<BR></P></DIV>
<DIV></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Jim Dettman" <JIMDETTMAN@EARTHLINK.NET>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: RE: [AccessD] Events for continuous forms
<DIV></DIV>>Date: Fri, 25 Apr 2003 13:31:27 -0400
<DIV></DIV>>
<DIV></DIV>>The record(s) can be determined (actually the cells) by using the .SelLeft,
<DIV></DIV>>.SelTop, and .SelWidth properties.
<DIV></DIV>>
<DIV></DIV>>Jim Dettman
<DIV></DIV>>President,
<DIV></DIV>>Online Computer Services of WNY, Inc.
<DIV></DIV>>(315) 699-3443
<DIV></DIV>>jimdettman@earthlink.net
<DIV></DIV>> -----Original Message-----
<DIV></DIV>> From: accessd-bounces@databaseadvisors.com
<DIV></DIV>>[mailto:accessd-bounces@databaseadvisors.com]On Behalf Of Don Elliker
<DIV></DIV>> Sent: Friday, April 25, 2003 1:26 PM
<DIV></DIV>> To: accessd@databaseadvisors.com
<DIV></DIV>> Subject: RE: [AccessD] Events for continuous forms
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> What I want to know is - what record is selected if the Selector has been
<DIV></DIV>>clicked and only if it's been clicked. I can't use the current record
<DIV></DIV>>because it's always a value. There is a form event (new) called
<DIV></DIV>>OnSelectionChange but that doesn't seem to be good for this (looked good,
<DIV></DIV>>but ,too easy I guess). I am updating /inserting a record in an intersection
<DIV></DIV>>table if it's been selected.
<DIV></DIV>> _D
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> "Things are only free to the extent that you don't pay for them."
<DIV></DIV>> >From: "Charlotte Foust"
<DIV></DIV>> >Reply-To: accessd@databaseadvisors.com
<DIV></DIV>> >To:
<DIV></DIV>> >Subject: RE: [AccessD] Events for continuous forms
<DIV></DIV>> >Date: Fri, 25 Apr 2003 09:45:04 -0700
<DIV></DIV>> >
<DIV></DIV>> >Use the form's OnCurrent event. That happens whenever you move to a new
<DIV></DIV>> >record.
<DIV></DIV>> >
<DIV></DIV>> >Charlotte Foust
<DIV></DIV>> >
<DIV></DIV>> >-----Original Message-----
<DIV></DIV>> >From: Don Elliker [mailto:delliker@hotmail.com]
<DIV></DIV>> >Sent: Friday, April 25, 2003 8:42 AM
<DIV></DIV>> >To: accessd@databaseadvisors.com
<DIV></DIV>> >Subject: [AccessD] Events for continuous forms
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >I would like to know when I move to a particular record in a continuous
<DIV></DIV>> >form, that I have done so..what it is etc. All I really want is to trap
<DIV></DIV>> >the event (if there is one) when I select a record with the Record
<DIV></DIV>> >Selector. I have looked thru the remarkably obtuse Help (AXP)- no joy
<DIV></DIV>> >has occured.
<DIV></DIV>> >TIA
<DIV></DIV>> >_D
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >"Things are only free to the extent that you don't pay for them."
<DIV></DIV>> > >From: Seth Galitzer
<DIV></DIV>> > >Reply-To: accessd@databaseadvisors.com
<DIV></DIV>> > >To: accessd
<DIV></DIV>> > >Subject: Re: [AccessD] Recordset into Text File
<DIV></DIV>> > >Date: 25 Apr 2003 10:35:06 -0500
<DIV></DIV>> > >
<DIV></DIV>> > >Ryan,
<DIV></DIV>> > >
<DIV></DIV>> > >Have a look at my website in my downloads area. You'll find a link on
<DIV></DIV>> > >File I/O in VB. That's the best way to get it done. The code there
<DIV></DIV>> > >should get you started.
<DIV></DIV>> > >
<DIV></DIV>> > >Seth
<DIV></DIV>> > >
<DIV></DIV>> > >On Fri, 2003-04-25 at 10:27, Smethurst, Ryan wrote:
<DIV></DIV>> > >
<DIV></DIV>> > > >
<DIV></DIV>> > > > Hi All,
<DIV></DIV>> > > >
<DIV></DIV>> > > > Can anyone tell me the best way to 'save/export' records from a
<DIV></DIV>> >recordset
<DIV></DIV>> > > > into a text file?
<DIV></DIV>> > > >
<DIV></DIV>> > > > TIA
<DIV></DIV>> > > >
<DIV></DIV>> > > > RyanS
<DIV></DIV>> > > >
<DIV></DIV>> > >
<DIV></DIV>> > >
<DIV></DIV>> > >--
<DIV></DIV>> > >Seth Galitzer sgsax@ksu.edu
<DIV></DIV>> > >Computing Specialist http://puma.agron.ksu.edu/~sgsax
<DIV></DIV>> > >Dept. of Plant Pathology
<DIV></DIV>> > >Kansas State University
<DIV></DIV>> > >
<DIV></DIV>> > >_______________________________________________
<DIV></DIV>> > >AccessD mailing list
<DIV></DIV>> > >AccessD@databaseadvisors.com
<DIV></DIV>> > >http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>> > >Website: http://www.databaseadvisors.com
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >Help STOP SPAM with the new MSN 8 and get 2 months FREE*
<DIV></DIV>> >_______________________________________________
<DIV></DIV>> >AccessD mailing list
<DIV></DIV>> >AccessD@databaseadvisors.com
<DIV></DIV>> >http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>> >Website: http://www.databaseadvisors.com
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>----------------------------------------------------------------------------
<DIV></DIV>>--
<DIV></DIV>> MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>MSN 8 helps <a href="http://g.msn.com/8HMXENUS/2743">ELIMINATE E-MAIL VIRUSES. </a> Get 2 months FREE*.</html>