Results 1 to 3 of 3

Thread: vbe blues

  1. #1
    Join Date
    Dec 2009
    Location
    Antwerp (Belgium)
    Posts
    33

    Unanswered: vbe blues

    I would like to create a script (preferrably in access (2007)) that would ("The Builder")
    a) open access file with my code in it "The Master".
    b) copy that access file (to "The Production File")
    c) apply vbe code (from "The Builder") to code in the second ("Production") file.

    In fact I have the code to insert errorhandling code via VBE. I would like to code without any handling code in my master access file. Then I would like to copy the master file to a "production file" and apply the vbe code to the production file.

    I'm looking for ways to access the "activeproject" or the "codeproject" of a non currnet database. Should I be looking into addins or are there simpler ways to realise this.

    Thanks for any clue.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Dec 2009
    Location
    Antwerp (Belgium)
    Posts
    33
    Thanks. That is definitely a clue.

    So what you're saying is that I should be looking into ways to connect to "other" projects by "connecting" to them via the References.

    Thanks again.

Tags for this Thread

Posting Permissions

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