Search results

"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...

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...

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.

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...

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...

@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...

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...

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...

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

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

"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...

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...

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...

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

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...

Gosh, I have to imagine I'd tinkered with that without noticing it's impact. Thanks so much.

Tool to let your clients compact themselves I couldn't find a general tool to let clients perform compact/repair on their own, so I made one that I'm happy to share and get your feedback. I've got it running at one client's site but there surely somethings I could improve. Hope this helps...

Disclaimer: I love drag & drop, I think it makes UX sense. This being said, my current position is that it is generally not worth the complexity and reliably issues to implement in Access, but I could be wrong obviously. I researched and developed drag & drop from Win Explorer a few months...

Hi Spud, I just spent some time with this last week: used the following insightful post https://www.access-programmers.co.uk/forums/threads/auto-updater.303898/ , which I assume you'd read. As per your specific question: I had similar issues and it came down to have a time delay between the...

That's usually the way of things, its all about appropriate use in the right context. I appreciate the welcome, ty