Access V Basic

[JK]

Can anyone tell me whether I can write a visual basic programme from the v
basic package in Access that will do the same as the stand alone visual basic
package?

I have noted some of the free v basic code offered in this website and would
like to try them out but I only have the visual basic package that comes
with Access. Some of the visual basic code offered in this website refers
to other software i.e. excell, word etc. Can I use the code offered and 'paste
it into the visual basic software I have with Access and expect it to work
as if I was using a standalone v basic package. As a standaline package I
presume that would work with any software, you simply ask it or tell it to
do whatever with whatever proramme you ask it to. As an add on to Access,
does the vis basic programme have the same freedom.

Hope this makes sense!?

JK

[Arthur Wood]

JK,

VBA as implemented with Access (or Word or Excel or any other program
which used VBA as the "macro" language - which includes such Applications
as WorkPerfecvt(!!), AutoCad, etc to name jst a couple) IS NOT Identical
to VB 6 - Standalone. And, in general, you cannot create a VBA applcation
which does the same thing as an VB - Standalone program. What you build
within any of those Applcations which support VBA is an application that
is specific to that Application. And there are a number of limitations on
what can be done in VBA - for instance, VBA DOES NOT support control arrays.
And depending on which version of the Parent Application (Access 97 vs Access
2000, for instance), the version of VB which serves as the underlying basis
of the VBA implementation may be different - Access 97's version of VBA derices
most closely from VB 5, while Access 2000's VBA derives most closely from
VB 6.

In Access 97, while you can in fact create Class Modules, those Class Modules
DO NOT support raising Events. On the otehr hand, in Access 2000, the Class
Modules DO support raising Events.

In general, code provided for a specific implementation of VBA CANNOT be
simply pasted into another implementation without modification.

However, in general, your statement "As a standalone package I
presume that would work with any software, you simply ask it or tell it to
do whatever with whatever proramme you ask it to" IS NOT QUITE accurate.
It is not quite that simple, but that would involve FAR more space than
this forum provides.

Arthur Wood

"JK" <kerryjimkerry@cs.com> wrote:
>
>Can anyone tell me whether I can write a visual basic programme from the
v
>basic package in Access that will do the same as the stand alone visual
basic
>package?
>
>I have noted some of the free v basic code offered in this website and would
>like to try them out but I only have the visual basic package that comes
>with Access. Some of the visual basic code offered in this website refers
>to other software i.e. excell, word etc. Can I use the code offered and
'paste
>it into the visual basic software I have with Access and expect it to work
>as if I was using a standalone v basic package. As a standaline package
I
>presume that would work with any software, you simply ask it or tell it
to
>do whatever with whatever proramme you ask it to. As an add on to Access,
>does the vis basic programme have the same freedom.
>
>Hope this makes sense!?
>
>JK