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

[murray83]

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

 

[murray83]

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

=Now()-1

and second one has this

=Left([DateNight],10)

and just slight change to SQL and bobs your uncle

 

[murray83]

updated once again

new functions added

*email report for each shift

and have trimmed away tables not needed

 

[isladogs]

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.