Welcome to SPN

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

Sign Up Now!

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
     

Share This Page