Focus from Switchboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

I have a report that needs to be the focus after a database starts up. The
switchboard manager has been used.

It doesn't seem to matter where I put the code to make the report get the
focus (Docmd.SelectObject etc...), the switchboard always pops up in front.

Any ideas?
 
in message:
Hi:

I have a report that needs to be the focus after a database starts up. The
switchboard manager has been used.

It doesn't seem to matter where I put the code to make the report get the
focus (Docmd.SelectObject etc...), the switchboard always pops up in front.

Any ideas?
Click to expand...

How about under Tools | Startup specifying no startup form and no Database Window.
Then create an Autoexec macro that opens the necessary report. When the database
is opened, the report will be opened and have the focus since no other form is loaded.
In the Close event of the report just insert some code to open the Switchboard form.

Will that work for you?
 
Good though Jeff

I actually hadn't thought of that but I don't think it will work in this
case because there is also a ton of RefreshLinks code that has to happen (you
might be familiar with it....written by Dev Ashish)

Anyway, the switchboard code starts, goes to the AutoExec (which is the
Refresh stuff), comes back and finishes the switchboard.

I had tried my code in the AutoExec but that was too soon. So I put it at
the end of the Switchboard code (after all of the buttons become visible) but
still the switchboard jumps in front.

I'm not a big fan of what pop up and modal do in this case so I did not want
to use them .
 
Just a thought, you could set the startup to open a splash screen where your
refresh links are running in the background, then open your report and close
your splash screen when the refresh is finished.

Allan Murphy
 
OK, so I gather it is the whole startup loading of the switchboard that keeps
it in focus.

So, have the splash screen up, chaos in the background and the OK button
does not show up on the splash until after the linking and switchboard are in
place. Clicking OK runs the test for my report and life goes on.

It's a little more complex than what I had expected but I think it should
work!!

Thanks very much for your input and assistance.

CJ
 
Back
Top