<!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=830220918-25042003><FONT face=Arial color=#0000ff
size=2>Don,</FONT></SPAN></DIV>
<DIV><SPAN class=830220918-25042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=830220918-25042003><FONT face=Arial color=#0000ff
size=2><<<FONT face="Times New Roman" color=#000000 size=3> It's kind of
an odd one, no?>></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=830220918-25042003></SPAN> </DIV>
<DIV><SPAN class=830220918-25042003><FONT face=Arial color=#0000ff size=2>
Yes,very odd. Not what you'd expect to use.</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:50 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>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* </BLOCKQUOTE></BODY></HTML>