ListO
Señor Member
- Local time
- Today, 19:58
- Joined
- Feb 2, 2000
- Messages
- 167
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.
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.