Results 1 to 4 of 4
  1. #1
    Telejazzer is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Posts
    4

    Multi Entry Form

    Hi All,



    I don't really know how to call it but multi entry form came into mind. I'm trying to create a form that makes sense to our users and the form should look like the attached PDF. Some ideas on how to create the form should be great.

    Thanks.
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Build an 'entry' table that looks like your screen.
    When the user clicks SAVE, run queries to parse the data into its normalized tables.

  3. #3
    Telejazzer is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Posts
    4

    Steps in creating entry

    Quote Originally Posted by ranman256 View Post
    Build an 'entry' table that looks like your screen.
    When the user clicks SAVE, run queries to parse the data into its normalized tables.
    I'm new to creating forms. Would you be able to give me some steps on how to create the 'entry' table?

    Do I need to create a Save button on the form?

    Thanks.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    To have the look you present, I think you are looking at a main form with 4 sub form controls, one for each week but I tend to see things as being more complex than they are sometimes! The only way I know that you can get detail sections side by side like that is to position sub controls next to each other. If correct, I would not go there if not absolutely necessary as it would be no small task to correlate everything. Consider Store, WeekNum and Day (SWD) as combos whereby the data entered into 4 Min and 4 Sup controls (each bound to their own field) in the detail section is tied to the combination of SWD for the record. You would not need a Save button if you were creating records or editing on the fly. Watch the use of reserved words when naming stuff. Min is a reserved word.

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

Similar Threads

  1. Multi user data entry
    By FJM in forum Access
    Replies: 5
    Last Post: 01-07-2015, 02:27 AM
  2. Replies: 5
    Last Post: 03-09-2014, 07:16 PM
  3. Multi field entry from form
    By liam_898 in forum Forms
    Replies: 1
    Last Post: 05-09-2012, 06:21 PM
  4. Multi-table Data entry form
    By halpme in forum Forms
    Replies: 3
    Last Post: 11-10-2011, 02:48 PM
  5. multi-select listbox and new entry button
    By user622 in forum Forms
    Replies: 2
    Last Post: 07-05-2011, 09:14 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