Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ms access database container dual monitor setup

Posted on 2013-11-28
7
Medium Priority
?
1,136 Views
Last Modified: 2013-11-29
I have a ms access application on a dual monitor setup,the user has the option of  selecting which monitor the forms will be displayed on this is done by the use of a command button,I am looking for a way to switch the database container using vba to the selected monitor or any alternative method? thanks
0
Comment
Question by:Svgmassive
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 21
ID: 39683886
Curious, What version of Access and Windows?

I have a lot of user with two or more monitors.  I attempted something similar once.

Since all the multiple monitor system are running Windows 7 I train the user to use the Windows 7 Snap feature. By using the Windows Key and the arrow keys together they can easily move applications around between monitors.  In the long run the users can now get a lot more out of their dual monitors when when not using my Access application. They are a more empowered user. This allowed each users to move windows around on the monitors at will to best fit their current needs.

Boyd Trimmell, Microsoft Access MVP
0
 

Author Comment

by:Svgmassive
ID: 39683899
access 2010 windows 7 64bit. Thanks hitech.I would like to once the users click the command button to switch monitors the container will also switch to the selected monitor
0
 
LVL 26

Accepted Solution

by:
Nick67 earned 2000 total points
ID: 39684054
It can be done, but it REALLY won't be simple, especially if not all monitor setups are the same, or if you have really huge monitors.  Positioning is done by twips from the upper left corner being (0,0) to the lower right hand corner being some number dependent on the monitor sizes and numbers involved.

The gotcha is that the values you can use have an upper bound of 32K.  Three 24" 1080p monitors are large enough that they breach that boundary.  And that's all relative to the main Access window, so it gets less applicable once you leave Access 2003 and get stuck with tabs.

To move the main Access window is probably going to take Windows API code.  You'd need to find the handle of the Access app, and then move the window to a desired location.  The beginnings of wisdom are here
http://msdn.microsoft.com/en-us/library/windows/desktop/ms633545(v=vs.85).aspx
and better here:
http://support.microsoft.com/kb/210085

The code in the KB article will go nicely in an Access module--but working out all the X and Y values that will correspond to where you want the window to go on all the computers with all the varying monitors setups...

Well, that won't be fun.
It's almost like that old saw about teaching a man to fish.  In this case, teach some end users to position their own windows, and they'll be able to do it for themselves and others forever.  Try to code it up for them, and you've given yourself a long lasting headache.

And lets not talk about what pop-up and modal windows do :(
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 21
ID: 39684131
Diito what Nick67 said.

I would like to once the users click the command button to switch monitors the container will also switch to the selected monitor

I also thought that sounded like a great idea. A few gray hairs later and users think I am an idiot because I cant get it to work correctly all the time. It was starting to frustrate a lot of users since it was messing up how they like to layout their forms/apps.  It sounded like a good idea to me. Once I started watching how the users work and testing with all the different hardware and video configurations  I quickly realized that teaching them Windows 7 Snap was much more powerful that anything  I code code.  I did waste  many hours on this trying to get it to handle everything the users wanted. After teaching then Windows & Snap everybody is happier and more productive.  Making the users more productive was the original reason I started this journey.

Curious, is the something 60% or more of your users ask for or is this just to see if you can?
0
 

Author Closing Comment

by:Svgmassive
ID: 39684295
excellent
0
 
LVL 26

Expert Comment

by:Nick67
ID: 39685846
0
 
LVL 21
ID: 39686145
Svgmassive,

Would you mind updating us on how it goes?

Good luck with your project.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question