datasheet forms open in form mode from the Switchboard

  • Thread starter Thread starter Paul James
  • Start date Start date
P

Paul James

I've got some forms that I would only like to open in datasheet view, so I
set the Default View property to Datasheet, and all the other form view
properties to "No."

However, when these forms open from my Switchboard form, which I created
from the Switchboard Manager, these forms all open in Form View. I tried
looking at the code in the Switchboard as well as the parameters in the
Switchboard Items table, but I couldn't figure out any way to tell it to
open certain forms in datasheet view.

Is there any way I can get these forms to open from the Switchboard in
Datasheet View or, alternatively, is there VBA code I could put in the
forms' Open event that would change it to Datasheet view?

Thanks in advance,

Paul
 
Hi Paul,

You have three options (at least) available to you.

1. You could make your form into a Continuous Form and
design it so it *looks* just like a datasheet. Then open
it in Add/Edit mode from the Switchboard.

2. You could design your own "Switchboard-type" form and
launch all your procedures from there.

3. You can change the Switchboard code a little bit to
achieve your desired result. The Switchboard automatically
will open a form in Single view. If you change the code to
datasheet view then ALL forms will open in Datasheet view
when launched from the Switchboard, which is probably not
a good thing. If you would like to have the best of both worlds,
follow these instructions on a BACK-UP COPY.

Open the Switchboard code. Find the area that has this:

' Constants for the commands that can be executed.
Const conCmdGotoSwitchboard = 1
Const conCmdOpenFormAdd = 2
Const conCmdOpenFormBrowse = 3
Const conCmdOpenReport = 4
Const conCmdCustomizeSwitchboard = 5
Const conCmdExitApplication = 6
Const conCmdRunMacro = 7
Const conCmdRunCode = 8

Add one more line to the list like this:

Const conCmdOpenFormDatasheet = 9

Now go a little further down the code until you come to
this area:

' Run code.
Case conCmdRunCode
Application.Run rst![Argument]

' Any other command is unrecognized.
Case Else
MsgBox "Unknown option."

In between these two areas we want to add another one for
datasheet view. Add in this new code in the middle so it
looks like this:

' Run code.
Case conCmdRunCode
Application.Run rst![Argument]

' Open a form in Datasheet Mode.
Case conCmdOpenFormDatasheet
DoCmd.OpenForm rst![Argument], acFormDS

' Any other command is unrecognized.
Case Else
MsgBox "Unknown option."

Compile and save the form.

Now you will NOT be able to use the Switchboard Wizard to
use this option. The Wizard will only use the 8 pre-
defined options. To open a form in Datasheet View you will
need to go directly to the Switchboard Items TABLE and add
it yourself. If you study the records you will figure out
what is going on. Just use the number 9 in the Command
field to open a form in datasheet view and showing all
records.
 
Wow. What a great way to expand the options on a Switchboard!

Thanks so much for explaining how to do it.
 
Another simplier solution is to create a macro that calls the form as
datasheet and call the macro from your switchboard
 
Another great idea. Thanks, Tom.

I've overlooked the fact that you can call macros from the Switchboard. I'm
glad you pointed that out.

Paul
 
Back
Top