<html><div style='background-color:'><DIV>
<P>Jim,<BR>Yep, sorry , I went and read that and it looks like the cats a*s for what I want to do. I must admit I have never had a need to use it. It's kind of an odd one, no?</P>
<P>Thanks,</P>
<P>_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:40:13 -0400
<DIV></DIV>>
<DIV></DIV>>Don,
<DIV></DIV>>
<DIV></DIV>> From the online help:
<DIV></DIV>>
<DIV></DIV>>"You can use the SelTop property to specify or determine which row (record)
<DIV></DIV>>is topmost in the current selection rectangle in a table, query, or form
<DIV></DIV>>datasheet, or which selected record is topmost in a continuous form. You can
<DIV></DIV>>use the SelLeft property to specify or determine which column (field) is
<DIV></DIV>>leftmost in the current selection rectangle. For example, if you've selected
<DIV></DIV>>a group of rows and columns within Datasheet view of the Customers table,
<DIV></DIV>>you can use the SelTop and SelLeft properties to determine the first row and
<DIV></DIV>>first column selected in the selection rectangle.
<DIV></DIV>>
<DIV></DIV>>Setting
<DIV></DIV>>
<DIV></DIV>>· The SelTop property. A Long Integer value between 1 and the number of
<DIV></DIV>>records in the datasheet or continuous form. The setting of this property
<DIV></DIV>>specifies or returns the number of the topmost row in the current selection
<DIV></DIV>>rectangle or the number of the topmost selected record in the continuous
<DIV></DIV>>form.
<DIV></DIV>>· The SelLeft property. A Long Integer value between 1 and the number of
<DIV></DIV>>columns in the datasheet. The setting of this property specifies or returns
<DIV></DIV>>the number of the leftmost column in the current selection rectangle.
<DIV></DIV>>
<DIV></DIV>>These properties aren't available in Design view. These properties are
<DIV></DIV>>available only by using a macro or Visual Basic.
<DIV></DIV>>"
<DIV></DIV>>
<DIV></DIV>>and width of course how far across the form.
<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>>
<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:34 PM
<DIV></DIV>> To: accessd@databaseadvisors.com
<DIV></DIV>> Subject: RE: [AccessD] Events for continuous forms
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> Very cryptic Jim...how does this tell me the records been clicked?
<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: "Jim Dettman"
<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 13:31:27 -0400
<DIV></DIV>> >
<DIV></DIV>> >The record(s) can be determined (actually the cells) by using the
<DIV></DIV>>.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
<DIV></DIV>>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
<DIV></DIV>>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>>-
<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></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>Help STOP SPAM with <a href="http://g.msn.com/8HMXENUS/2731">the new MSN 8 </a> and get 2 months FREE*</html>