[AccessD] Parameter (argument) order

Arthur Fuller fuller.artful at gmail.com
Thu Feb 16 22:49:10 CST 2023


Hi Stuart,

Thanks for this which I shall promptly test, but to answer your question, I
got it from the docs at Microsoft Learn. I should have known better. :)

On Thu, Feb 16, 2023 at 10:52 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> On 16 Feb 2023 at 11:08, Arthur Fuller wrote:
>
> > The thing that bugs me is that the only way to pass an array is by
> > using ParamArray, which must be the last argument.
>
> Where did you get that idea?
>
> Function paramtest() As Long
> Dim a(10) As String
> Fillarr a(), 3, "Hello"
> Debug.Print a(3)
> End Function
>
> Function Fillarr(arr() As String, idx As Long, sVal As String) As Long
>    arr(idx) = sVal
> End Function
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur


More information about the AccessD mailing list