Avatar of alevin16
alevin16
Flag for United States of America asked on

Access forms freezing

Hey Everyone,

I have a form freezing problem with my Access 2010 program.  The program has one main form that has an area where many different subforms could appear.  At seemingly random times, with different subforms trying to appear (so it is not just with one or another), the screen does something funky and the person using it has to shut down Access.

I have attached a picture of what it looks like, but basically you can see the main form BEHIND something that is trying to appear.  Sometimes that something is even the behind the scenes of Access. The subform area is under the line of buttons you see.

Here are some specifics that may be relevant:
1. The front and back end have not been split
2. Everyone accesses the same version via a shortcut on their desktop to where the program resides on a server
3. Even though there can be as many as 6-12 people on it at once, the issues above happen even if there are one or two on the system.

Any insights would be VERY helpful.
Thanks!
2014081395151258.jpg
Microsoft OfficeMicrosoft AccessVBA

Avatar of undefined
Last Comment
alevin16

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
alevin16

ASKER
Wow this was extremely helpful!  Thank you!  I am going to try this, I never knew about the decompile, that is definitely worth a shot (as well as the splitting)
Jeffrey Coachman

Just FYI,

To get better screenshots:
Hit the PrtScr button on your keyboard
Open MS Paint
Click edit-->Paste
Then save the file and post the file here using the "Insert Image" button:
Like this:
Sample screenshot
;-)

JeffCoachman
alevin16

ASKER
Thank you!  I appreciate any tips and tricks :D
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
alevin16

ASKER
We split it and all went well!