Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    3

    Angry Help!!! user friendly forms/date entry


    I work for a small private airport and am recently learning how to create access forms and tables to track our customer history. Leaning meaning, poking,hacking and re-doing alot, so I figured I would give this a try.
    We have several planes come through our facility a day and each plane has its own id number, which I have made my primary key in my table.
    I have already created my tables, the first consisting of customer names and last contact date and such, and then a subdatasheet with all of the mailing info in it.


    I want to do a couple of things: 1) Be able to add more than one company to each tail number and be able to see each company that has used that tail number (sort of like peoples orders and what they have ordered) and 2) I would like to create a form that is user friendly and also shows all the necessary information. Can anyone help me with these problems?
    I hope that this makes sense and even more so that someone can point me in the right direction, because poking around on the internet is really not getting me very far.
    Thank you for your time!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    The 1:m relationships are best displayed and edited using a Form for the one side and a SubForm for the many side.

  3. #3
    Join Date
    Mar 2009
    Posts
    3

    Thank you

    Thank you for your reply, but I am afraid I don't know what you mean.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Have you looked at the templates that ship with Access ar the ones on the Microsoft site? It is a good place to start with Access. Pick one that is close to what you want and then start modifying it to your needs.

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

Similar Threads

  1. Form Data Entry Problem?
    By corystemp in forum Database Design
    Replies: 1
    Last Post: 03-21-2009, 02:29 PM
  2. Date error on my forms
    By elbob62 in forum Access
    Replies: 1
    Last Post: 12-05-2008, 05:35 PM
  3. Date Stamp On Entry of Record
    By tscholts in forum Forms
    Replies: 3
    Last Post: 04-01-2008, 07:08 PM
  4. Automatic Data Entry on a Specific Date
    By alanbrai in forum Programming
    Replies: 2
    Last Post: 11-14-2007, 05:15 PM
  5. restricting combo box entry
    By fairlo in forum Forms
    Replies: 1
    Last Post: 10-04-2007, 04:05 PM

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