[AccessD] Transferring Files via FTP

Stuart McLachlan stuart at lexacorp.com.pg
Tue May 5 19:46:21 CDT 2020


I actually find they are a lot less readable than prefixes.

If I wrote that today, I'd use lngRet   :-)



On 6 May 2020 at 12:36, David Emerson wrote:

> Thanks.  So they are just for readability.  ret is the same as ret&
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of John Bodin Sent: Wednesday, 6 May 2020 12:24 p.m. To: Access
> Developers discussion and problem solving Subject: Re: [AccessD]
> Transferring Files via FTP
> 
> shorthand for the types are: % -integer; & -long; @ -currency; #
> -double; ! -single; $ -string
> 
> -----Original Message-----
> From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of
> David Emerson Sent: Tuesday, May 5, 2020 8:19 PM To: 'Access
> Developers discussion and problem solving'
> <accessd at databaseadvisors.com> Subject: Re: [AccessD] Transferring
> Files via FTP
> 
> Thanks Stuart,
> 
> I am curious about the use of "&" at the end of one of your variables:
> 
>    Dim ret As Long
> 
>    ' Start the shelled application:
>    ret& = CreateProcessA(0&, Pathname, 0&, 0&, 1&,
>    NORMAL_PRIORITY_CLASS,
> 0&, 0&, start, proc)
>    ' Wait for the shelled application to finish:
>    ret& = WaitForSingleObject(proc.hProcess, INFINITE)
>    ret& = CloseHandle(proc.hProcess)
> 
> What does the & do?
> 
> Regards
> 
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
> 
> 
> 
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Stuart McLachlan Sent: Wednesday, 6 May 2020 11:42 a.m. To: Access
> Developers discussion and problem solving Subject: Re: [AccessD]
> Transferring Files via FTP
> 
> Heres' a  modFTP from an old application of mine which uses the built
> in Windows FTP client and an FTP script generated "on the fly".  It
> will need PTRSAFE, LONGPTR etc modifications for Officer 64bit.
> 
> (Code deleted to keep message size reasonable)
> 
> On 6 May 2020 at 11:07, David Emerson wrote:
> 
> > Hi Listers,
> > 
> > I hope everyone is keeping safe.
> > 
> > Can anyone give me recommendations for code/software so that I can
> > log into a secure FTP site using a username and password, and 
> > upload and download files via vba?
> > 
> > Regards
> > 
> > David Emerson
> > Dalyn Software Ltd
> > Wellington, New Zealand
> 
> --
> 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
> 




More information about the AccessD mailing list