[AccessD] Pseudo Pointer to a Function

William,


    It appears that the procedure / function called by CallByName() function has to be in a class module. Could you kindly verify again whether it works successfully for procedures / functions contained in general modules ?

    I am getting error 438 in such a case.

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

  ----- Original Message ----- 
  From: William Hindman 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, June 23, 2009 23:21
  Subject: Re: [AccessD] Pseudo Pointer to a Function


  Arthur

  ...from my treeview menu I use either of the following in a select statement
              'call a function from a module, "strObjectName" is from my 
  tblSwitchboard
              CallByName modules("mdlMenuFunctions"), strObjectName, VbMethod

              'call a sub from the switchboard form module itself
              CallByName CodeContextObject, strObjectName, VbMethod, 
  strObjectAddtnl

  ...hth
  William

  --------------------------------------------------
  From: "Arthur Fuller" <fuller.artful at gmail.com>
  Sent: Tuesday, June 23, 2009 12:04 PM
  To: "Access Developers discussion and problem solving" 
  <accessd at databaseadvisors.com>
  Subject: Re: [AccessD] Pseudo Pointer to a Function

  > Thanks, Mike. I vaguely recall that call and shall now write a little 
  > tester
  > to see if it works as one might desire.
  > A.
  >
  > On Tue, Jun 23, 2009 at 11:45 AM, Mike Mattys 
  > <mmattys at rochester.rr.com>wrote:
  >
  >> Hi Arthur,
  >>
  >> There is a CallByName function
  >> I saw an example at PlanetSourceCode and a few items
  >> in Google regarding its use.