RE: FN-FORUM: Access XP Class Modules

date posted 8th March 2006 22:11

As Ben has said, you need to look at your architecture and think if what
you're trying to do is the most appropriate solution. I can't remmeber
if under Access XP you have a "callbyname" type function or the ability
to point to a function / routine in memory - in effect the location is
determined at run-time so late bound. You might then be able to do
something with it.

One other option is to have a single property of the object that you're
creating and have a key/value collection of it, that way you have one
property of the object that holds multiple values for it and you can
access that value by a string, e.g.,

Myvalue =3D MyObject.Collection("myparam")

HTH
Cheers
Andy

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
Nicholas Smith
Sent: 08 March 2006 22:45
To: Andy Macnaughton-Jones
Subject: RE: FN-FORUM: Access XP Class Modules


I'm not using VB.net I'm using Microsoft Access XP using VBA coding.

I know that the property exists but rather than call the property direct
I'd rather like to call it using a variable (ie have one generic
function that is called from numerous places and has different inputs)


--
Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414
or visit www.prosperity4.com and benefit from Inland Revenue approved
expenses today.

To advertise here: http://www.freelancers.net/advertising.html