Passing an array as an arguement in Access VBA

ontheDB · #1 (**permalink**) 01-08-04, 17:11

Having troubles with this:

currently, i have:

sub function(ByRef arrayD() as string)

end sub

Dim ArrayA(100) as String

function(ArrayA())

what's wrong with this ?

thanks

Xl-Dennis · #2 (**permalink**) 01-10-04, 08:19

Hi,

Although it is a VBA-question which can be solved here in the Excel-forum I believe You will get better answers in the Access-forum.

Kind regards,
Dennis

rnealejr · #3 (**permalink**) 01-10-04, 11:01

Well, either it is a subroutine or a function - you need to be specific since you are using sub.

Internet Services

Web Development

Digital Marketing

Consumer Tech