No focus on dual screen computer

[Wcs]

I am setting up a database to be used on a single computer with 2 users. A
wall will separate the 2 screens. On one screen drivers will checkin with
their ID number. On the other screen a secretary will monitor the late
checkins and possible have to get a substitute driver. My problem is that
when a driver checks in the focus will move off of the secretary's monitor
and she will not be able to type into a form until she resets the focus onto
her window. How do I keep focus on here window? The database is in Access
2007.

Thanks

 

[dymondjack]

I do not know that this is possible. One CPU can only have one active set of
input devices (e.g. mouse, keyboard). I have never heard of anyone being
able to use a single computer with this type of 'split' UI, where each
moniter can independently handle information... its still the same platform,
no matter how many moniters you have running off it.

Have you considered a separate comupter for the driver check in, and
utilizing a front and back end database? You driver's computer would barely
have to do anything other than turn on, so it need not be an expensive setup
by any means, and splitting access db's to work this this type of scenario is
very easy.

--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain

 

[David H]

You CANNOT do what you are trying to do. It is like having two people sit at
the same laptop one working in Word and the other in Excel - impossible.
Either the driver's are checking in or the secretary is using her screen.
They have to SHARE. The driver's will have to stop checkin for the Secretary
to work. The secretary will have to stop what he/she is doing for a driver to
check-ing.

To clarify some things...

Multiple monitors DO NOT EQUAL multiple computers.

Regardless of the number of monitors, you CAN have multiple Access forms
open as you can have multiple APPLICATIONS running.

If you have more than (1) Access form open, only (1) of those can be the
active form at any given time.

One (1) Application can be active at a time.

If you are running multiple instances of Access, Word or Excel (or most
other applications) on the same machine, only (1) can be the active one at
any given time.

*Unless the drivers and the secretary SHARE the time - one using the PC
while another isn't - you WILL have to have multiple computers. The good news
is that there is a runtime version of Access available that you can download
at no charge so the PC doesn't have to be state of the art.

David H.