Mark A Matte
markamatte at hotmail.com
Wed May 9 12:01:37 CDT 2007
Drew, Ok...now I'm laughing at myself. I found a module that called a windows dialogue box to get a file and path. This module used the InstrRev. I guess I got so fixated on what the example was...I overlooked the obvious. Thanks for pointing this out. Still laughing, Mark >From: "Drew Wutka" <DWUTKA at marlow.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] InstrRev in A97 >Date: Wed, 9 May 2007 11:39:47 -0500 > >The easiest way to get a file name from a full path is Dir. One line. > >Drew > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte >Sent: Wednesday, May 09, 2007 10:49 AM >To: accessd at databaseadvisors.com >Subject: [AccessD] InstrRev in A97 > >Hello All, > >With my lst excel issue...I needed to extract a file name in A97 from a >path. The InstrRev function would have been handy. And I found that >someone had written it. Seemed very useful...so I thought I'd share. > >Thanks, > >Mark A. Matte > >http://www.tek-tips.com/faqs.cfm?fid=4342 > >_________________________________________________________________ >PC Magazine's 2007 editors' choice for best Web mail-award-winning >Windows >Live Hotmail. >http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migr >ation_HM_mini_pcmag_0507 > >The information contained in this transmission is intended only for the >person or entity to which it is addressed and may contain II-VI Proprietary >and/or II-VI BusinessSensitve material. If you are not the intended >recipient, please contact the sender immediately and destroy the material >in its entirety, whether electronic or hard copy. You are notified that any >review, retransmission, copying, disclosure, dissemination, or other use >of, or taking of any action in reliance upon this information by persons or >entities other than the intended recipient is prohibited. > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ More photos, more messages, more storageget 2GB with Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_2G_0507