Show new table

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

    Show new table

    Hello,

    I'm creating a new table in code (dataBaseObject .TableDefs.Appe nd
    MyNewTable) but it doesn't show up in the navigation pane until I close the
    database and open it back up again. Is there some VB command to force the
    table to appear in the pane?

    Thanks,

    Gord


    Tags: None
    • Steve
      #2
      Re: Show new table

      After you append your new table to the TableDefs collection, you need to
      refresh the TableDefs collection:

      dataBaseObject. TableDefs.Refre sh

      Steve




      "Gord" <x1gord1x@telus .netwrote in message
      news:Wq4jk.2071 $%b7.354@edtnps 82...
      Hello,
      >
      I'm creating a new table in code (dataBaseObject .TableDefs.Appe nd
      MyNewTable) but it doesn't show up in the navigation pane until I close
      the database and open it back up again. Is there some VB command to force
      the table to appear in the pane?
      >
      Thanks,
      >
      Gord
      >

        Comment

        • Gord
          #3
          Re: Show new table

          I already tried that but no go. I have since discovered that I can make the
          table appear in the navigation pane by clicking the shutter bar (closing the
          pane) and then opening it again. Maybe that's just how it works? I was
          hoping that the new table name could be made to appear automatically ...

          Thanks for the suggestion.

          Gord

          "Steve" <nonsense@nomse nse.comwrote in message
          news:hPKdnRZVNd 1oSRHVnZ2dnUVZ_ tfinZ2d@earthli nk.com...
          After you append your new table to the TableDefs collection, you need to
          refresh the TableDefs collection:
          >
          dataBaseObject. TableDefs.Refre sh
          >
          Steve
          >
          >
          >
          >
          "Gord" <x1gord1x@telus .netwrote in message
          news:Wq4jk.2071 $%b7.354@edtnps 82...
          >Hello,
          >>
          >I'm creating a new table in code (dataBaseObject .TableDefs.Appe nd
          >MyNewTable) but it doesn't show up in the navigation pane until I close
          >the database and open it back up again. Is there some VB command to
          >force the table to appear in the pane?
          >>
          >Thanks,
          >>
          >Gord
          >>
          >
          >

            Comment

            • Stuart McCall
              #4
              Re: Show new table

              "Gord" <x1gord1x@telus .netwrote in message
              news:nzcjk.2178 $%b7.494@edtnps 82...
              >I already tried that but no go. I have since discovered that I can make
              >the table appear in the navigation pane by clicking the shutter bar
              >(closing the pane) and then opening it again. Maybe that's just how it
              >works? I was hoping that the new table name could be made to appear
              >automaticall y ...
              >
              Thanks for the suggestion.
              >
              Gord
              >
              "Steve" <nonsense@nomse nse.comwrote in message
              news:hPKdnRZVNd 1oSRHVnZ2dnUVZ_ tfinZ2d@earthli nk.com...
              >After you append your new table to the TableDefs collection, you need to
              >refresh the TableDefs collection:
              >>
              >dataBaseObject .TableDefs.Refr esh
              >>
              >Steve
              >>
              >>
              >>
              >>
              >"Gord" <x1gord1x@telus .netwrote in message
              >news:Wq4jk.207 1$%b7.354@edtnp s82...
              >>Hello,
              >>>
              >>I'm creating a new table in code (dataBaseObject .TableDefs.Appe nd
              >>MyNewTable) but it doesn't show up in the navigation pane until I close
              >>the database and open it back up again. Is there some VB command to
              >>force the table to appear in the pane?
              >>>
              >>Thanks,
              >>>
              >>Gord
              Try: Application.Ref reshDatabaseWin dow


                Comment

                • Gord
                  #5
                  Re: Show new table

                  Thanks Stuart. That did the trick just fine.

                  Gord

                  "Stuart McCall" <smccall@myunre albox.comwrote in message
                  news:g6jn3r$3f8 $1$8300dec7@new s.demon.co.uk.. .
                  "Gord" <x1gord1x@telus .netwrote in message
                  news:nzcjk.2178 $%b7.494@edtnps 82...
                  >>I already tried that but no go. I have since discovered that I can make
                  >>the table appear in the navigation pane by clicking the shutter bar
                  >>(closing the pane) and then opening it again. Maybe that's just how it
                  >>works? I was hoping that the new table name could be made to appear
                  >>automatical ly ...
                  >>
                  >Thanks for the suggestion.
                  >>
                  >Gord
                  >>
                  >"Steve" <nonsense@nomse nse.comwrote in message
                  >news:hPKdnRZVN d1oSRHVnZ2dnUVZ _tfinZ2d@earthl ink.com...
                  >>After you append your new table to the TableDefs collection, you need to
                  >>refresh the TableDefs collection:
                  >>>
                  >>dataBaseObjec t.TableDefs.Ref resh
                  >>>
                  >>Steve
                  >>>
                  >>>
                  >>>
                  >>>
                  >>"Gord" <x1gord1x@telus .netwrote in message
                  >>news:Wq4jk.20 71$%b7.354@edtn ps82...
                  >>>Hello,
                  >>>>
                  >>>I'm creating a new table in code (dataBaseObject .TableDefs.Appe nd
                  >>>MyNewTable ) but it doesn't show up in the navigation pane until I
                  >>>close the database and open it back up again. Is there some VB command
                  >>>to force the table to appear in the pane?
                  >>>>
                  >>>Thanks,
                  >>>>
                  >>>Gord
                  >
                  Try: Application.Ref reshDatabaseWin dow
                  >
                  >

                    Comment

                    Previous template Next
                    Working...