Restore Database Window

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

    Restore Database Window

    I have a large relational database which has attached to one of my forms at
    startup; a macro which assigns the current time and date.
    I must have inadvertently changed the macro and have somehow caused a block
    to the tools menu and I have lost the database window.


    Is there a way to recover the database window or at least the tools menu so
    I can access the startup options and correct the problem?



    So far I have

    (1) Tried Shift then opening the database - tools option display for a
    second but cannot be invoked

    (2) I have attempted to import all components from the effected database
    into a new database but I am receiving vb errors which I am sure I can
    rectify if I had the time.


    I have not as yet imported just the tables and queries which will be my next
    option


    Any assistance would be appreciated.

    Zellan


    Tags: None
    • Larry Linson
      #2
      Re: Restore Database Window

      Did you try holding down the shift key when opening your database or
      pressing F11 with the database open?

      Larry Linson
      Microsoft Access MVP

      "Zellan" <Zellan@hotmail .com> wrote in message
      news:4477ae92$0 $19062$afc38c87 @news.optusnet. com.au...[color=blue]
      >I have a large relational database which has attached to one of my forms at
      >startup; a macro which assigns the current time and date.
      > I must have inadvertently changed the macro and have somehow caused a
      > block to the tools menu and I have lost the database window.
      >
      >
      > Is there a way to recover the database window or at least the tools menu
      > so I can access the startup options and correct the problem?
      >
      >
      >
      > So far I have
      >
      > (1) Tried Shift then opening the database - tools option display for a
      > second but cannot be invoked
      >
      > (2) I have attempted to import all components from the effected database
      > into a new database but I am receiving vb errors which I am sure I can
      > rectify if I had the time.
      >
      >
      > I have not as yet imported just the tables and queries which will be my
      > next option
      >
      >
      > Any assistance would be appreciated.
      >
      > Zellan
      >
      >[/color]


        Comment

        • Zellan
          #3
          Re: Restore Database Window

          Hi Larry,

          I held down F11 and then opened the database. It showed the toolbar for a
          brief moment but I am unable to navigate to it so I can open the startup
          menu...it just disappears before I can engage it..Is there anything I can do
          at this stage to "buy myself more time"

          Thanks.

          Zellan

          "Larry Linson" <bouncer@localh ost.not> wrote in message
          news:pzOdg.2513 $lN5.765@trnddc 04...[color=blue]
          > Did you try holding down the shift key when opening your database or
          > pressing F11 with the database open?
          >
          > Larry Linson
          > Microsoft Access MVP
          >
          > "Zellan" <Zellan@hotmail .com> wrote in message
          > news:4477ae92$0 $19062$afc38c87 @news.optusnet. com.au...[color=green]
          >>I have a large relational database which has attached to one of my forms
          >>at startup; a macro which assigns the current time and date.
          >> I must have inadvertently changed the macro and have somehow caused a
          >> block to the tools menu and I have lost the database window.
          >>
          >>
          >> Is there a way to recover the database window or at least the tools menu
          >> so I can access the startup options and correct the problem?
          >>
          >>
          >>
          >> So far I have
          >>
          >> (1) Tried Shift then opening the database - tools option display for a
          >> second but cannot be invoked
          >>
          >> (2) I have attempted to import all components from the effected
          >> database into a new database but I am receiving vb errors which I am sure
          >> I can rectify if I had the time.
          >>
          >>
          >> I have not as yet imported just the tables and queries which will be my
          >> next option
          >>
          >>
          >> Any assistance would be appreciated.
          >>
          >> Zellan
          >>
          >>[/color]
          >
          >[/color]


            Comment

            • Rick Brandt
              #4
              Re: Restore Database Window

              Zellan wrote:[color=blue]
              > Hi Larry,
              >
              > I held down F11 and then opened the database. It showed the toolbar
              > for a brief moment but I am unable to navigate to it so I can open
              > the startup menu...it just disappears before I can engage it..Is
              > there anything I can do at this stage to "buy myself more time"[/color]

              You don't hold F11 while opening the file. You hold Shift while opening the
              file. F11 is for showing the db window AFTER the file is already open (but only
              if that hasn't been disabled in Startup).

              --
              Rick Brandt, Microsoft Access MVP
              Email (as appropriate) to...
              RBrandt at Hunter dot com


                Comment

                Previous template Next
                Working...