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, 18:43
Joined
Mar 31, 2017
Messages
543
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

murray83

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

murray83

Games Collector
Local time
Today, 18:43
Joined
Mar 31, 2017
Messages
543
updated once again

new functions added

*email report for each shift

and have trimmed away tables not needed
 

Attachments

isladogs

CID Moderator
Staff member
Local time
Today, 18:43
Joined
Jan 14, 2017
Messages
13,140
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 (Users: 0, Guests: 1)

Top Bottom