473,326 Members | 2,061 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Maximised Switchboard leads to all forms being maximised...

94
I have designed a database that loads with a main switchboard in Maximised view. This is important, to fit all the relevant information onto the form.

My only problem is that when opening new forms from the switchboard using buttons or hyperlinks they will always appear maximised as well.

I have tried inserting DoCmd.Restore in the new forms which works to a point, but it not only restores the new form it also restores the switchboard (which can be seen behind the new form.)

I have inserted a DoCmd.Maximise into the Switchboard when it gains focus again but the whole process is really messy.

I'm sure there's a blindingly obvious solution to this which is making it all the more frustrating!
Mar 6 '08 #1
2 1732
Stewart Ross
2,545 Expert Mod 2GB
I have designed a database that loads with a main switchboard in Maximised view. This is important, to fit all the relevant information onto the form.

My only problem is that when opening new forms from the switchboard using buttons or hyperlinks they will always appear maximised as well.

I have tried inserting DoCmd.Restore in the new forms which works to a point, but it not only restores the new form it also restores the switchboard (which can be seen behind the new form.)

I have inserted a DoCmd.Maximise into the Switchboard when it gains focus again but the whole process is really messy.

I'm sure there's a blindingly obvious solution to this which is making it all the more frustrating!
Suggestions:
1. When you open any other form from the switchboard set the switchboard's visible property false to hide it - then users won't see the non-maximised switchboard in the background. Set its properties to visible and maximise it when you need to show it again.

2. Don't maximise the switchboard, instead size it to the maximum you need for your application, set autocenter off, set the form border to a non-sizable option, and take off the min/max/close buttons.

3. Consider redesigning your form to make it easier on your users. If the switchboard must be maximised because there is no other way to fit everything in your users may be overwhelmed by what is displayed. Could you use tabbed pages on the form instead, for instance?

I am sure there will be other suggestions, but if it were me I'd go for the redesign option...

-Stewart
Mar 6 '08 #2
Lewe22
94
My solution was to set my non maximised forms as dialogs. Not ideal, but perfectly ok for how i want things to run.

The reason i did this was because my main switchboard acts more like a 'HOME' page with various links and commands included in the form header and footer.

The detail section expands with records to fill the screen dependant on selections made by the user and everything that happens within the database from this point is dependant on the records that are displayed on this form.

I didn't want to redesign as I had found that because of the range of screen resolutions that would be using my program by designing the form maximised for 1024x768 i'm happy with the way it appears on all monitors.

Thanks for you time and assistance Stewart. Greatly appreciated.
Mar 12 '08 #3

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

Similar topics

13
by: Mark | last post by:
I am looking for a switchboard creator alternative for my MDB. Can anyone help me? Thanks for your help, Mark
2
by: Dejan M. | last post by:
Can you help me? I have 9 forms in the base. 2 forms are opening as single and 7 as datasheet. Thats OK, but when I used Switchboard manager, with him all of my forms are opened as single. How can...
7
by: aaaaaa | last post by:
Hi, I created some forms and during the wizard I chose the Datasheet View, and when I open the forms from the main objects window they open up in datasheet view. But when I created a switchboard...
2
by: Terry | last post by:
I have created a switchboard, created using Access 2000. If I put the mouse anywhere on the form, outside of the checkboxes and scroll the wheel backwards, I get the following error. Run-Time...
1
by: jimwlee | last post by:
Hi all, I mistakenly deleted my switchboard on the Object Forms view. I recreated it again with the database utility, but the switchboard isn't showing up in the forms view. Any ideas? Thanks in...
2
by: tdmailbox | last post by:
I am in the process of finishing up moderate sized access database application. I am in the process now of building a switchboard to house all the forms and reports. I decided the in built in...
8
by: Ray Greene | last post by:
I was working in Access and everything disappeared from the screen. When I closed and reopened the file there was no switchboard. I can open tables and forms etc if I select a category from the...
1
by: mplus_2000 | last post by:
I have recently inherited a database. The switchboard (and other forms) displays the name of the database on it (top, center). Currently the name that appears is Reviews. There are plans to roll...
1
geolemon
by: geolemon | last post by:
I have several forms that I've built... Most of them have some sort of VBA code built in somewhere, like: Select a record with the key-value control, and the rest of the controls position to that...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.