Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002
    Location
    Hamilton,Ontario
    Posts
    132

    Unanswered: I have a Question about integrating VB modules to ACCESS modules

    Hi Every one!
    I am working on this software in Access.The way its made , it wont let me make any changes to existing modules, which is really pain becuase i have to make all fucntions on the form which is not convenient for performance of the system. I was wondering If I can make Module in visual Studio 6 and import it in to Access 2002 . Will that do the trick?
    Thanx in Advance.
    VBAPROGRAMMER

  2. #2
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251
    you can create DLL in Visual Basic and easily use that...... DLL can but does not need to be registered DLL....

    this way you can enjoy your functions across all Access, Excel, Word, VB, ....


    you can even use another MDB as an source of your functions....



    jiri

  3. #3
    Join Date
    Nov 2002
    Location
    Hamilton,Ontario
    Posts
    132
    so can you tell me if im on right track please
    1-Create a new "ActiveX DLL" project
    2-There is one class in the project.
    Open the class in the code window and create a public function...
    and throw all my functions there
    3.Save the project. You can name the project and class anything you like.
    4-Click on the File menu and Choose MAKE (Name).dll

    Am I on right track?
    AND Now how do i reference that dll from my access application?
    I have no pervious exp with DLLS ,its my first time i will a DLL, and system performance .
    I will appreciate your help.
    thanx in advance.

  4. #4
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251
    i don't have here VB, but yes...

    there is also PURE MDB way....

    1. Create new MDB and call it let's say MYFUNCTIONS
    2. Create New Functions OR new CLASSes
    3. close the MYFUNCTIONS MDB
    4. open your MDB file, go to VBA and add REFERENCE to MYFUNCTIONS MDB

    then you can enjoy FUNCTIONS and CLASSES stored in MYFUNCTIONS MDB. This is maybe better than DLL, cauze anybody can easily fix errors....



    jiri

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •