You are here:

Visual Basic/MSAccess Database Overlapping Schedule


I am not a programmer, just some knowledge of access. I have created a access data base for temp schedule. Table is Employee signups. Employees signup for this in advance for seven days and can sign up for overlapping time for the same day. In my table I have columns Date, Start Time, End Time, Employee Name, Location  (Which we enter when we want to approve the schedule). We down load the file from work site to this data base with all the columns except for location. When user goes to approve this temp schedule user only approves just by adding location. Location goes in to the same table where we have the signups. This is being done using form. Since there are over 2000 records. When user approves one line for Employee 'John' and next time goes to approve another (Or to add location) line for the same person If there is a conflicting with previous start or end time that user have approved previously. I need user to get a message that there is a conflict in time with previous approval (We are Not entering Start and end time it is already in the signup table). I want user to Get the Message that there is a conflict with previous line and delete the location from the table and move to next record
How can I do this?
Can you help?
I would appreciate your help.

the solution lies in design of your database.
first have a table with name along with his details. then you add another table with Name
(source being the original table) and add fields like location, start time, end these.
when the employee enters his startup and endup times, they will be stored in the second table, sorted by name and startuptime. this will take repetitions and no problem of overlap.
you can create a query based on this table showing total time logged each day etc.
when you view the report (if needed) you can link both tables on name .

good luck

Visual Basic

All Answers

Answers by Expert:

Ask Experts




visual basic application programming from design to access information, sql, engineering and commercial applications. access databases, excel.(VB6) basic questions in vb 2008. Optional: 1)a large number of people want me to do work which takes some time and effort. can do projects in vb 2008. Pl.note that i would like to be paid for such work. 2) if you want me to spend quality time and do special work, i expect to be paid a reasonable price for my time. 3) if you are pleased with my reply you could consider a good amount. 4) you can visit my website


programming since the past 15 years. have completed a large number of projects in Industrial applications, finance,accounts, correspondence. excel macros etc

engineering, management degrees.

Past/Present Clients
project work for a Norway company,USA company and a Canadian company completed. Freelance Project work and Teaching. helping programmers with their work
teaching vb

©2016 All rights reserved.