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

 
Reply
 
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: 359
Thanks: 67
Thanked 0 Times in 0 Posts
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, 263 views)
File Type: zip Handover Database - Example.zip (277.8 KB, 373 views)

murray83 is offline   Reply With Quote
Old 03-11-2018, 02:53 AM   #2
murray83
sega collector
 
Join Date: Mar 2017
Location: Daventry, UK
Posts: 359
Thanks: 67
Thanked 0 Times in 0 Posts
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
Attachments Pending Approval
File Type: zip Handover Database - Example v2.zip
murray83 is offline   Reply With Quote
Old 03-19-2018, 02:52 AM   #3
murray83
sega collector
 
Join Date: Mar 2017
Location: Daventry, UK
Posts: 359
Thanks: 67
Thanked 0 Times in 0 Posts
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
Attachments Pending Approval
File Type: zip Handover_Databasev2.zip

murray83 is offline   Reply With Quote
Old 10-26-2018, 11:14 PM   #4
niranjanprajapati23
Newly Registered User
 
Join Date: Oct 2018
Posts: 1
Thanks: 9
Thanked 0 Times in 0 Posts
niranjanprajapati23 is on a distinguished road
Re: A Handover Database for 3 Depts & Hidden Systems or Managers Page

Quote:
Originally Posted by murray83 View Post
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

niranjanprajapati23 is offline   Reply With Quote
Reply

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 06:16 AM.


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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World