how to force form to load in datasheet view

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Danny
    #1

    how to force form to load in datasheet view

    I am using a switchboard to load a form that I would like to display in
    datasheet view or table view. But it does not go into that mode when using
    the switchboard wizard to launche the form.

    is there a way to set this on the form's load property?
    Danny


    Tags: None
    • Steve Jorgensen
      #2
      Re: how to force form to load in datasheet view

      On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <dannywork5@hot mail.com> wrote:
      [color=blue]
      >I am using a switchboard to load a form that I would like to display in
      >datasheet view or table view. But it does not go into that mode when using
      >the switchboard wizard to launche the form.
      >
      >is there a way to set this on the form's load property?
      >Danny
      >[/color]

      Just have the switchboard call a macro or a VB procedure that opens the form
      in Datasheet view. Works like a charm.

        Comment

        • Danny
          #3
          Re: how to force form to load in datasheet view

          Thanks

          how can I call the function with a parameter. Also, where do I put this
          function?


          "Steve Jorgensen" <nospam@nospam. nospam> wrote in message
          news:7hrff0pf5c apjkc1om8cc0vil a97tp1sva@4ax.c om...[color=blue]
          > On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <dannywork5@hot mail.com> wrote:
          >[color=green]
          > >I am using a switchboard to load a form that I would like to display in
          > >datasheet view or table view. But it does not go into that mode when[/color][/color]
          using[color=blue][color=green]
          > >the switchboard wizard to launche the form.
          > >
          > >is there a way to set this on the form's load property?
          > >Danny
          > >[/color]
          >
          > Just have the switchboard call a macro or a VB procedure that opens the[/color]
          form[color=blue]
          > in Datasheet view. Works like a charm.[/color]


            Comment

            • Steve Jorgensen
              #4
              Re: how to force form to load in datasheet view

              Just create a function or macro to open the specific form in question, and
              call that macro or function. When you need another one, add another one.

              On Fri, 16 Jul 2004 17:08:45 GMT, "Danny" <dannywork5@hot mail.com> wrote:
              [color=blue]
              >Thanks
              >
              >how can I call the function with a parameter. Also, where do I put this
              >function?
              >
              >
              >"Steve Jorgensen" <nospam@nospam. nospam> wrote in message
              >news:7hrff0pf5 capjkc1om8cc0vi la97tp1sva@4ax. com...[color=green]
              >> On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <dannywork5@hot mail.com> wrote:
              >>[color=darkred]
              >> >I am using a switchboard to load a form that I would like to display in
              >> >datasheet view or table view. But it does not go into that mode when[/color][/color]
              >using[color=green][color=darkred]
              >> >the switchboard wizard to launche the form.
              >> >
              >> >is there a way to set this on the form's load property?
              >> >Danny
              >> >[/color]
              >>
              >> Just have the switchboard call a macro or a VB procedure that opens the[/color]
              >form[color=green]
              >> in Datasheet view. Works like a charm.[/color]
              >[/color]

                Comment

                • James
                  #5
                  Re: how to force form to load in datasheet view

                  Actually, an easier way might be to set the form's property sheet on
                  the Format tab to 'Allow Form View' = False, and 'Allow Datasheet
                  View' = True.

                  James

                  Steve Jorgensen <nospam@nospam. nospam> wrote in message news:<7hrff0pf5 capjkc1om8cc0vi la97tp1sva@4ax. com>...[color=blue]
                  > On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <dannywork5@hot mail.com> wrote:
                  >[color=green]
                  > >I am using a switchboard to load a form that I would like to display in
                  > >datasheet view or table view. But it does not go into that mode when using
                  > >the switchboard wizard to launche the form.
                  > >
                  > >is there a way to set this on the form's load property?
                  > >Danny
                  > >[/color]
                  >
                  > Just have the switchboard call a macro or a VB procedure that opens the form
                  > in Datasheet view. Works like a charm.[/color]

                    Comment

                    • Steve Jorgensen
                      #6
                      Re: how to force form to load in datasheet view

                      That would be easier, except it doesn't work. The DoCmd.OpenForm (which is
                      what the Switchboard uses), overrides any and all form settings regarding what
                      views to show, allow, and disallow. It overrides these things with its
                      default values if no parameters are specified, so there is simply no way to do
                      it with Form properties alone.

                      On 16 Jul 2004 21:39:02 -0700, dragonzfang@hot mail.com (James) wrote:
                      [color=blue]
                      >Actually, an easier way might be to set the form's property sheet on
                      >the Format tab to 'Allow Form View' = False, and 'Allow Datasheet
                      >View' = True.
                      >
                      >James
                      >
                      >Steve Jorgensen <nospam@nospam. nospam> wrote in message news:<7hrff0pf5 capjkc1om8cc0vi la97tp1sva@4ax. com>...[color=green]
                      >> On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <dannywork5@hot mail.com> wrote:
                      >>[color=darkred]
                      >> >I am using a switchboard to load a form that I would like to display in
                      >> >datasheet view or table view. But it does not go into that mode when using
                      >> >the switchboard wizard to launche the form.
                      >> >
                      >> >is there a way to set this on the form's load property?
                      >> >Danny
                      >> >[/color]
                      >>
                      >> Just have the switchboard call a macro or a VB procedure that opens the form
                      >> in Datasheet view. Works like a charm.[/color][/color]

                        Comment

                        Previous template Next
                        Working...