473,608 Members | 2,077 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Switchboard form

Hey all,

Thi question may be simple to most people on this group, but I'm a
newbie and can't figure this out. I have created a switchboard form and
I've been able to display it on startup of Access. However, I can't get
it to start up Maximized. I tried to look through the Form's
properties, yet no luck. Any help would be appreciated.

Thanks!

Jan 19 '07 #1
3 3178
Haas:

In the On Open event of the Form (found in the properties of the form
on the Event tab) put your cursor in the box and click the [...] button
to the right of the On Open box. Choose Code Builder. It will take
you to the Class Module for your form and pop your cursor right where
you need it.

Put this line in:
DoCmd.Maximize

Then click on Debug, then Compile Loaded Modules. Close the Class
Module, save your form and then reopen it. It should open up
maximized.

HTH,
Jana

Haas C wrote:
Hey all,

Thi question may be simple to most people on this group, but I'm a
newbie and can't figure this out. I have created a switchboard form and
I've been able to display it on startup of Access. However, I can't get
it to start up Maximized. I tried to look through the Form's
properties, yet no luck. Any help would be appreciated.

Thanks!
Jan 19 '07 #2
On 19 Jan 2007 10:22:52 -0800, Haas C wrote:
Hey all,

Thi question may be simple to most people on this group, but I'm a
newbie and can't figure this out. I have created a switchboard form and
I've been able to display it on startup of Access. However, I can't get
it to start up Maximized. I tried to look through the Form's
properties, yet no luck. Any help would be appreciated.

Thanks!
There is no maximize property.
You have to code the Switchboard form's Open event.
Here's how.

Display the switchboard's property sheet.
Click on the Event tab.
On the Open event line, write:
[Event Procedure]
Then click on the little button with the 3 dots that appears on that
line.
When the code window opens, the cursor will be flashing between 2
already existing lines of code.
Between those 2 lines, write:

DoCmd.Maximize

Close the code window.
Open the Switchboard.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Jan 19 '07 #3
Thank you all for the very helpful advice!

Haas

On Jan 19, 1:58 pm, fredg <fgutk...@examp le.invalidwrote :
On 19 Jan 2007 10:22:52 -0800, Haas C wrote:
Hey all,
Thi question may be simple to most people on this group, but I'm a
newbie and can't figure this out. I have created a switchboard form and
I've been able to display it on startup of Access. However, I can't get
it to start up Maximized. I tried to look through the Form's
properties, yet no luck. Any help would be appreciated.
Thanks!There is no maximize property.
You have to code the Switchboard form's Open event.
Here's how.

Display the switchboard's property sheet.
Click on the Event tab.
On the Open event line, write:
[Event Procedure]
Then click on the little button with the 3 dots that appears on that
line.
When the code window opens, the cursor will be flashing between 2
already existing lines of code.
Between those 2 lines, write:

DoCmd.Maximize

Close the code window.
Open the Switchboard.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Jan 24 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
5820
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
6578
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 I solve this problem. Thanks!
7
5956
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 which opens the same form it doesnt load them in datasheet, it loads them in other, columnar (me thinks), view. Is there a way to make the switchboard load these forms in a simple datasheet view
2
2157
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 Error '-2147217900(8004e14)': Syntax Error (missing operator) in query expression in '>0 and =' I know that the Switchboard probably doesn't cater for this event but sometimes you can't help twiddling the wheel can you?
4
4124
by: Rampar | last post by:
I did some customizing on my switchboard (changing colors and adding graphics) to make it more appealing. I tried to add another item, and it told me that 8 was the limit. Fine. I deleted one item so that I could add another switchboard. I have done this several times in the past, but it will not open the new switchboard. The button just goes in and out and that is it. So, I decided to create a new switchboard and scrap the old one...
5
2211
by: Michael Keene | last post by:
I have a query that I'd like to add to my switchboard, but when I use the switchboard manager I only get the option to run a report, a macro or open a form. Is there a way to add a query without making it a macro?
2
3367
by: Neil Greenough | last post by:
I am trying to create a Switchboard using the Switchboard Manager in MS Access 2000. I have managed to get the table created for the switchboard, however it hasn't actually created the form. Hopefully I will have a main switchboard which will in turn lead to three sub switchboards. Can anybody tell me how to get the form automatically created from the Switchboard Table if at all possible?
1
4513
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 advance. Jim Lee
4
9571
by: ghadley_00 | last post by:
Hi, Can anyone recommend a piece of VBA code I could attach to a button in a MS Form form that will close the current form and bring the switchboard to foreground. I'm trying to integrate a form of buttons into the way the switchboard gets used. Best wishes, George Hadley
1
2676
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 out the application (i.e. making copies of the database) to other locations (Reviews-NY, Review-Dallas etc). If was mentioned today in passing by the original developer that there is a way to change the title that appears on the switchboard without...
0
8498
Oralloy
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...
0
8478
jinu1996
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...
0
8341
tracyyun
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...
0
6817
agi2029
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...
1
6014
isladogs
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...
0
5476
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4025
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1598
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1331
bsmnconsultancy
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.