Jim Dettman
jimdettman at earthlink.net
Fri Apr 25 12:31:27 CDT 2003
The record(s) can be determined (actually the cells) by using the .SelLeft, .SelTop, and .SelWidth properties. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Don Elliker Sent: Friday, April 25, 2003 1:26 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Events for continuous forms 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. _D "Things are only free to the extent that you don't pay for them." >From: "Charlotte Foust" >Reply-To: accessd at databaseadvisors.com >To: >Subject: RE: [AccessD] Events for continuous forms >Date: Fri, 25 Apr 2003 09:45:04 -0700 > >Use the form's OnCurrent event. That happens whenever you move to a new >record. > >Charlotte Foust > >-----Original Message----- >From: Don Elliker [mailto:delliker at hotmail.com] >Sent: Friday, April 25, 2003 8:42 AM >To: accessd at databaseadvisors.com >Subject: [AccessD] Events for continuous forms > > >I would like to know when I move to a particular record in a continuous >form, that I have done so..what it is etc. All I really want is to trap >the event (if there is one) when I select a record with the Record >Selector. I have looked thru the remarkably obtuse Help (AXP)- no joy >has occured. >TIA >_D > > > > >"Things are only free to the extent that you don't pay for them." > >From: Seth Galitzer > >Reply-To: accessd at databaseadvisors.com > >To: accessd > >Subject: Re: [AccessD] Recordset into Text File > >Date: 25 Apr 2003 10:35:06 -0500 > > > >Ryan, > > > >Have a look at my website in my downloads area. You'll find a link on > >File I/O in VB. That's the best way to get it done. The code there > >should get you started. > > > >Seth > > > >On Fri, 2003-04-25 at 10:27, Smethurst, Ryan wrote: > > > > > > > > Hi All, > > > > > > Can anyone tell me the best way to 'save/export' records from a >recordset > > > into a text file? > > > > > > TIA > > > > > > RyanS > > > > > > > > >-- > >Seth Galitzer sgsax at ksu.edu > >Computing Specialist http://puma.agron.ksu.edu/~sgsax > >Dept. of Plant Pathology > >Kansas State University > > > >_______________________________________________ > >AccessD mailing list > >AccessD at databaseadvisors.com > >http://databaseadvisors.com/mailman/listinfo/accessd > >Website: http://www.databaseadvisors.com > > > >Help STOP SPAM with the new MSN 8 and get 2 months FREE* >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com ---------------------------------------------------------------------------- -- MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030425/ecb7dd15/attachment-0001.html>