Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Closed Thread
 
Thread Tools Rate Thread Display Modes
Old 03-10-2018, 12:05 PM   #1
murray83
sega collector
 
Join Date: Mar 2017
Location: Daventry, UK
Posts: 446
Thanks: 108
Thanked 1 Time in 1 Post
murray83 is on a distinguished road
A Handover Database for 3 Depts & Hidden Systems or Managers Page

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
Attached Files
File Type: zip Handover Database Guide.zip (430.1 KB, 437 views)
File Type: zip Handover Database - Example.zip (277.8 KB, 585 views)

murray83 is offline  
Old 03-11-2018, 02:53 AM   #2
murray83
sega collector
 
Join Date: Mar 2017
Location: Daventry, UK
Posts: 446
Thanks: 108
Thanked 1 Time in 1 Post
murray83 is on a distinguished road
Re: A Handover Database for 3 Depts & Hidden Systems or Managers Page

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
Attached Files
File Type: zip Handover Database - Example v2.zip (301.3 KB, 12 views)
murray83 is offline  
Old 03-19-2018, 02:52 AM   #3
murray83
sega collector
 
Join Date: Mar 2017
Location: Daventry, UK
Posts: 446
Thanks: 108
Thanked 1 Time in 1 Post
murray83 is on a distinguished road
Re: A Handover Database for 3 Depts & Hidden Systems or Managers Page

updated once again

new functions added

*email report for each shift

and have trimmed away tables not needed
Attached Files
File Type: zip Handover_Databasev2.zip (289.3 KB, 19 views)

murray83 is offline  
Old 11-30-2019, 10:37 AM   #4
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,233
Thanks: 115
Thanked 3,072 Times in 2,790 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: A Handover Database for 3 Depts & Hidden Systems or Managers Page

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.

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline  
Closed Thread

Tags
handover , warehouse

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Employee Database/Managers and departments sladetroityer General 2 02-01-2012 10:52 AM
Automate different document numberring for different depts? pradaloh Modules & VBA 1 07-01-2007 11:22 PM
Other Database Systems mis General 2 05-17-2004 04:21 AM
2 Freeware Database systems PaddyIrishMan General 0 04-25-2003 03:48 AM
Handover Documentation mark curtis General 2 06-13-2002 10:15 AM




All times are GMT -8. The time now is 12:05 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World