Re: Help with some VB Code

>>
>The limitation of Interpreted programming
code is that you can't perform OOP operations.

Once again I said the above is incorrect, and there are many interpreted
languages is today that are full oop. And, I pointed out that in fact
the ..net environment relies on a p-code runtime system, very similar to
that of the vba. (and I believe on windows mobile, and also the XNA
system for xbox, there is no JIT either).
<<

Your point is precisely my point -- 
>>
there are many interpreted languages is today that are full oop
<<

When something cannot be achieved in VBA - or achieved easily
>>there are many interpreted languages is today that are ..

it is time to investigate other technologies.  I believe Ruby On Rails
is one of these OOP interpreted languages (OK, I see your point on my
comment about interpreted languages - so I meant just VBA).  I don't
happen to be familiar with Ruby except that I don't think it would be as
easy to integrate with Access as a .Net solution.  I am fairly familiar
with .Net because I have been using it for the last 6+ years.  The
suggestions I provide are all Microsoft based since Access is Microsoft
and just about all the computer technology I use is created by
Microsoft.  

Just an aside: sql server 2005/.Net (and sql 2008/.Net more so) is
taking the Access paradigm to the next level where - again - you have an
integrated database development environment - except fully OOP/server
based and sup****ts multiple languages (C# and VB.Net being the most
popular).

Access is kind of like the grandfather of the new(er) database paradigms
Microsoft is developing.  And like grandpa, Access is encountering
various limitations.  And Microft, I read, is outselling Oracle with its
newer paradigms.

Rich

*** Sent via Developersdex http://www.developersdex.com
***