Recent content by cajulien

  1. C

    Searching through VBA accross multiple MDB's

    "Why is running the autostart mode actually so bad?" Because there's code that runs OnLoad or OnOpen of the autostart form, this code does a bunch of stuff we do not want to run. As I stated, point is to develop an "Object Dependencies" like the current Access attempt but from A.accdb that...
  2. C

    Searching through VBA accross multiple MDB's

    Clearly I've created confusion with inadequately specific choice of words: apologies. Yes this thread was about opening code modules of B from A, this is done and good, ty. As a follow-up, - from A I'd like to find out which of B's queries and tables are used as recordsource in any of B's...
  3. C

    Searching through VBA accross multiple MDB's

    Because, as this thread's history states, using OpenDatabase runs the autostart logic i.e., the default form opens up and its on load/onOpen logic runs automatically and we definitely don't want this.
  4. C

    Searching through VBA accross multiple MDB's

    Could be I should create a new thread for this one but it's related to the broader topic of documenting Access apps and finding their unused objects. Same context as above: A.accdb needs to access an old B.mdb and document it. At this point I'm trying to determine object dependencies of B.mdb...
  5. C

    Searching through VBA accross multiple MDB's

    That's it!!! That's finally what I was looking for. Thanks so much @Josef P. The short of it: Add reference from file Loop through VB Projects Find the one you just referenced Loop through VB components of the Vb Project Get the name, type, and full code i.e., codeModuleObj.Lines(1...
  6. C

    Searching through VBA accross multiple MDB's

    @Pat Hartman : not sure where we are on this one...are you adding something to my original question or is this something different now? From CurrentDb I'm already opening ThatDb in the default (0) workspace, problem is that I can't access ThatDb.mdb's module's VBA code, and I can't SaveToText...
  7. C

    Searching through VBA accross multiple MDB's

    Am reading 20+ year old posts about this issue...seems there's no way around preventing the autorun from launching on OpenCurrentDatabase except using Windows API to pretend like "user" is pressing SHIFT...
  8. C

    Searching through VBA accross multiple MDB's

    Oh noooo!!! .OpenCurrentDatabase actually opens the second.MDB as if a user did, which then triggers all the autostart logic...we definitely DON'T want to do that. Is there a way to OpenCurrentDatabase with a "Press SHIFT" option so nothing runs on its own? On the plus side the Module's code...
  9. C

    Searching through VBA accross multiple MDB's

    Ho...now that's new and promising...let me try that. Thanks so much @ebs17
  10. C

    Searching through VBA accross multiple MDB's

    Gosh, thanks DBguy, I was hoping for a pure Access VBA solution but I'm starting to think this just isn't possible...
  11. C

    Searching through VBA accross multiple MDB's

    "modify the code to run from an external database" That's the problem guys: Application.SaveAsText acModule...is looking for module name in A.accdb, but the module name is found in B.mdb that is opened programmatically from A. I'd need to be able to do something like the following from...
  12. C

    Searching through VBA accross multiple MDB's

    Hi folks, been trying to figure this out for hours now...too many dead leads, maybe one of you can help. We've a large number of old MDB files, each with a bunch of modules. We're trying to save all the VBA code across all MDB's modules to a single ACCDB table so we can search through it for...
  13. C

    Automate Compact/Repair

    Ha yes, I understand. I had assumed each user has a local FE that links to server BE i.e., no one is sharing FE (I should stipulate this architecture assumption). Agreed that there's generally no reason to C&R FE. FE users DO NOT use such an admin tool: thus the name "Admin Compact DB tool". I...
  14. C

    Automate Compact/Repair

    What do you mean by "shared" in this case? Shared across front-ends? Across users? Across back-ends? I'm not sure I see the issue you're referring to so please educate me pls
  15. C

    Automate Compact/Repair

    I hear you, that's why by default the tool looks into the current folder and that's the way it should be used. But since users can change the folder I can see how the cross-computer issue might happen; in hindsight I'm thinking I shouldn't let users change the folder and this issue would never...
Top Bottom