Results 1 to 3 of 3
  1. #1
    sivega is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    12

    Adding Multiple Entries To 1 Table

    Hello,

    Here's my situation. I have 1 table.

    Person
    Date of Event
    Sponsor


    Credit
    Category

    Sometimes a person will attend an event and recieve multiple credits in different categories. I have a form now that whenever does this does happen I can only enter 1 credit at a time, exit and reenter the form, and reenter all of the information for the same person but for a different credit.

    Is there a way to be able to automatically enter another credit field on the form? I just don't want to have to keep renetering the same information all over again.....

    Thank you!

  2. #2
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    I don't think so. Nor easily anyway.
    Another table for credits would solve your problem.

    Dale

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Why are you limited to one record entry? You should have multiple related tables. Consider:

    tblEvents
    EventID
    EventName
    EventDate
    EventSponsor

    tblAttendees
    AttendeeID
    AttendeeName

    tblCredits
    EventID
    AttendeeID
    Credit
    Category

    Now use form/subform arrangement to enter data. Options:
    1. main form bound to tblEvents, subform bound to tblCredits with combobox to select attendee
    2. main form bound to tblAttendees, subform bound to tblCredits with combobox to select event

    In either case, code behind the combobox can cause selected value to carry forward to next record by setting the DefaultValue property.
    Private Sub comboboxname_BeforeUpdate(Cancel As Integer)
    Me.comboboxname.DefaultValue = Me.comboboxname
    End Sub

    Also, if desired event or attendee not in the combobox list, use NotInList event to create new record. http://msdn.microsoft.com/en-us/libr.../ff845736.aspx
    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. design phase ... question on multiple entries from same table
    By sbrockett751 in forum Database Design
    Replies: 2
    Last Post: 03-13-2013, 03:13 PM
  2. Not able to make multiple entries (records) in the table
    By ramindya in forum Database Design
    Replies: 3
    Last Post: 03-04-2012, 12:53 PM
  3. help adding multiple entries to outlook
    By Goli1984 in forum Programming
    Replies: 1
    Last Post: 01-26-2012, 03:35 PM
  4. How do I add multiple table entries using check boxes?
    By avarusbrightfyre in forum Access
    Replies: 3
    Last Post: 10-21-2010, 01:09 PM
  5. merge multiple entries in table
    By rajsa in forum Database Design
    Replies: 1
    Last Post: 07-02-2010, 07:16 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