Use a command button or label to hyperlink to an ftp:\anyn..

Thanks Tom, However, I hated to do this but I got it to work, I was able to
accomplish task by calling Internet explorer, then using the send keys
function in a macro which I hate to do by sending {f6} Then the URL followed
by the ~ for the return to take me to the the FTP site in IE.

"Tom Wickerath" wrote:

> Hi Brian,
>
> I don't know if it will work, but you might try using the
> Application.FollowHyperlink method with your URL. You can call this method in
> the Click event of a command button.
>
>
> Tom Wickerath
> Microsoft Access MVP
> [URL="http://www.accessmvp.com/TWickerath/"]http://www.accessmvp.com/TWickerath/[/URL]
> [URL="http://www.access.qbuilt.com/html/expert_contributors.html"]http://www.access.qbuilt.com/html/expert_contributors.html[/URL]
> __________________________________________
>
> "BrianPaul" wrote:
>
> > I would like to use a command button or label on a form that would bring up
> > IE explorer and ftp to a site I use to upload files to. I tried to use the
> > url in the hyperaddress property but didnt work. Any help or work around
> > would be greatly appreciated.
> >
> > Thanks
 >> Stay informed about: Use a command button or label to hyperlink to an ftp:\anyn.. 

Hi Brian,

I think--but I'm not positive--that SendKeys has been blocked in the new
Vista operating system, so you might want to test that now, if you are
currently using Windows XP for your development work, so that you are not
rudely surprised in the future.

Terry Wickenden has a site that includes some information on SendKeys, along
with links at the bottom of the page to the MVPS site:

[URL="http://www.accessruncommand.com/sendkeys.htm"]http://www.accessruncommand.com/sendkeys.htm[/URL]


Tom Wickerath
Microsoft Access MVP
[URL="http://www.accessmvp.com/TWickerath/"]http://www.accessmvp.com/TWickerath/[/URL]
[URL="http://www.access.qbuilt.com/html/expert_contributors.html"]http://www.access.qbuilt.com/html/expert_contributors.html[/URL]
__________________________________________

"BrianPaul" wrote:

> Thanks Tom, However, I hated to do this but I got it to work, I was able to
> accomplish task by calling Internet explorer, then using the send keys
> function in a macro which I hate to do by sending {f6} Then the URL followed
> by the ~ for the return to take me to the the FTP site in IE.
 >> Stay informed about: Use a command button or label to hyperlink to an ftp:\anyn..