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

Viewing Two Tables, Two Queries, etc. On A Dual Monitor

P: n/a
I just received a 2nd (configured as a dual) monitor but, for Access
only, I can't seem to figure out, if it's possible, to view, say,
Table1 on one monitor and Table2 on the other monitor. If I open
Table1, then Table2, Table2 apparently sits directly over Table1 and
seems anchored so that I cannot move it "out of the way". Is this
bahavior a restriction with Access as I do not have this problem with
Excel or Word?
Sheldon Potolsky

Apr 12 '07 #1
Share this Question
Share on Google+
8 Replies


P: n/a
For any significant interface in Access, you use a form.

Create a form (in Datasheet view if you wish.)
Set its Popup property to Yes.
You can move it onto the other monitor.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sheldon" <SH********@aol.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
>I just received a 2nd (configured as a dual) monitor but, for Access
only, I can't seem to figure out, if it's possible, to view, say,
Table1 on one monitor and Table2 on the other monitor. If I open
Table1, then Table2, Table2 apparently sits directly over Table1 and
seems anchored so that I cannot move it "out of the way". Is this
bahavior a restriction with Access as I do not have this problem with
Excel or Word?
Sheldon Potolsky
Apr 13 '07 #2

P: n/a
Thank you Allen. Though I was able to create and move a form to the
other window by following your instructions, that did not help me with
what I wanted to achieve - moving a query or table to the 2nd screen
so I could compare two queries or two tables (one per screen) without
having to do a lot of resizing in the one screen. Can that be done
and, if not, would you know why not since it does work in Word and
Excel.
Sheldon Potolsky

On Apr 12, 10:30 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid>
wrote:
For any significant interface in Access, you use a form.

Create a form (in Datasheet view if you wish.)
Set its Popup property to Yes.
You can move it onto the other monitor.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sheldon" <SHPsalm...@aol.comwrote in message

news:11**********************@q75g2000hsh.googlegr oups.com...
I just received a 2nd (configured as a dual) monitor but, for Access
only, I can't seem to figure out, if it's possible, to view, say,
Table1 on one monitor and Table2 on the other monitor. If I open
Table1, then Table2, Table2 apparently sits directly over Table1 and
seems anchored so that I cannot move it "out of the way". Is this
bahavior a restriction with Access as I do not have this problem with
Excel or Word?
Sheldon Potolsky- Hide quoted text -

- Show quoted text -

Apr 16 '07 #3

P: n/a
Access is different from Excel/Word.

Access has the main window, and child windows within it. You can open
multiple copies of Access, and place them on different screens as you wish.
You can open multiple child windows *within* the Access window. You can also
open Popup Windows outside the Access window.

The driver for some graphics cards allows you to span multiple monitors. So
you may be able to open the Access window (not maximized), and span it
acrosss multiple monitors, and then place one of the tables/queries on the
other monitor, since the Access windows has been stretched onto both.

What you cannot do is open a child window within Access and move it outside
the main Access window. When you open a table or query directly (i.e. not a
form or report based on that table/query), you are opening a child window,
so you cannot move it outside.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sheldon" <SH********@aol.comwrote in message
news:11*********************@p77g2000hsh.googlegro ups.com...
Thank you Allen. Though I was able to create and move a form to the
other window by following your instructions, that did not help me with
what I wanted to achieve - moving a query or table to the 2nd screen
so I could compare two queries or two tables (one per screen) without
having to do a lot of resizing in the one screen. Can that be done
and, if not, would you know why not since it does work in Word and
Excel.
Sheldon Potolsky

On Apr 12, 10:30 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid>
wrote:
>For any significant interface in Access, you use a form.

Create a form (in Datasheet view if you wish.)
Set its Popup property to Yes.
You can move it onto the other monitor.

"Sheldon" <SHPsalm...@aol.comwrote in message

news:11**********************@q75g2000hsh.googleg roups.com...
>I just received a 2nd (configured as a dual) monitor but, for Access
only, I can't seem to figure out, if it's possible, to view, say,
Table1 on one monitor and Table2 on the other monitor. If I open
Table1, then Table2, Table2 apparently sits directly over Table1 and
seems anchored so that I cannot move it "out of the way". Is this
bahavior a restriction with Access as I do not have this problem with
Excel or Word?
Sheldon Potolsky- Hide quoted text -

- Show quoted text -
Apr 16 '07 #4

P: n/a
Thanks for the explanation Allen although I *wish* Access behaved
liked Word/Excel in this regard.

I did try opening multiple instances of the same database (in Access
2000) but the second instance never opens so I am not able to compare
queries/tables using the dual monitors. Is there a setting that would
allow me to open multiple instances of the same db? I recall being
able to do this in A97.
Thanks, Sheldon Potolsky
Access is different from Excel/Word.

Access has the main window, and child windows within it. You can open
multiple copies of Access, and place them on different screens as you wish.
You can open multiple child windows *within* the Access window. You can also
open Popup Windows outside the Access window.

The driver for some graphics cards allows you to span multiple monitors. So
you may be able to open the Access window (not maximized), and span it
acrosss multiple monitors, and then place one of the tables/queries on the
other monitor, since the Access windows has been stretched onto both.

What you cannot do is open a child window within Access and move it outside
the main Access window. When you open a table or query directly (i.e. not a
form or report based on that table/query), you are opening a child window,
so you cannot move it outside.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


Apr 18 '07 #5

P: n/a
Sheldon wrote:
Thanks for the explanation Allen although I *wish* Access behaved
liked Word/Excel in this regard.

I did try opening multiple instances of the same database (in Access
2000) but the second instance never opens so I am not able to compare
queries/tables using the dual monitors. Is there a setting that would
allow me to open multiple instances of the same db? I recall being
able to do this in A97.
Thanks, Sheldon Potolsky
Only if you don't open exclusively in which case you wouldn't be able to
make design changes.

Just stretch the Access window over both monitors.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Apr 18 '07 #6

P: n/a
Just stretch the Access window over both monitors.
Thanks Rick! I didn't realize that stretching the Access window over
both monitors would work.
Only if you don't open exclusively in which case you wouldn't be able to make design changes
I checked my settings (Tools/Options/Advanced Tab) and the default
open mode was set to shared but nothing happens when I try opening a
second instance of the same database.

Sheldon Potolskt

On Apr 18, 9:14 am, "Rick Brandt" <rickbran...@hotmail.comwrote:
Sheldon wrote:
Thanks for the explanation Allen although I *wish* Access behaved
liked Word/Excel in this regard.
I did try opening multiple instances of the same database (in Access
2000) but the second instance never opens so I am not able to compare
queries/tables using the dual monitors. Is there a setting that would
allow me to open multiple instances of the same db? I recall being
able to do this in A97.
Thanks, Sheldon Potolsky

Only if you don't open exclusively in which case you wouldn't be able to
make design changes.

Just stretch the Access window over both monitors.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Apr 18 '07 #7

P: n/a
Sheldon wrote:
Just stretch the Access window over both monitors.
Thanks Rick! I didn't realize that stretching the Access window over
both monitors would work.
Only if you don't open exclusively in which case you wouldn't be
able to make design changes
I checked my settings (Tools/Options/Advanced Tab) and the default
open mode was set to shared but nothing happens when I try opening a
second instance of the same database.
I believe if you double-click the file or a shortcut to the file and it is
already opened then nothing happens. However if you open a new Access instance
window first and then open the file from within that should work. Also if you
double-click a shortcut that points to Access with the file to open as an
argument it should also open multiple windows.

But, as stated with two or more instances of the same file open at once you
won't be able to make design changes so its usefullness is limited.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Apr 18 '07 #8

P: n/a
Thanks Rick. Your suggestions were a real help to me and another
person at work that also needed to use his second monitor for Access
databases. Another example of the value of forums!
Sheldon Potolsky

On Apr 18, 6:45 pm, "Rick Brandt" <rickbran...@hotmail.comwrote:
Sheldon wrote:
Just stretch the Access window over both monitors.
Thanks Rick! I didn't realize that stretching the Access window over
both monitors would work.
Only if you don't open exclusively in which case you wouldn't be
able to make design changes
I checked my settings (Tools/Options/Advanced Tab) and the default
open mode was set to shared but nothing happens when I try opening a
second instance of the same database.

I believe if you double-click the file or a shortcut to the file and it is
already opened then nothing happens. However if you open a new Access instance
window first and then open the file from within that should work. Also if you
double-click a shortcut that points to Access with the file to open as an
argument it should also open multiple windows.

But, as stated with two or more instances of the same file open at once you
won't be able to make design changes so its usefullness is limited.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Apr 19 '07 #9

This discussion thread is closed

Replies have been disabled for this discussion.