Results 1 to 11 of 11
  1. #1
    KirstyP is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2015
    Location
    Darwin
    Posts
    6

    Form and Binding Records

    Hi,



    I have created a database with five tables and am now, and have been banging my head over it for the past 5 days, trying to create forms to add and edit information. However when I go to add the Combo Box to ‘Find a record on my form based on the value I selected in my Combo box', it doesn't appear. I know this means that I have not bound my resources but I can not nut out where I have gone wrong. I am at the point that I will send it to a professional if I can not work it out myself as I am at wits end.

    I have attached a screen dump of what I have and the relationships, any advice would be amazing. If not, please shoot away any names and emails for who I can send it to?

    Thank you,
    Kirsty
    Attached Files Attached Files

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Can't open the attachment right now, but typically the wizard will only show that option if the form is bound directly to a table, not a query or SQL.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You are linking three tables on PK fields (Band). I am assuming none of these are autonumber type. Can only link on PK fields if the tables have a 1-to-1 relationship.

    Why is Band Member a separate table if there can be only one record for each band? As structured, each band can have only 3 members. This is not a normalized table.

    Surely each band will have multiple events, therefore, Band cannot be a unique identifier in Events.

    Advise not to use spaces or special characters/punctuation (underscore is exception) in naming convention. Better would be ManagerPhone or Manager_Phone. Each manager will have multiple phone records?
    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.

  4. #4
    KirstyP is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2015
    Location
    Darwin
    Posts
    6
    Thanks Paul, I know that it must not be bound, but as far as I can see it is? I just feel like I have been watching the same page now for so long.
    I am creating the Form straight from the 'Bands' table and collaborating the Managers and Band Members information to the one form, I just can't see why it isn't bound?
    If all else fails, does anyone know of a quick business to send it to and have fresh eyes over it?

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Did you see my earlier post?

    If you want to provide db for analysis, follow instructions at bottom of my post.
    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.

  6. #6
    KirstyP is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2015
    Location
    Darwin
    Posts
    6
    Hi June, thank you very much. I must have replied at the same time as you posted and then walked off. Once kids are in bed I will have a look.
    Thank you again, fantastic knowledge source all in one place.

  7. #7
    KirstyP is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2015
    Location
    Darwin
    Posts
    6
    Hi,

    I have just checked and my 'Bands' tables are all one - to one.

    Yes I agree on the managers and events tables, but these were prescribed to me and they don't want to change it.
    Attached Files Attached Files

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Each band can have only one event?

    Each band is limited to 3 members?

    Which form? None have a combobox.

    The subform containers have tables as SourceObject, not forms. Cannot have code behind tables (except for data macros and those won't do what you want).

    Still advise not to use spaces and special characters/punctuation (underscore is exception) in naming convention.

    I add a combobox to each form and the 'Find ...' option is available. Cannot replicate the issue. However, even if the wizard isn't working for you, can create the code manually.
    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.

  9. #9
    KirstyP is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2015
    Location
    Darwin
    Posts
    6
    Yes, I agree with the events and limitation to members, I have raised that myself. But it is a small regional council so it probably won't have more than that anyway. I will chip away at getting them to agree.
    I was attempting to put a combobox in a form, including Band, Band Members, Genre, Manager and Manager contact to ensure to edit and create new bands etc.

  10. #10
    KirstyP is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2015
    Location
    Darwin
    Posts
    6
    I have also fixed the titles, there are no longer spacing between any of them.

  11. #11
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Special characters/punctuation?

    Don't know what you mean by " including Band, Band Members, Genre, Manager and Manager contact to ensure to edit and create new bands etc."
    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.

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

Similar Threads

  1. Binding Help
    By kgbo in forum Forms
    Replies: 1
    Last Post: 08-15-2013, 11:50 AM
  2. Binding a checkbox to a subform
    By Bhat59 in forum Forms
    Replies: 3
    Last Post: 10-20-2011, 08:48 PM
  3. Binding 'count' <>1 to appropriate key
    By Captain Database ...!! in forum Queries
    Replies: 2
    Last Post: 06-09-2011, 06:44 PM
  4. Binding a Combo Box Search Result
    By cvansickle in forum Forms
    Replies: 2
    Last Post: 12-06-2010, 11:03 AM
  5. binding report field to variable
    By frente in forum Reports
    Replies: 1
    Last Post: 10-19-2009, 02:48 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