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