Results 1 to 3 of 3
  1. #1
    Daisy509th's Avatar
    Daisy509th is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Location
    Central Texas
    Posts
    51

    Driver Paperwork/Truck DataBase

    Hello All,

    So I have been given the task of tracking driver's paperwork and the trucks they are assign to. Here is my plan for the database.

    DVIR's and Driver Logs pose a problem to me because they have individual dated but we group them by week ending dates. I am not sure how to handle that. The DVIR's have a relationship to trucks and drivers.

    I need to report on trucks, their status, and if they are assigned or not.

    I also need to be able to give warning to the office in advance of when a driver's med card or license is about to expire

    Timesheets, DVIR's, and Driver logs have to be turned in once a week. I then have to scan them and send them to the office. Plus, I need to know what i received, missing, and also what I have returned and why. I also need to be able to print a driver roster for turn in showing the drivers and what they turned in.

    Any help would be great before I start down this rabbit hole



    ThanksAttachment 33230

  2. #2
    Join Date
    Apr 2017
    Posts
    1,673
    A couple of remarks.

    There is info for employee, which must be elsewhere:
    TruckID - an employee can drive different trucks over time;
    TimesheetID - timesheet is created weekly, so you have a lot of timesheets for employee over time;
    MedcardID - again when medcard expires, a new one is needed;
    I don't understand, what is DVIR and what items are returned to it, but it looks again like something which must have a lot of separate rows of info per employee.

    You have to think carefully through, how you link employees/drivers and trucks. When the truck is given to driver for longer time, then probably you need a DriverTrucks table with DriverID, TruckID, and ValidFrom date. When the driver and truck are assigned for particular transport only, then DriverID and TruckID must be included into table where those transports are registered.

  3. #3
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make a query on truck status, if tTrucks.DriverID is null, then the truck is unassigned

    make a query on tEmployees joined to tMedcards
    in the query field, check if card has 20 days remaining: DateDiff("d", tMedcards.ExpireDate ,Date) < 20


    for scanned images, I would have a folder to store them, then paste the path to the image in a table. (storing the image fills up the database too fast)
    I use tDocuments table:
    DocID (auto)
    EmpID
    DocName ("Drivers License")
    DocPath (c:\folder\docs\myfile.pdf)

    there is code to open the document from within Access.

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

Similar Threads

  1. Code for Driver installed
    By Joakim N in forum Programming
    Replies: 1
    Last Post: 04-25-2017, 03:50 AM
  2. truck loads and daily totals?
    By nickdixon14 in forum Access
    Replies: 12
    Last Post: 10-13-2015, 05:16 PM
  3. Unexpected error from external database driver (1)
    By Icon in forum Import/Export Data
    Replies: 3
    Last Post: 05-15-2015, 12:40 PM
  4. Path to ODBC Driver
    By cbouley in forum Access
    Replies: 3
    Last Post: 04-23-2013, 10:00 AM
  5. Truck transportation business orders
    By aurorist in forum Database Design
    Replies: 3
    Last Post: 01-12-2012, 05:16 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