473,836 Members | 1,523 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How can I center Access 2007 switchboard opened to full screen?

26 New Member
I am creating a database in Access 2007 for multiple users, some with very limited experience with access. I am using a customized switchboard to make it more user-friendly.

I have the switchboard opening to full screen (covers all of the access window) and it is centered on my laptop but when I open the database on a different computer, different monitor size and resolution, it is not centered.

Is there anyway to have the switchboard centered, no matter the monitor size/resolution when opening to full screen?
Oct 6 '11
28 11947
8,834 Recognized Expert Expert
Post #11 says it all from what I can see. It is not a matter of the Form itself being 'Centered' since this makes little sense in its 'Maximized' State. It appears to be a problem of centering the 'Controls' within this Form for various Screen Resolutions. A Command Button on a Maximized Form that is Centered on the Screen, will no longer be once the Resolution is changed. Technically the Controls on the Form need to be Scaled as well as Repositioned which can be done, but will be a little complex.

@JAGster: Is this correct?
Oct 7 '11 #11
32,584 Recognized Expert Moderator MVP
Post #11 says it all from what I can see.
Post #11 is the one you just posted ADezii :-S

I couldn't find any post that even seemed to indicate that, but if that's true, we have a much clearer question to answer. We'd need details of these controls of course and how they fit on the form generally. With that the situation is certainly handlable. I'm sure either of us could help with that.
Oct 7 '11 #12
8,834 Recognized Expert Expert
@NeoPa: Make that Post #8! (LOL)
Oct 7 '11 #13
26 New Member
ADezii, You are correct, I misstated what I really needed to know how to do. Scaling and repositioning the controls for any resolution is what I need to do.

The controls are command buttons that are opening sub-switchboards. The sub-switchboard forms have command buttons to return to the main switchboard, close and exit the database, import files to populate tables, open split-forms with subforms, etc. I've attached a copy of the database with sensitive data removed.

I am in the process of changing the look and feel of the sub-switchboard forms and the other forms to be more like the main switchboard. My end goal is to either have all forms open full-screen with the controls scaled and repositioned or to have just the main switchboard and sub-switchboards open full screen with the controls scaled and repositioned and the other forms open centered on screen no matter the resolution (if they can open in front of the sub-switchboard form that is open full screen). I want the access window always hidden no matter what form(s) are open.
Attached Files
File Type: zip Inventory Part Validation - Sample.zip (74.7 KB, 234 views)
Oct 8 '11 #14
8,834 Recognized Expert Expert
Unfortunately, I can only use Access 2002 at this time. Kindly Convert a Copy of the DB (Forms only) to Access 2002, so that I can have a really good look at the Forms and Controls contained within.
Oct 8 '11 #15
32,584 Recognized Expert Moderator MVP
I just found out that maximised form windows keep the same values for height and width as when in restored view. I'm just seeing if I can find out how to determine the actual values for the form window. I know it will involve a Windows API call, I just don't know which yet ;-)
Oct 8 '11 #16
32,584 Recognized Expert Moderator MVP
It seems like you will need some code in your Form_Open() event I would suggest. It needs to determine the size of the form and its sections. The form object (Switchboard) has a Width property but only the sections have Height properties. This is worth remembering even though we won't be using these values due to their being unfit for purpose (See post #16). They remind us of the structure though. If you have multiple sections you will need to handle this in your logic. How you move things around within that, and what logic you use, is up to you (and we can't really comment as you haven't shared that with us), but you will almost certainly want to cycle through your controls to process each one. Here is a stub of code you can work with (I assume just a Detail section) :

Expand|Select|Wrap|Line Numbers
  1. Option Compare Database
  2. Option Explicit
  4. Private Declare Function GetWindowRect Lib "user32" _
  5.                              (ByVal hWnd As Long, recWnd As Rect) As Long
  6. Private Type Rect
  7.     Left As Long
  8.     Top As Long
  9.     Right As Long
  10.     Bottom As Long
  11. End Type
  13. Private Sub Form_Open()
  14.     Dim lngWidth As Long, lngHeight As Long
  15.     Dim recForm As Rect
  16.     Dim ctl As Control
  18.     Call GetWindowRect(Me.hWnd, recForm)
  19.     With recForm
  20.         lngWidth = .Right - .Left
  21.         lngHeight = .Bottom - .Top
  22.     End With
  23.     For Each ctl In Me.Detail.Controls
  24.         '...  Your logic
  25.     Next ctl
  26. End Sub
Oct 8 '11 #17
26 New Member
NeoPa, All functioning controls (the Quarterly Audit button has no logic/function currently assigned to it) have an On Click event that calls a macro. All macros were included in the attached macro. Except for the macro triggered by the Exit "button" all other macros close the main switchboard and open another form. The macro for the Exit button saves and closes the database.

ADezii, I have attached a 2002 version of the sample database.
Attached Files
File Type: zip Inventory Part Validation - Sample 2002.zip (62.6 KB, 187 views)
Oct 10 '11 #18
12,516 Recognized Expert Moderator MVP
Use a subform as a container and then center the subform in the form's on load event.
Oct 10 '11 #19
26 New Member
Rabbit, What settings/code is needed for the subform to be centered on the form no matter the screen resolution?

As a brief recap of what I'm trying to accomplish - I want to open a switchboard to full screen size, not maximized in the Access window, but full screen so none of the access toolbars, buttons, etc are visible. And have the controls on the switchboard centered no matter what computer/monitor or monitor resolution on which the database is running.
Oct 10 '11 #20

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Wayne | last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom menu bar designer. Is it in the beta? Maybe I'm blind. The question that comes to mind is: Will custom menu bars be the same height as they were in previous versions or will they be the "ribbon" style that takes up a huge portion of the screen? Also when I use Access 2007 to open an Access 2003 database that has custom menu bars they display as they did in Access...
by: Wayne | last post by:
I've been having a click around Access 2007 this afternoon and have discovered some things that range from annoying to alarming. My Access 2003 menu bars, which I, like many others, use extensively, are now hidden behind an "Add Ins" tab on the Ribbon. Hardly an intuitive place for a user to find them. Unless my memory is failing me, I'm sure that Access 2003 menus displayed normally in the 2007 Beta. The other thing I've discovered...
by: Neil | last post by:
Just found out that the Microsoft Rich Textbox does not support full text justification, since it's based on Version 1.0 of the RichEdit Window Class, and full text justification is only available in versions 3.0 or later of the class. However, also just found out that the new Rich Text property in Access 2007 ALSO does not support full text justification! This seems incredible, that MS would create a brand new application, and not...
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might know one way or the other whether that was true or not, or could point me to an article or help text that would. What I have seen so far online and in Access 2007 help seems to confirm the above. But that (or at least (b)) seems incredible that it...
by: Rocky | last post by:
My Access 2007 file fails to open on a machine with the 2007 Access runtime version installed. It comes up with a Security alert message. Is there a security setting in the Access Database that needs to be enabled to run the code and macros?
by: martin DH | last post by:
A user of a database received this error when attempting to open the database on a new computer. The Access database was built in Access 2003 and is being opened in Access 2007. The database is set to open a switchboard on startup. "The expression on Open you entered as the event property setting produced the following error: Object or class does not support the set of events." It's opened on at least one new computer with Access 2007...
by: newwin | last post by:
How i create a popup menu on switchboard form, like on switchboard form, when user clicks the button a popup menu is displayed then user can selects one of them using access 2007. Please tell me, the steps.
by: prakashwadhwani | last post by:
Hi !! I'm about to develop a new project for a client. Should I go about it in Access 2003 or 2007 ? Purchasing it either for me or for my client is not a major consideration here ... what I'd like to know is the stability, speed & ease of use of both the products. I believe Access 2007 has a new file format too and that it may be slower.
by: ARC | last post by:
I think I made a major blunder, and now Access 2007 no longer opens. I made the mistake yesterday of using the "test" option in wise installer for my Access 2007 runtime app. It actually installed the Access 2007 Runtime SP-1 (I did have full office 2007 SP-1, however). I didn't notice a problem until I had to use Access 97. Once I re-opened Access 2007, I got the usual message about the Installer (as it tries to repair every time you...
by: Robert S. | last post by:
Searching some time now for documents on this but still did not find anything about it: Is it possible to replace the entry screen of MS Office Access 2007 - that one presenting that default 'templates' (with that big graphic buttons) - with some sort of own HTML-Page? I could imagine, that somehow it is possible to change this construction (hopefully not hardcoded in MS-Acc07), like it is possible to edit the 'Fluent Ribbon'? If so...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.