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! 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!
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
|
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!
|
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
|
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?
|
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...
| |
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?
|
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?
|
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
|
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
|
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...
|
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: 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: 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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |