By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,600 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,600 IT Pros & Developers. It's quick & easy.

Minimized Database window moving way off screen

P: n/a
I have a database on a server that many people access repeatedly during
the day. I have set up the switchboard form with code to minimize the
database window, but when I try to open the database window it opens
off screen so far that I have to close the switchboard and go find the
database window, open it and reopen the switchboard form. Is there any
possibility of fixing the position of the moinimized database window
relative to the switchboard form or the window size to prevent it doing
this?

Dec 29 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Zammy wrote:
I have a database on a server that many people access repeatedly during
the day. I have set up the switchboard form with code to minimize the
database window, but when I try to open the database window it opens
off screen so far that I have to close the switchboard and go find the
database window, open it and reopen the switchboard form. Is there any
possibility of fixing the position of the moinimized database window
relative to the switchboard form or the window size to prevent it doing
this?


HI

There's two parts to my response on this, the first is not a question
you asked, but it's something I think needs to be pointed out.

You should never have the actual application mdb shared by multiple
people. For mult-user purposes, it's best practice to split the mdb
into two parts. One part is the "back end", which resides on a server,
and contains the data tables. The second part is the application
usually referred to as the "front end". Instead of tables in the tables
tab of the front end database window, there are links to the back end
mdb. Now comes the key to successful deployment - the front end should
be a separate copy on the individual users' own machine.

Having an mdb with forms and code shared on a server is often a primary
cause of corruption. Lately, there's been one or two individuals on
this group who have claimed they never split their applications and are
fine, but the prevailing wisdom is to split your application as I said.

Now, onto your actual question.

With your shared mdb, what is happening is someone with a screen
resolution much larger than yours is opening the database window and
pushing it to one side.

First of all, with a spilt design, you won't have this problem. In any
event, open your mdb while holding down the shift key. This will bypass
any autoexec macro that opens your switchboard and/or any form specified
as an opening form and will open the database window in the Access
window by itself.

HTH, if you have any more q about splitting databases, there's lots of
folks who will help you here.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Dec 29 '05 #2

P: n/a
Tim, thank you for your reply on this. I couldn't imagine what could be
causing the Database window to be relegated to far-off regions of the
screen. I ran all sorts of things through my mind, trying to figure out
how to cause the Database window to move to a specified point, but I
never even considered the possibility of another user's screen
resolution affecting the way different users' windows are laid out.

Dec 29 '05 #3

P: n/a
Thank you Tim. I do have questions about splitting the database and I
will try to glean more knowledge from this forum.

Dec 30 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.