Results 1 to 7 of 7
  1. #1
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30

    Add New Button Disabled

    Hi,
    I have a form based on a query which is based on 13 tables. I have noticed that on the form, the add new button is disabled. Anybody have any thoughts?
    The structure is as follows,

    Main Table - Primary Key (ABC1)
    Location1 Table - Primary Key (ABC1)
    Location2 Table - Primary Key (ABC1)
    Location3 Table - Primary Key (ABC1)
    Location4 Table - Primary Key (ABC1)
    Location5 Table - Primary Key (ABC1)
    Location6 Table - Primary Key (ABC1)
    Location7 Table - Primary Key (ABC1)
    Location8 Table - Primary Key (ABC1)
    Location9 Table - Primary Key (ABC1)
    Location10 Table - Primary Key (ABC1)
    Location11 Table - Primary Key (ABC1)
    Location12 Table - Primary Key (ABC1)

    All the primary key fields are connected to the primary key in the Main Table.

    Any help would be much appreciated.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,624
    Are these tables identical in structure (same fields)? If so, should be one table with another field for the Location identifier.

    You say the Navigation bar new record button is not available? What is the form's setting for Allow Additions property?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30
    The forms setting is set to allow additions.

  4. #4
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30
    I just noticed that I can edit any of the current records either. Can anyone help please?

  5. #5
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30
    Sorry, I meant I cannot eidt any records.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,624
    Post the SQL statement for analysis or the project itself.

    The 12 tables each have 1-to-1 relationship with main table? The issue could be the join type in the query.

    Why 12 tables instead of 1? Are these tables really different?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30
    Thansk for everyone's help. I figured it was something in the relationships between the tables. Thanks again.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Macros disabled by hiding shutterbar
    By SemiAuto40 in forum Access
    Replies: 5
    Last Post: 12-30-2011, 03:25 PM
  2. Replies: 0
    Last Post: 02-22-2011, 05:04 AM
  3. Search on a disabled field
    By NOTLguy in forum Forms
    Replies: 9
    Last Post: 01-02-2011, 04:58 PM
  4. Formatting of disabled fields
    By Remster in forum Forms
    Replies: 2
    Last Post: 11-12-2010, 07:03 AM
  5. Replies: 1
    Last Post: 02-04-2010, 11:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums