Prev: How do I use a value from an unbound listbox on a different form in query builder.
Next: convert access 2007 to access 2003...cannot save
From: Lou O on 11 Jun 2010 13:43 On Jun 11, 1:06 pm, "Stuart McCall" <smcc...(a)myunrealbox.com> wrote: > "Lou O" <lgeastw...(a)gmail.com> wrote in message > > news:de136f14-9dbd-4d41-819b-3a82fee0abcf(a)b29g2000vbl.googlegroups.com... > On Jun 11, 9:11 am, Lou O <lgeastw...(a)gmail.com> wrote: > > > > > On Jun 10, 5:54 pm, "Stuart McCall" <smcc...(a)myunrealbox.com> wrote: > > > > "Lou O" <lgeastw...(a)gmail.com> wrote in message > > > >news:b7d82b61-d388-4c89-945e-ec384fb869bb(a)b29g2000vbl.googlegroups.com.... > > > > >I need to obtain the name of files on a remote FTP site. I would like > > > > to navigate to the site using a common dialog control or better yet > > > > having the files displayed in a list box on a form. > > > > I've been partly successful using the common dialog control to > > > > navigate to the FTP site in My Network Places. However there are too > > > > many navigation options on the common dialog control. I want to > > > > restrict the path to the FTP site. Also for some reason I can't set > > > > the default directory of the common dialog control to the FTP site. If > > > > these 2 issues could be overcome then this would be a good solution.. > > > > > Displaying the files in a listbox on a form would be even better it > > > > seems to me. I've seen examples of populating a list box with the > > > > names of files residing on my computer but not files on a FTP site. > > > > > Does anyone have any thoughts on either method? > > > > Thanks > > > > Just what you need: > > > >http://www.smccall.demon.co.uk/Downloads.htm#FTPClient > > > Somewhere on my road to discover the FTP world in Access I've looked > > at FTP Client. > > At that point in my discovery I obviously overlooked a lot of the > > functionality of it. > > Thanks for pointing me back to it Stuart! > > To date I have all the uploading and downloading of FTP files working > > as required. > > Now with a second look at FTP Client, file management on an FTP site > > is beginning to open up . > > I hope as I dig into FTP Client I will discover a method to delete a > > file from the FTP site after I download it; my last (I hope) challenge > > with this FTP thing. > > Thanks again Stuart, also for authoring FTP Client. > > I have benefited greatly from you and many others on this site. Kudos > > to all of you. > > On behalf of everyone, thankyou. > > > I've tried to give back from time to time despite my deplorable lack > > of experience. > > I figure if I try to tackle some of the more rudimentary questions it > > allows seasoned MVP's as yourself to deal with the biggies ;-) > > That's an admirable attitude to take. I must point out however that I'm not > an MVP. I don't answer enough questions to deserve the title. > > > But enough shameless self-effacement (for now) > > > A look through FTP Client did not reveal to me a method to delete a > > file on a remote FTP site. > > Could that just be sloppiness on my part or is there actually not a > > method to delete a file? > > It's sloppiness on your part (your words!). The method is called DelFile. > Try looking again, with your eyes open this time <grin>. Excuse me while I change feet... and once again take advantage of the great resources on this group. .....there we go, that one fits better:-) |