Solved Windows 11 Slow Opening Forms

Thanks for the quick response, AH.
I did as you suggested, and VBE did open faster, but I think it was a function of having no code windows open, and all the folders in the project window were closed. I saw no improvement in the database performance.
When I opened the folders in the Project pane, they opened slowly, and scrolling within that pane remained sluggish.

I cranked up the processor memory allocation to the virtual machine, and saw a very small increase of speed, which leads me to think there's some gum in the pipes somewhere within the Fusion / Windows / Access interactions. It seems very much graphics-oriented problem. Probabaly not the province of this forum.
 
perhaps try the solutions suggested in this thread?
 
I found the source of this slowdown problem.
I have not found the solution, but if others bump in to this, it may help them.

My database application is designed to be used for specific projects. On almost all forms, the name of the active project is shown at the top corner of the form. The user has the option of creating a graphic image or logo to represent a particular project, and that image replaces the text name of the project. It looks pretty. The project's image is loaded into the form on opening.

The problem is that in this iteration of Access, the code to load the graphic adds 2-4 seconds to the opening. The graphic pops up immediately but the form sits there naked of data. THEN the form fills in and behaves normally. When the graphic option is turned off and only a text of the project name is displayed, the form opens and populates quickly.

I've tried using a much smaller-sized graphic file, but no difference.
I've tried using .bmp instead of jpg, but no difference.
I've tried moving the code:

'ctlLogoPix is the control, pLogoGpath = path to the graphic file.
ctlLogoPix.Picture = pLogoGPath

to the On Activate instead of On Open, but it just puts a delay in a different sequence of events.

I'm still experiencing slow performance both in the VBA editor and the application itself.
 
You load the image for each form from a file every time?
You could place it into the Image Gallery once for the current project and put a reference there into every form. I would give it a try.

See this answer from a well known forum member which belongs to that Image Gallery. :)
 

Users who are viewing this thread

Back
Top Bottom