Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Open Form in Datasheet view from Switchboard

Discussion in 'Information Technology' started by Mouse, Nov 8, 2005.

  1. Mouse

    Mouse
    Expand Collapse
    Guest

    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
    Switchboard it still opens them in Form view. How can I stop this from
    happening?
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    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
    > 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
    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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page