Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-09-2019, 01:58 PM   #1
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 145
Thanks: 75
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
View in Windows vs Tabs

Is it possible to view a form, query, report, etc. in a separate window vs a tab while working on it?

The reason i'm asking is I would like to be able to see the columns of one table while building my query in a separate window.

NearImpossible is offline   Reply With Quote
Old 12-09-2019, 01:59 PM   #2
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,280
Thanks: 63
Thanked 1,683 Times in 1,638 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: View in Windows vs Tabs

Hi. Have you tried going to File > Options > Current Database > Document Window Options > Overlapping Windows?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 12-09-2019, 02:07 PM   #3
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 145
Thanks: 75
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
Re: View in Windows vs Tabs

Quote:
Originally Posted by theDBguy View Post
Hi. Have you tried going to File > Options > Current Database > Document Window Options > Overlapping Windows?
That does work, however it also affects the layout of the database while in use, is there anyway to have it act like that only while in design mode so I could have each open in its own window, but if I change it to Form View, its the normal tabs/pop-ups as specified by the forms??

NearImpossible is offline   Reply With Quote
Old 12-09-2019, 02:08 PM   #4
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,280
Thanks: 63
Thanked 1,683 Times in 1,638 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: View in Windows vs Tabs

Quote:
Originally Posted by NearImpossible View Post
That does work, however it also affects the layout of the database while in use, is there anyway to have it act like that only while in design mode so I could have each open in its own window, but if I change it to Form View, its the normal tabs/pop-ups as specified by the forms??
Depends on what you mean. You can switch it back and forth or just maximize the form when you try it out.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 12-09-2019, 05:56 PM   #5
vba_php
Banned
 
Join Date: Oct 2019
Location: Iowa City, IA, USA
Posts: 1,307
Thanks: 127
Thanked 313 Times in 300 Posts
vba_php is an unknown quantity at this point
Re: View in Windows vs Tabs

Quote:
Originally Posted by NearImpossible View Post
it also affects the layout of the database while in use
it affects the layout of the database? I don't think that's what you mean. guy told you to switch it to overlapping windows. if you did indeed do that, working on objects doesn't moving anything else in the database window
Quote:
Originally Posted by NearImpossible View Post
is there anyway to have it act like that only while in design mode so I could have each open in its own window, but if I change it to Form View, its the normal tabs/pop-ups as specified by the forms??
NO.
vba_php is offline   Reply With Quote
Old 12-09-2019, 06:12 PM   #6
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,518
Thanks: 12
Thanked 292 Times in 275 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: View in Windows vs Tabs

If you're using Tab view for forms and want to make a particular form not open in tab view, set it's popup property to yes. Same thing for reports. I don't think there is any such option for queries, which you probably shouldn't be allowing users to interact with anyway.
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 12-09-2019, 11:36 PM   #7
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,390
Thanks: 15
Thanked 1,623 Times in 1,541 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: View in Windows vs Tabs

It is not possible to switch between tab and window view on the fly. You have to change the setting and then close and open the database.

If MS had made the switch dynamic, I might use tab view for the users but for development, it is too cumbersome. I always want to be able to look at multiple queries or tables or forms as I am testing.

Personally, I don't like tab view so I never use it. I think having multiple forms open confuses users so with rare exceptions, I don't allow it. If formA opens formB, it hides itelf and then when formB closes, it opens formA. In the rare cases where I do want both forms visible, the second form is opened as a dialog so although you can see the original form, you can't interact with it.


__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Colored Background For Windows View in A2016 Frothingslosh Code Repository 3 11-01-2018 01:02 PM
Configure Windows 7 Theme for XenApp Access Tabs don't highlight Rx_ Access Web 0 07-10-2014 02:36 PM
tabs on form not showing in form view in access 2007 pmathobela Forms 10 08-16-2011 05:25 PM
Cannot view chart in a form with Windows Vista jcsuarez Forms 0 01-09-2010 11:43 AM
Tabs Disappear in Form View canadaboy Forms 4 04-08-2003 10:44 AM




All times are GMT -8. The time now is 10:04 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World