i have a database that is going to be shared across a network server. What i would like(if possible).
USER 1 has opened up the Microsoft Access database and has spent 15 Minutes entering information. USER 2 then goes to open the same database, but gets a message saying something along the lines of "Database already in use, please try again later.
NAME START TIME STOP TIME J SMITH 12:00:00 AM 6:00:00 AM S SMITH 3:00:00 AM 7:00:00 AM Z SMITH 5:00:00 AM 1:00:00 PM
I want to calculate how many people work per interval of half an hour. From this example, the results should be:
12:00:00 AM 1 12:30:00 AM 1 1:00:00 AM 1 1:30:00 AM 1 2:00:00 AM 1 2:30:00 AM 1 3:00:00 AM 2 3:30:00 AM 2 ................... 5:00:00 AM 3 5:30:00 AM 3 6:00:00 AM 2
I'm looking for a way to do this. Ultimately, I'm trying to automate scheduled hours in a way that I can produce an IDP (Intra-Day Performance Report). I work in a call center, but unfortunately, we do not have any Workforce Software as of yet. If anyone has any suggestions, I would greatly appreciate it.
Hi, I am just learning Access and are having problems dealing with time intervals. My database form is seperated into two tables and in each column of the tables there are different time periods. The time periods are created by having two columns and one column is the start time while the second column is the end time.The problem is that in order to tie the two database together i have to group the database use the time periods as a key. But since the two tables time periods are different, i have to first seperate time intervals to specific months. My plan first is that using queries, i will insert new rows and in those columns i will have both the start month column to end month column both be the same month, but i could never figure out how to duplicate my information and change only the month. Now i am at a loss and i really need help for the project. I am sorry for the poorly worded explanation but i can't think of a easier way to say it. Please advise me on what to do and thank you for reading.
I have an attendance database and I connect the time attendance machine db to my access db, what i am trying to do is to generate a report that shows the time in and time out for specific date. the type of attendance db is date/time.
Please see the attached screenshot db from attendance machine.
an also some time there is duplicate entry, I need to get the first and the last entry only for specific date.
I need to create or adapt from a similar database a means to capture time (labor) spent on projects. I've searched for this topic, but have come up empty. Perhaps I'm just not searching on the correct search terminology. Here are the basic requirements:
One department can have many employees, but each employee is a member of only one department. An employee can be transferred from one department to another, and records created when the employee was a member of department 1 need to be retained under that department, while records created after the employee has been transferred to department 2 need to be recorded as such.
Projects can be worked on by any employee in any department. Many employees can work on any project.
Employees need to log in to the database daily and report the time spent on each project. A list of all projects needs to be displayed with the ability to enter the number of hours spent on each.
Reporting to include grouping of employees into departments; time spent by a department in total on each project; who worked on which project and total time spent.
There is a management shakeup here and I'm under a lot of pressure to get this done. I've done a very simple database, but nothing as complex as this.
I am setting up a database to help me prepare codes for employees timesheets in order to upload them into our payroll software. The table structure below is just my preliminary thoughts and current ideas and I guess I'm looking for ideas on how to work with my codes.
EMPLOYEE TABLE EmpID (PK) - Employee ID # [Autonumber] Surname - Employee's surname [Text] Firstname - Employee's first name [Text]
ATTENDANCE TABLE ShiftID (PK) - Shift ID# [Autonumber] EmpID (SK) - Employee ID# [Foreign Key] Date - Date of shift [Date/Time] Start - Start time of shift [Time] Finish - Finish time of shift [Time] CostCtr - Cost centre being billed for shift. [Integer]
When employees work they are entitled to the following: * Ordinary hours (code 001) for all hours worked. * 10% penalty (code 006) for all hours worked when shift finishes after 18:00 * 12% penalty (code 007) for all hours when shift crosses midnight * 50% penalty (code 008) for hours worked on a saturday * 100% penalty (code 009) for hours worked on a sunday
The following shows data that in my Attendance table for an employee who worked shifts on the 16th (Mon), 17th (Tue), 20th (Fri), and 22nd (Sun). ShiftIDEmpIDDateStartFinishCostCtr 18443416/10/0610:0019:00 28443417/10/0610:0019:003002 38443420/10/0622:0006:003001 48443422/10/0614:0022:00 From the above data I believe I will need to make another table that contains the entitlement codes generate from each shift.
For the first shift on Monday 16/10/06 I need to collect the following codes for the total calculation: CodeHoursCostCtr 0019.00 0069.00
For the second shift on Tuesday 17/10/06 I need to collect the following codes for the total calculation: CodeHoursCostCtr 0019.003002 0069.003002
For the third shift on Friday 20/10/06 I need to collect the following codes for the total calculation: CodeHoursCostCtr 0018.003001 'Ordinary hours worked 0078.003001 '12% penalty as shift crossed midnight hour 0086.003001 'Only worked 6 actual hours on the Saturday as 2 hours were on Friday night.
For the fourth shift on Sunday 22/10/06 I need to collect the following codes for the total calculation: CodeHoursCostCtr 0018.00'Ordinary hours worked 0098.00'Hours worked on the Sunday
From that information the only data I really need to store in a table would be the totals grouped by code and cost centre. Eg., CodeHoursCostCtr 00117.00 001 8.003001 001 9.003002 006 9.00 006 9.003002 007 8.003001 008 6.003001 009 8.00 Does anyone know the best way to go about this? Should I generate a new table that links these codes to an employee? Should I make a function to calculate the codes for each day and store them in a table or make the function only sum the code totals for the week and store them in a table?
I have finally completed my database project. It is a split database. Back End on a network server.
I want to distribute the front end to all users however I want to limit to the best I can what they can do to it. Can someone please advise me on the best way to wrap up and send out my front ends?
All security has been established. I am talking about the availability to see the tables, macros, control bars etc..
I have on MS Access database.which was working fine untill now but suddenly it started this strange behaviour. When i open it it opens without any error but stays in the frozen state for like 5 mins means i cant do any thing or i cant click anywhere.
and after 5 mins it starts working fine.Does anyone have any clue abt this strange behaviour.
Does anyone have a US zip code - time zone table or tables? I have been unable to find this data online without paying 150.00. I need this for a web application that i am doing.
Hi, I created a database where everybody should insert his holiday plans and absence of business. the Database is linked and opens automatically the form when you click on the link on the pdf. But know it is not possible anymore that more than one person opens the file to insert the data. The mistake is: Could not lock file! What do I have to do that more people can use the database at the same time (not only read-only) Thank you for the help
There are between 10 - 15 users at one time. It is a shared network, the front_end is on individual hardrives and the tables are located on the server. We just converted to Access 2003, our data file size is 47kb.
Users who are not active in the database get disk or network error message and have to close out. Is idle time a possible factor? Some users maybe entering information sporadically through out the day, but need to have the database open, they may need to refer to a member record upon receiving a phone call.
I am currently preparing a time tracker in my office where there are similar task assigned to different users.
I created a form and split it for front end user and back end user. front end database was copied by each user in their local. However problem is that whenever a front end user update their database it is also reflected in other users database. Is their anyway front end user can see their database only....
how do you loop through and insert selected data from a listbox on at a time?For example, lets say you have an insert statement that has a firstname, lastname, CarsID(foreign key) and address field. Lets say you had another table that has ID and CarsID(primary key) field. In the listbox, you have populated it with all the cars and they are selected.
Example:
INSERT INTO PEOPLE(firstname, lastname, CarsID) VALUES('John','Smith','Honda') INSERT INTO PEOPLE(firstname, lastname, CarsID) VALUES('John','Smith','FORD')
I have a database for managing time related contracts.
I need to be able to run parameter queries but if I query the data by start date then and contracts which are current but started before the first date entered in the query (this is the same for end dates) are not shown.
I'm working on a database with a form input to record my time on projects at work. How to split End Time - Start Time among all brands that I've chosen for a line item?
I have an access database and I plan on splitting it so the FE will be on each users workstation and the backend will be in a folder on the server. But is there anything else I need to do to allow for the possibility of multiple users using the database and changing info at the same time?
I have a database I built for my employers that is accessed by up to as many as 50 users at one time. It is a relational database. I did a compact and repair this morning which changed the BE from 215MB to 45MB. I went to lunch and came back and the database is now 58MB. Does anyone have any ideas as to why it has increased by 13MB within an hour? There is no way this is caused by geniune data records.
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.
The link works fine but the time formats are different.
On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format
However on PC 2, opening the same database via the network, the time format is still shorttime but when you read the time within the code it comes out in AM/PM format. Also, when the defaul tiem should be #20:00:00# but this changes to #8:00:00 PM#
Weirdly though, when you just open the table, the times are in the correct shorttime format.
Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?
Twice a year, a database of mine is accessed and put too use by various staff within a time range of 1 week. the database is on a shared drive and in a location which can be accessed by all.
The staff access the database from different workstations and in some instances at the same time.
This has only led to issues in the database being copied and then confusing staff on what database to click on thus i have 2 databases which i then have to sift through and copy/paste into the correct one.
I want to know the best way i can:
1) Prevent multiple users accessing the database at a time. 2) making a copy of the original and typing into a separate database.