Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    102

    Unanswered: Passing an array as an arguement in Access VBA

    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

  2. #2
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    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
    Kind regards,
    Dennis

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Well, either it is a subroutine or a function - you need to be specific since you are using sub.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •