Jim Dettman
jimdettman at earthlink.net
Fri Apr 25 13:09:51 CDT 2003
Don, << It's kind of an odd one, no?>> Yes,very odd. Not what you'd expect to use. 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:50 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Events for continuous forms Jim, 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? Thanks, _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:40:13 -0400 > >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*. >_______________________________________________ >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* -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030425/cfaca1f2/attachment-0001.html>