By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,082 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

Switchboard has disappeared

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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*****@localhost.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******************@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.


Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

P: n/a
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


Nov 13 '05 #5

P: n/a
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.SelectObject acform, forms(0).Name,false: docmd.MoveSize 0, 0,
forms(0).Width,forms(0).InsideHeight

--
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.

Nov 13 '05 #6

P: n/a
On Mon, 25 Apr 2005 17:34:38 +0100, "Terry Kreft" <te*********@mps.co.uk>
wrote:
docmd.SelectObject acform, forms(0).Name,false: docmd.MoveSize 0, 0,
forms(0).Width,forms(0).InsideHeight


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.
Nov 13 '05 #7

P: n/a
Ray Greene <ra***@es.co.nz> wrote in
news:C8*******************@news.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
Nov 13 '05 #8

P: n/a
On Wed, 27 Apr 2005 01:02:25 GMT, "David W. Fenton"
<dX********@bway.net.invalid> wrote:
Ray Greene <ra***@es.co.nz> wrote in
news:C8*******************@news.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.
Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.