Results 1 to 3 of 3
  1. #1
    dawson is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    2

    Need some help trying to figure out automatic data entry


    Hello all,

    I have been building an employee database, it has gone amazingly, just ran into something I wouldn't know how to sort out.

    Basically, when we have a new training requirement come out we need to track completion. The way I currently do that is adding it in through the "Add New Training" form that I have attached as a png. But that then requires me to go into each person "profile" and create a new training log for each person and then mark it as completed.

    What I am trying to do now is make it so that when I add a new training module I can select a box that will automatically make an entry in the query for each "person/id" that I can later go and just edit rather than having to manually add it with drop downs.

    Thanks allClick image for larger version. 

Name:	Add New Training.PNG 
Views:	16 
Size:	23.8 KB 
ID:	43016Click image for larger version. 

Name:	Training Viewer.PNG 
Views:	15 
Size:	26.7 KB 
ID:	43017v

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,859

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    FYI -> Etiquette about crossposting: https://www.excelguru.ca/content.php?184

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

Similar Threads

  1. Replies: 3
    Last Post: 03-18-2019, 08:56 AM
  2. Automatic Date Entry
    By Al77 in forum Access
    Replies: 3
    Last Post: 02-27-2012, 12:06 PM
  3. Automatic Username On Data Entry
    By netchie in forum Programming
    Replies: 10
    Last Post: 02-17-2012, 03:31 PM
  4. Automatic Field DAta Entry
    By Lupson2011 in forum Access
    Replies: 4
    Last Post: 09-01-2011, 09:15 AM
  5. Automatic Data Entry on a Specific Date
    By alanbrai in forum Programming
    Replies: 2
    Last Post: 11-14-2007, 05:15 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