Employee Punch Clock

Jun 13, 2007

The company I work for has a central office and out employees work at different locations around the city. I have setup a database so that reports and requests made by employees are put into the database and sent to our office and clients office, instead of the tri copy forms we have been using. One thing that we were interested in doing was setting up a punch clock in the database so when employees come and go they punch in and out and there is a report that can be printed weekly or biweekly. Unfortunately I have no idea how to start making that feature, I would appreciate any help or advice on what direction to go...

View Replies


ADVERTISEMENT

Creating Employee Clock In / Out Application

Mar 4, 2012

I'm trying to create a database whereby employees within a business can select their name, or scan the barcode on their ID badges, to clock in and out of work.

View 2 Replies View Related

Realtime Clock

Sep 5, 2005

I've got 5 time zones showing on the main screen of my db, just by doing date() and subtracting number of hours for each time zone. Only problem is need a refresh button on it for people to click. Can you get a realtime clock ticking away on an access form?

View 1 Replies View Related

Analoge Clock

Jun 12, 2006

can you get an analoge clock on a form?

if so, how??

View 1 Replies View Related

Time Clock App In Access

Jun 6, 2005

Has anyone ever made a time clock application in Access? If so, can you post a sample application? I'm really at a loss with this one..

Thanks,
Cran56

View 4 Replies View Related

Sync With Computer Clock

Jan 18, 2006

Hi,

My question is...is there any way to get Access to work out the actual day of the week from a date entered into the computer? The reason for this is...I am designing and implimenting a bookings data base for a village hall, and I wish access to automatically store what day of the week it will be on the specified date, in a field called 'Day'. I need this field to produce a report for the week ahead, showing exactly what is in on which day of the week. Is there any way this can be done? Or do the days just have to be typed in manually, i.e. check a calendar and type them in? I would appreciate it if anyone could give me info...on ANY way this can be implimented...be it store the dates in a table or use a giant Iif statement or whatever! And the tags necessary would be helpful,

Thank-you for your help in advance, and i apologise for such a lengthy post!

Please get in touch directly through c.majury@ntlworld.com or alternatively post the answer here.

Chris

View 6 Replies View Related

Anolog Clock Needed

Sep 10, 2004

Do you happen to know if I can get my hands on an anolog style clock to put on my form in Access?

Thanks in advance - John

View 1 Replies View Related

Table Design For A Clock Card System

Jan 8, 2005

i'm try to create a database to record staff sign in and out times and to get reports but i cannot for the life of me get it working after many many efforts. can any one help me?

View 2 Replies View Related

Adding A Simple Text Clock To A Form

Apr 19, 2005

Trying to make a simple clock inside my form.
So far I got my clock but it isn't running.
It only get's the time when I open the form but I want it to keep track of time.

Searched the forums but couldn't find anything that relates to this problem.

View 9 Replies View Related

General :: Create Time Clock Button?

Aug 20, 2012

I want to create a toggle button (On/Off), that can show time clock on button. Click to start time, click again to stop time.

View 4 Replies View Related

Add Windows Widget Like Clock To Access Form

Mar 16, 2014

Can we add windows gadgets like clock and calender to access form?

View 6 Replies View Related

Add Live Time Clock Using Activex, Just Calindar In MS Access

Mar 6, 2008

Since you can add Calindar in access using activex so that I can select any date and pass that on to a field in a form, is there any way you can add a clock using activex so that I can select any time that I want to put in to a field? any suggestion? Thanks.

View 2 Replies View Related

Forms :: Time Clock - Referencing Subforms On Navigation Form

Jan 15, 2014

I have a complete working timeclock and trying to add the forms within the navigation form. I know I have to go back and re-reference everything and have already done so with the queries. But I cannot get the setfocus to work.

Here is the setup.

NavigationForm (navigation form)
frmClockIn (top form)
frmClockIn_SUB (bottom form)
Open Navigation > Time Clock.
Select an EmployeeID from the dropdown
Click on clock in. (successful)
cboEmployeID goes blank and try selecting the same employeeID to clock out and I get a debug at

Me.frmClockIn_SUB.SetFocus

I think there is a problem with my cboEmployeeID_AfterUpdate() as well.(related?) which used to be
Private Sub cboEmployeeID_AfterUpdate()
me.refresh
End Sub

I have replaced "me.refresh" with "Me.frmClockIn_SUB.Form.Refresh"

(It used to break here, but not after I changed it.)

Not too sure where to set these forms to in the code

I have attached a blank copy ....

View 3 Replies View Related

Queries :: Grab Custom Fiscal Year Count Based On System Clock Date

Aug 13, 2015

How do you grab a custom Fiscal Year's values based on the system clock's date?

I am building a query where I want to see the number of closed cases based on the current custom fiscal year with the system clocks date. The report that it feeds only cares about the current FY.

I need the System Clock's FY value in this query

Code:
SELECT shortname AS Station, NZ(TotalCount.TotalCases,0) AS [Cases Complete]
FROM StationList LEFT JOIN (SELECT station, count([Open Issues].ID) AS TotalCases FROM [Open Issues] WHERE [Status]="Closed" GROUP BY Station) AS TotalCount ON StationList.shortname =TotalCount.station;

Within the Query Open Issues I have the FY broken up

Code:
fiscalYear: IIf(Month([Issues].[Opened Date])>=10,"FY" & Year(DateAdd("yyyy",1,[Issues].[Opened Date])),"FY" & Year([Issues].[Opened Date]))

View 4 Replies View Related

Time Management - Simple Time Clock

Jan 9, 2006

Hi all, I havent' been around in a while (toddler, work, getting my BS degree and new baby coming in a week and a half) so I am hopefully not asking a previously posted question.

I'm suspecting my new work isn't accurately paying for the hours worked. I made a quick simple DB where I input my punch times in short time format. There's the typical In, Out for Lunch, In from Lunch, and Out. I've got it correctly adding the times so that it reports the total hours worked per day, though, in order for it to display correctly, that total is in short time as well.

The problem is, when I group a week together, as soon as the sum of the totals reaches 24 or more, it goes back to 0, as it's on the idea that there's only 24 hours in a day.

Hopefully, it's just a formatting issue or is there a function to convert the times (or just the sum) to number of hours?

Thanks and Happy New Year to all.

-Jim

View 2 Replies View Related

Access Employee DB

Oct 15, 2005

Is anybody out there kind enough to post a good head start sample db for managing employees with photo included in form and in report.

Would appreciate any help and thanks,
cagay

View 8 Replies View Related

Employee Record

Feb 4, 2008

Hi all, I am looking for an employee record template for data including sickness, vacation, skills, CVs etc. I would have thought there would be loads available but alas, I can find none

Can anybody point me in the right direction please.

Thanks in advance
Rob

View 4 Replies View Related

Employee Compensation

Aug 9, 2005

Trying to setup a database to track employee compensation and need some advise on the setup. I was told in a previous post to normalize my tables which I think I've done. I would just like some other input on this to know if I've done it right.

I created a table called Employees with the following fields: autonumber id field, firstname, lastname, department, position, hiredate.

Next I am creating a new table for each year which will contain the following tables: autonumber id, base, bonus, addbonus, overtimecomm, car, 401kcon.

The autonumber ID fields in each table have been set as the primary keys and I've setup a relationship between Employees and each of the compensation tables.

Does this sound like it will work? Or do I need to go back and rethink some of the process?

View 6 Replies View Related

Employee Quit?

Dec 15, 2005

I have a form which has a drop down box which links to a table with Employee names. One employee quit and I want to delete her name from the table. But... if I do that, I will delete her entirely from all previous records. Is there a way to keep all previous records, but take her out of the drop down choices?

View 2 Replies View Related

Employee Payroll

Oct 28, 2005

I'm trying to use a query to calculate the payroll for all the employees but it won't work. The two tables I have are 'Employees' and 'Employee Payroll'. In the 'Employee Payroll' table there are three fields- Employee ID, Days worked and Earnings. I need to calculate the sum of the earnings field but it just displays a blank list of records when I try it.
Can anyone help?
Thanks

View 6 Replies View Related

Employee Database

Sep 22, 2006

I'm trying to create a database in Access to track various employee data for the company I work for. We have about 44 employees. There are about 7 different groups of data our poor secretary now has to keep up with. These include: a list of the employees, with name, address, phone, etc. A handmade form with salary information like current wage, raises and when they were given, etc. A bonus section, how much and when. A list with attendance information including tracking missed days and tardies. A list of temporary employees and when their incremental reviews are due. There are other lists we use and others we are thinking of starting having to do with training, etc. It’s too much to keep up with manually now.
One of my questions is: can there be one table with the basic employee information that other tables can access without having to enter the same names again into other tables? (Why enter all those names more than once)? My other question has to do with linking tables together, I just can’t seem to grasp the concept even after reading two Access training books on the subject. I made a simpler database for another project and gave up on linking tables and the database seems to work just fine.
Any help is appreciated and sorry for the long post.

View 3 Replies View Related

Add Employee Form

Apr 29, 2007

I have an Employees table. I have a form to Add Employee and a form to Remove Employee. Remove Employee works great. It's a drop down box, they select the employee and click on remove. With Add Employee, I have a textbox where they enter the name and a button to add that employee to the database. I setup a VBA script to take the value in the textbox labled "empname" and insert it into the Employees table when the button is clicked through the onClick event.

Is there an easy way to do this? I need the UI to be simple. I know you can bound the textbox to the employee name, but then when they open up the form it will show all the records and they have to click the new record button to add someone. I know this question was asked very recently, but it wasn't answered very well.

I have the db attached. It's in Access 2003 format. The macro in there is the VBA script that I wrote, so don't worry, it's not harmful. I'm very good with SQL, and I would've chosen to use ASP for the user interface, but the people that need this don't want to run any servers (IIS). They just need a file they can double click on and work from there.

Thanks

View 3 Replies View Related

Multiple Users And Employee ID's

Jun 6, 2005

I am nearly ready to release my ACCESS 2000 database to 150 employees in our office (client/server network). However I have two problems, I have looked through countless posts and cant find exacly what Im looking for.

ACCESS automatically defaults to each individuals network ID when it is opened, so I have set that as UserName for each user, I have created a UserDetails table with this netowrk ID as a primary key, linking that as a foreign key to various OrderDetails tables. My question is how on earth can I get ACCESS to automatically enter this UserName onto each order a particular user makes? to be able to run queries for specific users etc? I dont want the user to be able to manually type in this because it can compromise the integrity of our data.

secondly, what is the best way to set up the FE, BE situation on our network? I tried the wizard and it gets a bit technical

Cheers for the help and congrats to a very helpful site,
Russ :)

View 10 Replies View Related

Advanced Employee Schedule

Jul 4, 2006

Hello Everyone
I need to make an employee schedule in access. I am not sure if it is possible, but here are my constraints:

20 employees

5-6 different truck locations (sm1, sm2, sm3, sm4, sm5, sm6) These locations are scattered within our service area.

2 employees must meet at the same truck, (each truck has 2 employees working on it)

some employees can only meet at certain locations (ex. paul can meet at either sm2 or sm3)

all employees are PT so they can only work on certain days or a certain amount of days per week. (ex. paul can work up to 4 days a week and jim can work only sat and fri)

I would like to make a program in access that will take all these factors into consideration. EX. if i try to schedule paul on sm4 the program will not let me do it or it will give a warning or if i try to schedule paul for 5 days it will give me a warning.
It would also be great to have a counter that will show how many days each employee has left to be scheduled for, EX: if i scheduled paul for 2 days it will show that he can actually work 2 days more if i need him to.

I know this might be a lot, but i also know there are so many talented people here so i am sure it is feasible. Please let me know if you know how to do this or if you could guide me through it.

or if you know about a different program that can solve this please let me know
Thanks in advance

View 2 Replies View Related

Tracking Employee Training

Aug 18, 2006

I am tracking training for employees. I have a database that keeps track of the dates a particular training was taken. Employee training is ongoing from year to year. I have an Employee Training with a subform showing only the specific employee's training. I need a help with a few things. I need to keep track of training by the year. If I enter 2006 dates it will show in one line, if 2007 dates, another, all the way across the list of training classes for an employee. I also only want to limit a person enter more than one date for a particular class for a calendar year...Are these things possible. I have attached the database. Please help, make changes and suggestions. Thank you so much in advance.:eek:

View 3 Replies View Related

Employee Scheduling Database

Feb 24, 2008

Dear Access Expert.

I would like to create a Scheduling database for employees. The database would include:

- list all of the employees
-tabs to look at schedule for this week, 1 week from now, 2weeks from now, 3 weeks from now, long term (1-2 months), etc
-small comment section within each day for the guys to enter some comments...e.g. dentist at 10, holidays, etc

There has to be something like this already out there that I can modify and work with. Is there anything like this already in the NorthWind Database that comes with Access? What about some free examples Access developers made?

What about Outlook? Can I modify Outlook and use VBA somehow to accomplish this? Outlook is basically on an account basis so I don't know if I could tailor it to my 30+ employee database.

Thank you very much for your input.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved