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, 09:18
Joined
Mar 31, 2017
Messages
728
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: 994
  • Handover Database - Example.zip
    277.8 KB · Views: 1,119

murray83

Games Collector
Local time
Today, 09:18
Joined
Mar 31, 2017
Messages
728
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: 415

murray83

Games Collector
Local time
Today, 09:18
Joined
Mar 31, 2017
Messages
728
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: 564

isladogs

MVP / VIP
Local time
Today, 09:18
Joined
Jan 14, 2017
Messages
18,186
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