UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Opening Vba Editor, Access 2016    
 
   
dhapp
post Dec 4 2019, 09:42 AM
Post#1



Posts: 1,162
Joined: 17-November 03
From: Hamburg, NY


I am experiencing a long wait time when entering the VBA editor.

MS Access 2016 (32 bit)
Win 10 (64 bit)

If I open one of my projects and enter Alt F11 it takes about 1 min and 20 seconds before the editor opens. If I close the editor and enter Alt F11 again the editor opens immediately.

Any thoughts?

Doug

--------------------
Doug
When the eagle is away, the crow says, "I am the eagle."
Go to the top of the page
 
GroverParkGeorge
post Dec 4 2019, 09:52 AM
Post#2


UA Admin
Posts: 36,181
Joined: 20-June 02
From: Newcastle, WA


Make sure your VBA compiles.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
cheekybuddha
post Dec 4 2019, 10:08 AM
Post#3


UtterAccess Moderator
Posts: 11,907
Joined: 6-December 03
From: Telegraph Hill


Also, do you have any forms with timer events open?

--------------------


Regards,

David Marten
Go to the top of the page
 
dhapp
post Dec 4 2019, 10:14 AM
Post#4



Posts: 1,162
Joined: 17-November 03
From: Hamburg, NY


George,
Yes it does compile, as evidenced by this test:
Open any of my projects that is currently working properly with all functionality.
Alt-F11
Long Wait time. VBA editor opens.
Close VBA editor.
Alt-F11
VBA editor opens instantly.
While editor is open, Click Debug --> Compile the project.
No errors displayed.
Close editor.
Close project.

Open the same project.
Alt-F11
Long Wait time. VBA editor opens.

pullhair.gif


--------------------
Doug
When the eagle is away, the crow says, "I am the eagle."
Go to the top of the page
 
dhapp
post Dec 4 2019, 10:16 AM
Post#5



Posts: 1,162
Joined: 17-November 03
From: Hamburg, NY


No forms with timers.
This behavior is relatively new; I've been working on these same project for about a decade through several versions of OS and version of MS Access

--------------------
Doug
When the eagle is away, the crow says, "I am the eagle."
Go to the top of the page
 
GroverParkGeorge
post Dec 4 2019, 10:47 AM
Post#6


UA Admin
Posts: 36,181
Joined: 20-June 02
From: Newcastle, WA


It won't necessarily identify the source of the problem, but one thing people frequently do is to create a new, empty accdb and import all of the objects from the old one. Sometimes that does clear up otherwise inexplicable problems.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
JeffK
post Dec 4 2019, 10:47 AM
Post#7


UtterAccess VIP
Posts: 1,575
Joined: 19-December 02
From: Lansing, MI


Do you have any add-ins? MZ Tools for example? That adds some time to the VBE opening for me. Certainly not over a minute, but maybe you have others that are causing lag.

Does your project reference another VBA project? We have several databases that use other databases as references, and I always have to remember when compiling and versioning up the referenced databases to close all their modules. Otherwise the referencing database will open them all when the VBE opens, which can add a lot of time.
Go to the top of the page
 
dhapp
post Dec 4 2019, 12:24 PM
Post#8



Posts: 1,162
Joined: 17-November 03
From: Hamburg, NY


George,

I have used the rebuild solution before for quirky problems with mixed results. Since I am managing 13 projects from this one workstation and they all show the same slow behavior I doubt that rebuild is the solution. That being said I may, when I get some time, try it on one of the projects.

This problem has been an annoyance for the at least a month, I have not tested or quantified the timing until today. It is possible that the long wait time has increased slowly of time and finally became long enough to become a hindrance to work. When I posted the problem I was wondering if anyone else has experienced this problem.

Doug

--------------------
Doug
When the eagle is away, the crow says, "I am the eagle."
Go to the top of the page
 
theDBguy
post Dec 4 2019, 12:28 PM
Post#9


UA Moderator
Posts: 76,866
Joined: 19-June 07
From: SunnySandyEggo


Hi Doug. I have experienced this, and as JeffK said, try closing all your open modules before closing the db (you may have to save it first, as well, by clicking on the save icon on the VBE toolbar). Cheers!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    11th December 2019 - 09:22 AM