how to prevent access VBA from opening all classes (1 Viewer)

Hello1 · Sep 12, 2019

A quick question...

Im opening my .accdb with the shift key and after that when I launch the VBA the VBA opens all my class objects and it takes some time.
I tried closing all of them and then close the .accdb and open it again. After that I opened the VBA again but again all the class objects open.
On some of my other .accdb I did the same and the class objects dont open when I launch VBA, what makes it load much faster and I open manually just the class object hich I need.
Is this the work of the shift key? But then how dont they open on some of my other .accdb, I also use the shift key there?

Thanks

theDBguy · Sep 12, 2019

Hello1 said:
On some of my other .accdb I did the same and the class objects dont open when I launch VBA, what makes it load much faster and I open manually just the class object hich I need.

Interesting. I couldn't duplicate this. I always get all the modules open even after I closed them. Can you tell any differences in the settings between your accdbs?

Hello1 · Sep 12, 2019

Nope, I cant find any difference in settings. In fact earlier I achieved this on one of my .accde and then I wanted to do it on the same one just with different linked tables and I couldn't.

theDBguy · Sep 12, 2019

Hello1 said:
Nope, I cant find any difference in settings. In fact earlier I achieved this on one of my .accde and then I wanted to do it on the same one just with different linked tables and I couldn't.

I'll try to open as many files today as possible just to see if I can find one that behaves differently and let you know if I find anything.

Hello1 · Sep 12, 2019

Alright, I found it out. After closing all the class objects, I just had to do a compile :banghead:

After that when I relaunch the .accdb the class objects dont open

theDBguy · Sep 12, 2019

Hello1 said:
Alright, I found it out. After closing all the class objects, I just had to do a compile :banghead:

After that when I relaunch the .accdb the class objects dont open

Ah, I can confirm this works. Thanks!

isladogs · Sep 12, 2019

See this link for some code that may speed things up for you :
Close all VBE windows

Hello1 · Sep 12, 2019

Awesome, I will see to implement that.
Thanks

theDBguy · Sep 12, 2019

isladogs said:
See this link for some code that may speed things up for you :
Close all VBE windows

It's too bad there's no keyboard shortcut for that. Thanks!

theDBguy · Sep 12, 2019

theDBguy said:
It's too bad there's no keyboard shortcut for that. Thanks!

Oh, I guess there is sort of one keyboard shortcut we could use for this. Just keep holding down Ctrl+F4 until all the windows are closed. Cheers!

isladogs · Sep 12, 2019

theDBguy said:
Oh, I guess there is sort of one keyboard shortcut we could use for this. Just keep holding down Ctrl+F4 until all the windows are closed. Cheers!

Easily done!
I have an autokeys macro that does exactly that.
I use CTRL+SHIFT+X but you can use anything you like.
Take care not to overwrite an existing Access keyboard shortcut

In fact I mentioned doing that in the link I provided

theDBguy · Sep 12, 2019

isladogs said:
Easily done!
I have an autokeys macro that does exactly that.
...
In fact I mentioned doing that in the link I provided

Nice. Thanks!

how to prevent access VBA from opening all classes (1 Viewer)

Hello1

Registered User.

theDBguy

I’m here to help

Hello1

Registered User.

theDBguy

I’m here to help

Hello1

Registered User.

theDBguy

I’m here to help

isladogs

MVP / VIP

Hello1

Registered User.

theDBguy

I’m here to help

theDBguy

I’m here to help

isladogs

MVP / VIP

Attachments

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread