Access V Basic


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Access V Basic

  1. #1
    JK Guest

    Access V Basic


    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

  2. #2
    Arthur Wood Guest

    Re: Access V Basic


    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center