Property sheet and Add Existing Fields

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • CD Tom
    Contributor
    • Feb 2009
    • 495

    Property sheet and Add Existing Fields

    A funny thing has happened and I'm at a loss as to where to find the answer. I'm using Access 2007, My Property sheet and Add Existing Fields are in the command bar but when I click on either one I don't get them on my screen. I've checked all the edges because sometime you can move then and they seem to be gone.
    Does any body have a clue as to what could have happened.
  • twinnyfo
    Recognized Expert Moderator Specialist
    • Nov 2011
    • 3664

    #2
    Tom,

    Try typing this in the Immediate window:

    Code:
    Commandbars("Property Sheet").Enabled=True
    Hope that hepps!

    Comment

    • CD Tom
      Contributor
      • Feb 2009
      • 495

      #3
      I tried that and still nothing. The Property Sheet is already in the Command bar, just doesn't show up when clicked.

      Comment

      • isladogs
        Recognized Expert Moderator Contributor
        • Jul 2007
        • 483

        #4
        As you suggested in post #1, they could both be appearing off screen or on a secondary monitor if you have one.

        Try increasing your resolution if possible.
        Another trick that may help is to rotate your screen 90 degrees to the right then rotate it back again

        Comment

        • CD Tom
          Contributor
          • Feb 2009
          • 495

          #5
          Ok, I switched the screen to Portrait and then back to landscape and that worked. Thanks so much.

          Comment

          • isladogs
            Recognized Expert Moderator Contributor
            • Jul 2007
            • 483

            #6
            Glad I could help. That 'trick' often works

            Comment

            • twinnyfo
              Recognized Expert Moderator Specialist
              • Nov 2011
              • 3664

              #7
              I've heard something about that glitch before, too!

              Thanks IslaDogs for assisting with this!

              Comment

              • isladogs
                Recognized Expert Moderator Contributor
                • Jul 2007
                • 483

                #8
                The screen rotation 'trick' has worked in a variety of problems.
                Only recently it allowed someone else to recover the VBE menu bar that had been undocked and somehow moved off screen

                Comment

                Working...