Very strange Database Window / Startup Form problem

[Gerbers404]

Hello all,

The problem I'm about to describe has now happened to me twice within the last month & 1/2. I'm hoping since it has happened twice to met, that it has also happend to someone in this forum who might be able to help me or explain what's happening...

I was working with a form in design mode today, and whatever I did, I believe I was closing it at the time, caused my Database Window to disappear. This is not entirely true. My startup form was somehow moved to the very bottom of the available "workspace" in Access. All I could see was the startup form, and there was a verticle scroll bar that appeared to the right with the slider at the very bottom.

In order for me to get back to where I could see the database window, I had to do something so amazingly primitive that I'm shocked it worked. First, I closed the startup form. Then, I weighted the left mouse button and hovered the mouse over the area above the slider on the scroll bar, and then I went to lunch. When I returned from lunch, the slider was just over halfway up the screen, so I left the machine alone for another 45 minutes or so. Finally the slider returned almost all the way to the top of the screen and after I clicked on the up arrow of the scroll bar a couple of times, the database window appeared and the scroll bar disappeared. I opened the startup form and it came up right where it normally does, in the center of the workspace, just above the DB window. All seems to be OK now.

This had happened to me about a month or two ago with a different db. With that one, I ended up just deleteing the DB because it was a small test db that I was developing and hadn't really gotten that far into.

Like I say, I have no idea what caused this to happen, I can't even be sure of what I was doing at the exact time that the error occured. Any input would be greatly appreciated.

Thanks!





Gerbers404

 

[1JohnnyV]

I, also would like to know what causes this. I use Access 97 at work and this happens constantly to me, though not as bad as what you describe. My main database window goes to the extreme lower left of the work area and I have to use the scroll bars to get to the main window, but my main window appears, and is so small that I must resize the window to see the objects in the database.

IMHO I believe that this may be a service pack issue, but I might be all wet on that.

"The only stupid question is the one not asked"

Later
1JohnnyV

 

[RickSpr]

I can't say I know what causes it, and I don't think it's actually happened to me, but there's a much easier way to recover from it: Window>Cascade on the menu bar.

What's happening is that the windows containing the forms or database window are being moved to random coordinates in the application workspace, somehow.

One possibility is that you're using API functions and passing arguments wrong, such as passing by reference when by value is expected, or vice versa. Or you might be passing a string variable when a fixed-length string is needed for a buffer.

Another possibility is you're setting Left and Top properties incorrectly.

I've also seen something like this happen when forms are opened maximized initially, before ever being opened with the "restored" size. It's as if the non-maximized position and size never got initialized properly. When you close the maximized form, it's automatically restored before it's closed.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[boxboxbox]

I've had this problem, and while it doesn't fix it, it does make the form reopen properly in the right spot...

I change the autocenter property on the form (since the property sheet is visible) to whatever it is not (sometimes Yes, sometimes No).