Add field to a tab

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Jake Bee
    New Member
    • Apr 2008
    • 6

    #1

    Add field to a tab

    I have a small job in Access (which I haven't used for years). We have Access 2000. I have added 2 date fields to the backend (on the table where the two fields were needed). We have frontend with a form containing a tabbed form (with 3 tabs). I have to add the 2 dates to the 3rd tab. The Field List is "grayed out", and I can't figure out how to add the fields to the 3rd tab on the Form. In fact, I can't add the Fields anywhere on the Form. Any ideas what I'm doing wrong, such that the Field List is "grayed out"? It seems like it should be a simple drag-and-drop to add the fields.

    Thanks!
    Jake
  • Megalog
    Recognized Expert Contributor
    • Sep 2007
    • 378

    #2
    Strange.. Is it just that one form not letting you edit it, or is the entire db acting like this?
    First off, make sure you're trying to modify an MDB, and not an MDE file.
    And I would try unlinking the table from the db, and re-linking it again.

    If none of the above do anything, try just drawing a new text box onto the 3rd tab (click the tab page first to select it), and see if you can choose the new date field in the Control Source property.

    Comment

    • razjafry
      New Member
      • Sep 2007
      • 30

      #3
      Hi,
      I think you should select both fields as a group, then right click to copy and then right click the third tab and past them there. I hope this would solve this minor problem.
      raz

      Comment

      • Jake Bee
        New Member
        • Apr 2008
        • 6

        #4
        Originally posted by Megalog
        Strange.. Is it just that one form not letting you edit it, or is the entire db acting like this?
        First off, make sure you're trying to modify an MDB, and not an MDE file.
        And I would try unlinking the table from the db, and re-linking it again.

        If none of the above do anything, try just drawing a new text box onto the 3rd tab (click the tab page first to select it), and see if you can choose the new date field in the Control Source property.
        I fount that I had to double click on the upper left gray box, and then in properties make the tables visible. (Strange that these we set "invisible" in design mode.)

        Comment

        • Jake Bee
          New Member
          • Apr 2008
          • 6

          #5
          I had to double click on the upper left gray box, then in properties make the table visible.

          Comment

          Working...