<!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=610172817-25042003><FONT face=Arial color=#0000ff size=2>The
record(s) can be determined (actually the cells) by using the .SelLeft, .SelTop,
and .SelWidth properties.</FONT></SPAN></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Jim Dettman<BR>President,<BR>Online Computer Services of WNY,
Inc.<BR>(315) 699-3443<BR>jimdettman@earthlink.net </FONT></DIV>
<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:26 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>What I want to know is - what record is selected if the Selector has been
clicked and only if it's been clicked. I can't use the current record because
it's always a value. There is a form event (new) called OnSelectionChange but
that doesn't seem to be good for this (looked good, but ,too easy I guess). I
am updating /inserting a record in an intersection table if it's been
selected. <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: "Charlotte Foust" <CFOUST@INFOSTATSYSTEMS.COM>
<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 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><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>