Results 1 to 4 of 4

Thread: Access add-ins

  1. #1
    Join Date
    May 2011
    Posts
    13

    Unanswered: Access add-ins

    Hey up everyone,

    First time poster here, and only recently back into Access/VB to help out my uncle in law with a little project -- it's been about 4/5 years, and I'm now a web developer so this is fairly unknown territory.

    Basically he was paying someone to help him set-up a database for his business that makes use of VB-based (I believe) add-ins, to perform fairly simple functionality like creating a new client, new invoice, etc. Just basically managing the tables behind it.

    Unfortunately this developer he hired has become awfully difficult to get hold of, and so the project is at a halt. He's asked if I can help him just get the last few issues sorted so he can use it properly. I only have the source data base (with .mdb extension) and another (again with .mdb extension) which contains the add-ins, a little splash screen and such - I'm guessing the kind of programmed part of it.

    The add-ins however I'm not particularly familiar with. Is it possible to open up the add-ins (without having the source files) for edit, or to at least extract the source code behind them? Obviously with the original developer going AWOL it's a bit of an awkward situation, and I'm a little confused at the moment, any help would be gratefully appreciated! I'm sure once I can get the source code of them and know how to make changes / test I'll be on my way no problem...

    Thanks

    Adam

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    If you have access (no pun intended) to what seems to be a front-end ("another (again with .mdb extension) which contains the add-ins", you should be able to open it and examine its objects (mainly forms I guess) and analyze the VBA code contained in the Forms modules and in independant modules.
    Have a nice day!

  3. #3
    Join Date
    May 2011
    Posts
    13
    Ah yes of course - thanks! I thought I'd tried looking at the objects on the left for stuff like that but must have just checked the source database.

    Anyway, I have found the VB code I was looking for so I can get on with it! Maybe seeing a little more of me in future.

    Thanks again for the pointer,

    Adam

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

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