• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

A Handover Database for 3 Depts & Hidden Systems or Managers Page (1 Viewer)

Status
Not open for further replies.

murray83

Games Collector
Local time
Today, 13:24
Joined
Mar 31, 2017
Messages
621
Hi All

please find attached the finished Handover Database

used other 3 depts and a systems/manager section hidden from main site based on PC logon

also the how to use guide

sorry they are zipped but they where both just over the size limit
 

Attachments

  • Handover Database Guide.zip
    430.1 KB · Views: 582
  • Handover Database - Example.zip
    277.8 KB · Views: 717

murray83

Games Collector
Local time
Today, 13:24
Joined
Mar 31, 2017
Messages
621
see slight addition for when people had been completing the night shift info was going on wrong day so fixed with two text boxes which first has this in

Code:
=Now()-1

and second one has this
Code:
=Left([DateNight],10)
and just slight change to SQL and bobs your uncle
 

Attachments

  • Handover Database - Example v2.zip
    301.3 KB · Views: 68

murray83

Games Collector
Local time
Today, 13:24
Joined
Mar 31, 2017
Messages
621
updated once again

new functions added

*email report for each shift

and have trimmed away tables not needed
 

Attachments

  • Handover_Databasev2.zip
    289.3 KB · Views: 187

isladogs

CID VIP
Local time
Today, 13:24
Joined
Jan 14, 2017
Messages
13,955
Attachments to posts#2 & #3 have belatedly been approved almost 2 years on.
As nobody reported these items, it is only by chance that mods will see them.
 
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom