A dialog form appear in a very small shape

Hi:
I have a button to open a dialog form(in 2003 mdb file)
In most of the client workstations it works good (more than 15 workstations most of them are 2007 ) but some of them (almost two workstations 2007) the dialog form appear in very small shape and you cannot move it nor resize it again?
Anybody have an idea?

1.PNG
Mohammad Alsolaimanapplication programmerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
This is generally indication of corruption of the database, or troubles with the installation of Access on that machine.

To fix the corruption, you can just deploy a fresh copy of the database to those trouble machines. If you suspect corruption, however, it's generally a good idea to do this:

1) Make a backup fo the database
2) Compact
3) Compile - from the VBA Editor, click Debug - Compile. Fix and errors, and compile again
4) Compact
5) Decompile the database: Build a shortcut with this as the Target: "full path to msaccess.exe" "full path to your database" /decompile
6) Compile
7) Compact

If that works, it would be best to build a new, blank database and import everything into it.

If it's trouble with the installation of Access, then of course you must either repair or re-install.

Also, make sure that you've installed all relevant Service Packs and updates to both Windows and Office.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"the dialog form"
That's why you can't resize it probably.  As far as move ... maybe the Moveable property is set to No.

Occasionally, I have db that open this way ... just a 'bar' with the X ... had to even see that it's open, happens randomly on different systems.  Have never been able to figure out the cause.

mx
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
" had to even see that it's open, happens randomly on different systems.  Have never been able to figure out the cause."

I've had the same experiences with entire applications, and with individual forms. In some (most) cases just reopening the application will fix the problem, but in other cases I've had to go through the whole corruption rebuild steps above. I'm not 100% sure it was corruption, but that's the closest I can come up with.

0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Well, in my case there is no corruption that I am aware of ... and the next time you open it, it might be normal.  Basically what I see is in the image below, more or less ... and it might be anywhere on the desktop.

So, it's basically 'minimized' ... but there is no code doing such. The image here shows the database window - just for an example - but what's really minimized is the Access application window - I just couldn't get that to happen. And when this happens, it's NOT on the task bar initially. But I can then stretch it out to normal size, at which time is appears on the task bar - i think.

mx
Capture1.gif
0
Jeffrey CoachmanMIS LiasonCommented:
Also remember that the new "Document Windows options" might affect this as well.
(or perhaps one of the "Anchoring" options")

You say your app is 2003, (which was optimized for Windows XP), but it looks like you are opening it in Access 2007 and win 7

What happens you don't have the pop up set as dialog?
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I'm talking main A2003 ...

mx
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm not sure it's corruption either, and like you I've also been able to "fix" it by just reopening in most cases. I just always got in to the habit of doing the corruption dance :)

0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Well ... I'm compacting several times a day on any db I work on ... and probably decompile often also

This is just a WEIRD thing ... I occasionally see it on other users systems that using the apps. And it would get lost behind other windows. Soooo ... as much a HATE maximizing apps when the open, that's been one work around until I can figure what causes this.

mx
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Yes, an explicit Move command seems to always stop this behavior.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I will try that. I do have MoveSize in Open event of several apps.  I will look for a pattern.

mx
0
Mohammad Alsolaimanapplication programmerAuthor Commented:
All of your experiences are depends on the environment.
And in my case it happen when run my app at access 2007
What I did , I save the form in design mode with the size I prefer at my device access 2003 , then give it to the user 2007 and it's work
Thanks to all of you
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mohammad Alsolaimanapplication programmerAuthor Commented:
Thanks to all of you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.