<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=130243917-25042003><FONT face=Arial color=#0000ff
size=2>Don,</FONT></SPAN></DIV>
<DIV><SPAN class=130243917-25042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=130243917-25042003><FONT face=Arial color=#0000ff
size=2> From the online help:</FONT></SPAN></DIV>
<DIV><SPAN class=130243917-25042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=130243917-25042003><FONT face=Arial color=#0000ff size=2>"You
can use the SelTop property to specify or determine which row (record) is
topmost in the current selection rectangle in a table, query, or form datasheet,
or which selected record is topmost in a continuous form. You can use the
SelLeft property to specify or determine which column (field) is leftmost in the
current selection rectangle. For example, if you've selected a group of rows and
columns within Datasheet view of the Customers table, you can use the SelTop and
SelLeft properties to determine the first row and first column selected in the
selection rectangle.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=130243917-25042003><FONT face=Arial color=#0000ff
size=2>Setting</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=130243917-25042003><FONT face=Arial color=#0000ff
size=2>· The SelTop property. A Long Integer value between 1 and the number
of records in the datasheet or continuous form. The setting of this property
specifies or returns the number of the topmost row in the current selection
rectangle or the number of the topmost selected record in the continuous
form.<BR>· The SelLeft property. A Long Integer value between 1 and the
number of columns in the datasheet. The setting of this property specifies or
returns the number of the leftmost column in the current selection
rectangle.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=130243917-25042003><FONT face=Arial color=#0000ff size=2>These
properties aren't available in Design view. These properties are available only
by using a macro or Visual Basic.</FONT></SPAN></DIV>
<DIV><SPAN class=130243917-25042003><FONT face=Arial color=#0000ff
size=2>"</FONT></SPAN></DIV>
<DIV><SPAN class=130243917-25042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=130243917-25042003><FONT face=Arial color=#0000ff size=2>and
width of course how far across the form.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>Jim Dettman<BR>President,<BR>Online Computer Services of WNY,
Inc.<BR>(315) 699-3443<BR>jimdettman@earthlink.net </FONT></P>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Don
Elliker<BR><B>Sent:</B> Friday, April 25, 2003 1:34 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Events for
continuous forms<BR><BR></FONT></DIV>
<DIV>
<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*. </BLOCKQUOTE></BODY></HTML>