Switchboard has disappeared

[Ray Greene]

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.

[Larry Linson]

Re: Switchboard has disappeared

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" <raygr@es.co.nz > wrote in message
news:IhCae.959$ Od6.143705@news .xtra.co.nz...[color=blue]
> 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[/color]
and[color=blue]
> forms etc if I select a category from the View > Database Objects menu,[/color]
and[color=blue]
> use the up/down keys and the Enter key, but I can't see what it is I am[/color]
about[color=blue]
> to open.
>
> I was able to replicate this with another database by moving the[/color]
switchboard[color=blue]
> 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.[/color]

[Ray Greene]

Re: Switchboard has disappeared

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" <bouncer@localh ost.not>
wrote:
[color=blue]
>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" <raygr@es.co.nz > wrote in message
>news:IhCae.959 $Od6.143705@new s.xtra.co.nz...[color=green]
>> 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[/color]
>and[color=green]
>> forms etc if I select a category from the View > Database Objects menu,[/color]
>and[color=green]
>> use the up/down keys and the Enter key, but I can't see what it is I am[/color]
>about[color=green]
>> to open.
>>
>> I was able to replicate this with another database by moving the[/color]
>switchboard[color=green]
>> 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.[/color]
>[/color]

[David W. Fenton]

Re: Switchboard has disappeared

Ray Greene <raygr@es.co.nz > wrote in
news:IhCae.959$ Od6.143705@news .xtra.co.nz:
[color=blue]
> 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?[/color]

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

[Larry Linson]

Re: Switchboard has disappeared

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

[Terry Kreft]

Re: Switchboard has disappeared

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" <raygr@es.co.nz > wrote in message
news:IhCae.959$ Od6.143705@news .xtra.co.nz...[color=blue]
> 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[/color]
and[color=blue]
> forms etc if I select a category from the View > Database Objects menu,[/color]
and[color=blue]
> use the up/down keys and the Enter key, but I can't see what it is I am[/color]
about[color=blue]
> to open.
>
> I was able to replicate this with another database by moving the[/color]
switchboard[color=blue]
> 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.[/color]

[Ray Greene]

Re: Switchboard has disappeared

On Mon, 25 Apr 2005 17:34:38 +0100, "Terry Kreft" <terry.kreft@mp s.co.uk>
wrote:
[color=blue]
>docmd.SelectOb ject acform, forms(0).Name,f alse: docmd.MoveSize 0, 0,
>forms(0).Width ,forms(0).Insid eHeight[/color]

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.

[David W. Fenton]

Re: Switchboard has disappeared

Ray Greene <raygr@es.co.nz > wrote in
news:C8ybe.1565 $Od6.245881@new s.xtra.co.nz:
[color=blue]
> 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.[/color]

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

[Ray Greene]

Re: Switchboard has disappeared

On Wed, 27 Apr 2005 01:02:25 GMT, "David W. Fenton"
<dXXXfenton@bwa y.net.invalid> wrote:
[color=blue]
>Ray Greene <raygr@es.co.nz > wrote in
>news:C8ybe.156 5$Od6.245881@ne ws.xtra.co.nz:
>[color=green]
>> 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.[/color]
>
>You obviously didn't know about MichKa's unreplication wizard. See
>http://www.trigeminal.com for the download.[/color]

Oh well, I know now. After I did all that work...

Thanks :-)

--
Ray Greene.