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 View > Database Objects menu, and
use the up/down keys and the Enter key, but I can't see what it is I am about
to open.
I was able to replicate this with another database by moving the switchboard
up past the top of the screen and scrolling up to it. It disappeared and I
can't get it back.
The main Access window scrollbar is scrolled a long way down and it won't
scroll back up.
Does anyone know what causes this weirdness, and how I can get the
switchboard back?
--
Ray Greene.
8  5620 
I've had similar things happen when I changed the display resolution I was
using -- objects that had been moved far from their start point were not
visible. The only easy way I found to correct it was to switch back to the
higher resolution and move everything back to where it began.
It was/is not just an Access problem -- happens with any software that saves
the last-used position of screen objects.
Larry Linson
Microsoft Access MVP
"Ray Greene" <ra***@es.co.nz > wrote in message
news:Ih******** **********@news .xtra.co.nz... 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 View > Database Objects menu,
and use the up/down keys and the Enter key, but I can't see what it is I am
about to open.
I was able to replicate this with another database by moving the
switchboard up past the top of the screen and scrolling up to it. It disappeared and I
can't get it back.
The main Access window scrollbar is scrolled a long way down and it won't
scroll back up.
Does anyone know what causes this weirdness, and how I can get the
switchboard back?
--
Ray Greene.
I've had that problem with other applications too, but I think this case is
different. Being inside the main window the switchboard should be available
by scrolling to it, but the scrollbar doesn't work properly. I suspect that
the switchboard has an illegal value in its coordinates.
Is there a way to access the switchboard through VBA? I might be able to
bring it back that way.
--
Ray Greene.
On Sun, 24 Apr 2005 01:29:30 GMT, "Larry Linson" <bo*****@localh ost.not>
wrote: I've had similar things happen when I changed the display resolution I was
using -- objects that had been moved far from their start point were not
visible. The only easy way I found to correct it was to switch back to the
higher resolution and move everything back to where it began.
It was/is not just an Access problem -- happens with any software that saves
the last-used position of screen objects.
Larry Linson
Microsoft Access MVP
"Ray Greene" <ra***@es.co.nz > wrote in message
news:Ih******* ***********@new s.xtra.co.nz... 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 View > Database Objects menu,
and use the up/down keys and the Enter key, but I can't see what it is I am
about to open.
I was able to replicate this with another database by moving the
switchboard up past the top of the screen and scrolling up to it. It disappeared and I
can't get it back.
The main Access window scrollbar is scrolled a long way down and it won't
scroll back up.
Does anyone know what causes this weirdness, and how I can get the
switchboard back?
--
Ray Greene.
Ray Greene <ra***@es.co.nz > wrote in
news:Ih******** **********@news .xtra.co.nz: 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 View > Database Objects menu, and use the
up/down keys and the Enter key, but I can't see what it is I am
about to open.
I was able to replicate this with another database by moving the
switchboard up past the top of the screen and scrolling up to it.
It disappeared and I can't get it back.
The main Access window scrollbar is scrolled a long way down and
it won't scroll back up.
Does anyone know what causes this weirdness, and how I can get the
switchboard back?
I've seen this happen, but always with working horizontal and
vertical scrollbars, so it was always recoverable. The solution was
the tedious task of scrolling over to where the thing was located,
dragging it one Access window left, scrolling one screen left,
dragging the window left, and so forth, until the horizontal
scrollbar disappeared entirely. Then repeat the process for the
vertical scrollbar.
Then close the MDB and then close Access, restart Access and open
the MDB and it should be in the right position.
However, now that I look at what you're saying, you are not talking
about the database window but the Switchboard form. I'd check its
properties to see if it's set to auto-center, or if there's some
code somewhere in the app that is positioning it onscreen somewhere
other than the center of the Access window.
If the problem persists, I think I'd go through a decompile/compact
cycle, and if that has no effect, import everything into a fresh MDB
and see if that fixes the issue.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
I presume you are talking about the Switchboard generated by the Switchboard
Manager. I do not use the Switchboard Manager because I view it as a complex
solution to a simple problem. Instead, I create my own unbound Forms for use
as switchboard. Thus, I am not a good source for information about
Switchboard Manager Switchboards.
However, in the experimentation I did with Switchboard Manager (from which I
came to the conclusion above), I didn't experience anything similar to what
you describe. Perhaps someone else, with more Switchboard Manager
background, can step in and assist in pursuing an answer.
Larry Linson
Microsoft Access MVP
See if this sorts you out
Paste the following in the debug window and execute it (it presumes that the
switchboard is the only form open).
docmd.SelectObj ect acform, forms(0).Name,f alse: docmd.MoveSize 0, 0,
forms(0).Width, forms(0).Inside Height
--
Terry Kreft
MVP Microsoft Access
"Ray Greene" <ra***@es.co.nz > wrote in message
news:Ih******** **********@news .xtra.co.nz... 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 View > Database Objects menu,
and use the up/down keys and the Enter key, but I can't see what it is I am
about to open.
I was able to replicate this with another database by moving the
switchboard up past the top of the screen and scrolling up to it. It disappeared and I
can't get it back.
The main Access window scrollbar is scrolled a long way down and it won't
scroll back up.
Does anyone know what causes this weirdness, and how I can get the
switchboard back?
--
Ray Greene.
On Mon, 25 Apr 2005 17:34:38 +0100, "Terry Kreft" <te*********@mp s.co.uk>
wrote: docmd.SelectOb ject acform, forms(0).Name,f alse: docmd.MoveSize 0, 0,
forms(0).Width ,forms(0).Insid eHeight
Sorry for the late reply but I was away.
I tried your code but got the error message:
"The number you used to refer to the form is invalid"
I tried it on a good database too but trying to refer to "forms(0)" gave the
same result. It looks as though the switchboard isn't part of the Forms
collection.
I've ended up creating a replica of the database (to avoid having to work in
Braille as I couldn't see anything) and exporting everything from the
original and importing it into a new database.
I had to recreate all the tables by copying and pasting, to get rid of the
replication system fields. It was a messy fix but fortunately it wasn't a big
database.
It would still be nice to find a way repair the original. I don't want to
have to go through all this again in the future.
Ray Greene.
Ray Greene <ra***@es.co.nz > wrote in
news:C8******** ***********@new s.xtra.co.nz: I had to recreate all the tables by copying and pasting, to get
rid of the replication system fields. It was a messy fix but
fortunately it wasn't a big database.
You obviously didn't know about MichKa's unreplication wizard. See http://www.trigeminal.com for the download.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
On Wed, 27 Apr 2005 01:02:25 GMT, "David W. Fenton"
<dX********@bwa y.net.invalid> wrote: Ray Greene <ra***@es.co.nz > wrote in
news:C8******* ************@ne ws.xtra.co.nz:
I had to recreate all the tables by copying and pasting, to get
rid of the replication system fields. It was a messy fix but
fortunately it wasn't a big database.
You obviously didn't know about MichKa's unreplication wizard. See
http://www.trigeminal.com for the download.
Oh well, I know now. After I did all that work...
Thanks :-)
--
Ray Greene. 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: Dannic |
last post by:
Here is the application. Its a simple application really. I have a
db created in Access 2000 which opens to a switchboard created by the
switchboard manager.
Now the problem. This only works on some computers. I installed
access 2000 on two brand new, out of the box, computers and on one it
gives me a run time error and the other it doesn't. Both computers
are running windows XP. Though the operating system doesn't seem to
be the...
|
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: 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: Earl Anderson |
last post by:
In Acc2003, I have a situation in which I have a main switchboard and upon
pressing one of its buttons , takes the user to another sub hierarchical
switchboard. Pressing one of these buttons could take the user to another
switchboard or to forms within the topical heading of the switchboard.
What I would like to see is a "Screen Tip" type feature in which when the
mouse cursor is 'rested' upon a particular Switchboard button, the 'top...
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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: 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: 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: 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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...
| |
