473,320 Members | 2,162 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Minimized Database window moving way off screen

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
3 3247
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

40
by: Brian Jorgenson | last post by:
On my web page, I have a few hyperlinks with target frame of _blank. The hyperlink brings up a second window, but everytime I click on thie hperlink, it keeps bringing up a new window and not...
17
by: Applebrownbetty | last post by:
Hi, I'd like to append/amend the following code from the Dreamweaver extension "Open Picture Window Fever" for the ability to center the PopUp window: By default, it allows the window to be...
6
by: David Hayes | last post by:
juglesh <juglesh@nospamRadioKDUG.com> wrote in "Re: how to maximize the browser window that fits the monitor size?" (Saturday, January 01, 2005 3:12 AM): > > >I want to maximize the browser...
5
by: Nicolae Fieraru | last post by:
Hi All, I use a simple function on a web site, based on this function: function goVisitSite(Site) { NewWindow1 = window.open(Site, "viewwin",...
7
by: Colleyville Alan | last post by:
I have an app that uses Access to grab various PowerPoint slides using the followhyperlink command. I have set the PPT window to run in a minimized state: FollowHyperlink link Set oPres =...
2
by: Carsten Klotz | last post by:
Hi, does someone know, if it's possible capturing the content of a panel, when its form has state "minimized"? Details: A panel contains a Webbrowser object (AxSHDocVw.AxWebBrowser). My...
4
by: MrMike | last post by:
Hi. I have a hyperlink control (lnkViewLogData) which is assigned the following attribute when the page loads... Me.lnkViewLogData.Attributes.Add("onClick", _ ...
2
by: Dave Booker | last post by:
I have a Windows form application that I generally run minimized. When a critical event occurs it instantiates another "Alert" form which I want to grab the user focus. In the Alert constructor...
6
by: pamela fluente | last post by:
Hello friends, I have a simple question. If I have an application with several forms, you see on the windows bar, usually on the bottom of your screen, the various tags for the various forms. ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.