Jim Dettman
jimdettman at earthlink.net
Fri Apr 25 12:40:13 CDT 2003
Don, From the online help: "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. Setting · 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. · 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. These properties aren't available in Design view. These properties are available only by using a macro or Visual Basic. " and width of course how far across the form. 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:34 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Events for continuous forms Very cryptic Jim...how does this tell me the records been clicked? _d "Things are only free to the extent that you don't pay for them." >From: "Jim Dettman" >Reply-To: accessd at databaseadvisors.com >To: >Subject: RE: [AccessD] Events for continuous forms >Date: Fri, 25 Apr 2003 13:31:27 -0400 > >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*. >_______________________________________________ >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/538071ee/attachment-0001.html>