Mark A Matte
markamatte at hotmail.com
Sat May 7 00:46:44 CDT 2005
Hello All, Ok...its late here...1:40am...and I hate to admit at this time ( and on Friday night), I'm sitting on the deck, by myself, drinking wine, and writing code...but Drew's sample was a lot more complicated than I expected...but I did some research and got it to loop through the ftp directory and get whatever file/files was/were there using FtpFindFirstFile and InternetFindNextFile functions (have to use these in conjunction to get multiple files from ftp...both in demo, but not used). I had to share with someone that could appreciate...anyway... This app is a stock analysis program that, if successful, will hopefully lead to "a lot of free time"...but either way...I'll have to stroke another check to databaseadvisors,a.k.a "AccessD"...6 years and still loving the list. Thanks Everyone, Mark A. Matte P.S...Drew...You saved me a lot of time...where do I visit to buy the next round? >From: DWUTKA at marlow.com >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] FTP Date: Wed, 4 May 2005 17:15:23 -0500 > >Just did. For anyone else, I put it at >http://www.wolfwares.com/AutomaticUpdater3.zip . Keep in mind, this is a >specific project, for a very specific purpose. I've wiped the site info >(address, username, password) from the 'settings' database, but other then >that, the code shows what it is doing, so if you want to play around with >downloading from an FTP site, unzipping (which you will need to purchase >Winzip, and download the addon), multi-threading (using events to traverse >the threads), making thumbnails, etc, then feel free to download and >explore. (Everything but the multi-threading will work in Access) > >Drew > >P.S.--Sorry that I don't have many comments in my code, it's a bad habit >I've gotten into with my personal projects.....since I'm not really getting >paid for them, I save time by not commenting.....all the more fun to play >with! LOL. > >-----Original Message----- >From: Perry Harold [mailto:pharold at proftesting.com] >Sent: Wednesday, May 04, 2005 3:32 PM >To: 'Access Developers discussion and problem solving' >Subject: RE: [AccessD] FTP > > >Drew > >If you wouldn't mind sending to me as well off list I think it might also >save me a bit of consternation in a project I have. > >Thanks >Perry Harold > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >DWUTKA at marlow.com >Sent: Tuesday, May 03, 2005 5:49 PM >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] FTP > > >Do you have VB 6.0 by any chance Mark? I ask, because I'd be more then >happy to send you the source to the project I just finished, which you can >probably use with just a little modification (including completely dropping >the image copying and thumbnail creation). You can read the source with >notepad, but it won't work correctly in Access 2000, since it's >multi-threaded (downloads and unzips in different threads), so you'd have >to >filter through that code to use it in Access. > >Drew > >-----Original Message----- >From: Mark A Matte [mailto:markamatte at hotmail.com] >Sent: Tuesday, May 03, 2005 3:25 PM >To: accessd at databaseadvisors.com >Subject: [AccessD] FTP > > >Hello All, > >I have some zipped files I need to retrieve and then delete from an FTP >site. I have the address, username, password, and rights to create/delete >from this site. I would like to automate this process in A2k. Anyone have >any suggestions/directions on the FTP thingy? > >Thanks, > >Mark A. Matte > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com