Results 1 to 5 of 5

Entering multiple records on one form.

  1. #1
    thefairman is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Location
    California
    Posts
    10

    Entering multiple records on one form.

    I am fairly new to access. I have set up a rainfall database with a table for the rainfall stations linked to a table with daily rainfall data. Instead of entering data one day at a time, I'd like them to be able to enter data for an entire week. They would select the station and beginning date, then the form would automatically populate the dates for the week and the user would enter data for each day. Is there a simple way to do this?

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    31,257
    Simple? Not really. Requires VBA code.

    Either save records to table then open bound form to these records.

    Or use an unbound form and code to save records for data entered into unbound data controls.
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    thefairman is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2011
    Location
    California
    Posts
    10
    Thanks for your reply June7. I have decided to go an "easier" route by having a form where the user selects the station number, then there is a subform that should show a datasheet with all the values for that station. The user can then enter new data on that datasheet. The problem is that I can't seem to get the control box on the main form linked properly to the subform. Any suggestions? Does the control on the main form need to be bound? I think there might be something missing with my understanding of subforms. Thanks for your help.

  4. #4
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    31,257
    The main form is bound to table? You have Master/Child link properties of the subform container set? Use unbound combobox to select station number, then code will set the main form to that station record. The subform will synchronize.

    Check out this tutorial about setting up filter on a form http://datapigtechnologies.com/flash...tomfilter.html
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  5. #5
    thefairman is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2011
    Location
    California
    Posts
    10
    Thanks June7 for your help. That video was just what I needed!

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

Similar Threads

  1. Entering multiple parts onto an order form at once...
    By Lincoln in forum Database Design
    Replies: 8
    Last Post: 07-01-2011, 04:28 PM
  2. entering new records
    By MissRyan in forum Access
    Replies: 6
    Last Post: 06-29-2011, 03:39 AM
  3. Multiple Records On the same Form(ish)
    By Dalagrath in forum Forms
    Replies: 0
    Last Post: 03-30-2011, 10:13 AM
  4. One Form, Multiple records
    By andwhy81 in forum Forms
    Replies: 3
    Last Post: 09-21-2010, 11:12 AM
  5. Add Multiple Records on One Form
    By William McKinley in forum Forms
    Replies: 7
    Last Post: 08-18-2010, 08:31 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
  •  
Tech Forums: Microsoft Office Forums