View code button top right corner of form does not display code on first try, stays on the form.

[Rico]

Comes up quickly on the second click.


Is it because my program has got to big.

[June7]

What "view code" button are you talking about - a custom button?

[Rico]

Thanks June7, I am in forms design, the 'view code' button is in the Tools area in the top right of screen.

[June7]

Do you have database set for Tabbed Documents? I always use Overlapping Windows.

That button is not actually on the form. It is on the ribbon.

When clicked first time do you immediately get the circular "working" cursor?

[moke123]

Wow all these years and I've never used that button.
What happens if you go to the Database tools tab and click on Visual Basic?

[isladogs]

You can also view the code using a button on your form. Use the following code on the button click event:

 DoCmd.OpenModule "Form_" & Me.Name

[Welshgasman]

Wow all these years and I've never used that button.
What happens if you go to the Database tools tab and click on Visual Basic?

Me too though for less years no doubt.

[moke123]

Regardless of which button I use to open the VBE, the first time I open it there is a very slight delay as opposed to subsequent openings. I would venture a guess that's due to loading add ins like M-z tools and smart indenter.

[Rico]

With the form open on my screen, if I click the - View Code - button, the circular "working" cursor comes on for 7 to 10 seconds, then stays on the form screen.
If I click it a second time the code screen comes up straight away.
Going thru the Property Sheet is no better.
Going thru the Database tools tab and click on Visual Basic is no better.
This does NOT happen to my smaller programs.

[June7]

Sorry, cannot replicate issue. Even with my largest db the VBE opens after several seconds without having to do a second click.

[Micron]

Time to ask how big the file is, especially since you raised the prospect in the first post?
Maybe it's the size, or it needs a compact/repair. Or it needs a decompile and recompile as well as c/r.

[isladogs]

It may be that you already have a lot of code windows open.
Close all code windows in the VBE then try opening the VBE again. This time it should open much faster.
If you have MZ Tools or similar, you may be able to click a menu command to close all open windows.

[Rico]

The size of the file is 32,432 KB .accdb
This size is AFTER I have compact/repair.
I only have one form open with no code windows open.
This file does not have TABLES, they are linked in from another file.
I do not have the same problems with my smaller size programs.

[June7]

My db is 28,504 KB accdb.
Takes about 10 seconds for VBE to open. Then every single code module is open. I don't know any way to prevent that.

[isladogs]

Just tested n a Access FE of 34428 KB and another of 144940 KB.
In each case, the VBE opens instantly if no other code windows are open.
There is a delay of 1-2 seconds if other code windows are open depending on the number of windows

For info, I'm using a very slow 11 year old workstation which runs Win10 & Office 365