[AccessD] Test whether Array initialised

A.D.Tejpal adtp at airtelmail.in
Sat Jun 20 22:43:23 CDT 2009


    Thanks Jim! - for the corroborative confirmation. So nice of you.

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Jim Lawrence 
  To: 'Access Developers discussion and problem solving' 
  Sent: Sunday, June 21, 2009 00:53
  Subject: Re: [AccessD] Test whether Array initialised


  Hi A.D. Tejpal:

  Now that works perfect in every case... Good thought.

  Jim

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.Tejpal
  Sent: Saturday, June 20, 2009 11:13 AM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Test whether Array initialised

  Gustav, Stuart,

      The function given below could also be considered:

  '================================
  Function Fn_IsArrayInitialized(ByVal varArray _
                                      As Variant) As Boolean
      On Error Resume Next
      Fn_IsArrayInitialized = _
                  Not IsError(UBound(varArray) >= 0)
  End Function
  '================================

  Best wishes,
  A.D. Tejpal
  ------------


More information about the AccessD mailing list