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 10 Jun 2010 16:07 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
From: Stuart McCall on 10 Jun 2010 17:54 "Lou O" <lgeastwood(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
From: Lou O on 11 Jun 2010 09:11 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.
From: Lou O on 11 Jun 2010 12:28 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. 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 ;-) 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? If not, could anyone point me to a solution for this?
From: Stuart McCall on 11 Jun 2010 13:06
"Lou O" <lgeastwood(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>. |