On Mon, 7 Nov 2005 20:38:05 -0800, Mouse wrote:
> I have designed a pretty basic database which uses the Switchboard. Some of
> the forms I have create I want to only open in Datasheet view (not form
> view). I have modified the details in the forms properties which works from
> the Forms view of Access. However when I launch these forms from the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6899
> Switchboard it still opens them in Form view. How can I stop this from
> happening?
If you open a form from an event, regardless of the default view
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6899
settings of the form, you must specify datasheet view:
DoCmd.OpenForm "FormName", acFormDS
This is easy to do if your switchboard is one you created yourself.
Just add the ,acFormDS to the OpenForm code, as above.
However, if your switchboard is one created by the built in Access
Switchboard manager, you'll need to go into the code to modify it.
Open the Switchboard Code window.
Find the
Private Function HandleButtonClick(intBtn As Integer)
code line.
A few lines down you'll find the Constants listed.
Add
Const conCmdOpenFormDS = 9
at the end of the list (I believe there are originally just 8
constants).
Then go down further into the Select Case statements.
Add
Case conCmdOpenFormDS
DoCmd.OpenForm rst!Argument, acFormDS
just before the Case Else statement.
Close the code window.
Open the Switchboard Items table.
Change the Command value for the form you wish to
open from it's current number (either 2 or 3) to 9.
That should do it.
You cannot make or edit this changes using the Switchboard manager.
You must work around it, as above.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Our Donation Goal
: Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters 
Linear Mode
