Realtime Clock

Time Clock / Punch Clock App
Has anyone created a time clock Access application?

I'm referring to a app that will allow the user to sign-in at the beginning of the day then sign-out for lunch, sign back in then sign out at close of business. Then be able to total the number of hours at work.

I've searched the forum and see others have asked the question in the distant past, but have found no answers.

What I'm 'hoping' for is that someone has a sample app they are willing to share so others can see how to set this up.

Thanks in advance for any help or suggestions.

rickyT

View Replies !

---

Realtime Data
I am trying to update an Access 2000 Database used by our Shipping Dept. The Shipper currently runs 3 Queries to populate 3 local tables with data from a SQL Server 2000 database used by our production process, he then will run another query that populates another local table with the data from the 3 local tables. His next step is to open a form where he scans a barcode from a label on the finish material tote to field #1 that is a Select Query. This allows for minimal scanning in the load makeup routine. The problem is that the data is not realtime and he must periodically refresh the tables. I need to find a way to use the linked tables to provide near Realtime data.

(Existing Barcode field1)
SELECT DISTINCTROW ProductionTable.BatchNo, ProductionTable.CmpdNo, ProductionTable.Recipe, ProductionTable.CustomerID, ProductionTable.Gross, ProductionTable.Tare, ProductionTable.Net, ProductionTable.expires, ProductionTable.PartNo,
ProductionTable.PONo FROM ProductionTable ORDER BY ProductionTable.BatchNo;

(Trial 1 – It Works for 1 production line only)
SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff1.BatchNo, Dbo_Mixed_Material_Batchoff1.CmpdNo, Dbo_Mixed_Material_Batchoff1.Recipe, Dbo_Mixed_Material_Batchoff1.CustomerID, Dbo_Mixed_Material_Batchoff1.Gross, Dbo_Mixed_Material_Batchoff1.Tare, Dbo_Mixed_Material_Batchoff1.Net, Dbo_Mixed_Material_Batchoff1.expires, Dbo_Mixed_Material_Batchoff1.PartNo, Dbo_Mixed_Material_Batchoff1.PONo FROM Dbo_Mixed_Material_Batchoff1 ORDER BY Dbo_Mixed_Material_Batchoff1.BatchNo;

(Trial 2 – Does Not Work)
SELECT DISTINCTROW
dbo_Mixed_Material_Batchoff1.BatchNo, dbo_Mixed_Material_Batchoff3.BatchNo,
dbo_Mixed_Material_Batchoff4.BatchNo, dbo_Mixed_Material_Batchoff1.CmpdNo,
dbo_Mixed_Material_Batchoff3.CmpdNo, dbo_Mixed_Material_Batchoff4.CmpdNo,
dbo_Mixed_Material_Batchoff1.Recipe, dbo_Mixed_Material_Batchoff3.Recipe,
dbo_Mixed_Material_Batchoff4.Recipe, dbo_Mixed_Material_Batchoff1.CustomerID,
dbo_Mixed_Material_Batchoff3.CustomerID, dbo_Mixed_Material_Batchoff4.CustomerID,
dbo_Mixed_Material_Batchoff1.Gross, dbo_Mixed_Material_Batchoff3.Gross, dbo_Mixed_Material_Batchoff4.Gross, dbo_Mixed_Material_Batchoff1.Tare, dbo_Mixed_Material_Batchoff3.Tare, dbo_Mixed_Material_Batchoff4.Tare,
dbo_Mixed_Material_Batchoff1.Net, dbo_Mixed_Material_Batchoff3.Net,
dbo_Mixed_Material_Batchoff4.Net, dbo_Mixed_Material_Batchoff1.expires, dbo_Mixed_Material_Batchoff3.expires, dbo_Mixed_Material_Batchoff4.expires,
dbo_Mixed_Material_Batchoff1.PartNo, dbo_Mixed_Material_Batchoff3.PartNo,
dbo_Mixed_Material_Batchoff4.PartNo, dbo_Mixed_Material_Batchoff1.PONo, dbo_Mixed_Material_Batchoff3.PONo, dbo_Mixed_Material_Batchoff4.PONo
FROM dbo_Mixed_Material_Batchoff1, dbo_Mixed_Material_Batchoff3, dbo_Mixed_Material_Batchoff4 ORDER BY dbo_Mixed_Material_Batchoff1.BatchNo, dbo_Mixed_Material_Batchoff3.BatchNo, dbo_Mixed_Material_Batchoff4.BatchNo;



(Trial 2 Does Not Work)
SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff1.BatchNo, Dbo_Mixed_Material_Batchoff1.CmpdNo, Dbo_Mixed_Material_Batchoff1.Recipe, Dbo_Mixed_Material_Batchoff1.CustomerID, Dbo_Mixed_Material_Batchoff1.Gross, Dbo_Mixed_Material_Batchoff1.Tare, Dbo_Mixed_Material_Batchoff1.Net, Dbo_Mixed_Material_Batchoff1.expires, Dbo_Mixed_Material_Batchoff1.PartNo, Dbo_Mixed_Material_Batchoff1.PONo FROM Dbo_Mixed_Material_Batchoff1 ORDER BY Dbo_Mixed_Material_Batchoff1.BatchNo; SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff3.BatchNo, Dbo_Mixed_Material_Batchoff3.CmpdNo, Dbo_Mixed_Material_Batchoff3.Recipe, Dbo_Mixed_Material_Batchoff3.CustomerID, Dbo_Mixed_Material_Batchoff3.Gross, Dbo_Mixed_Material_Batchoff3.Tare, Dbo_Mixed_Material_Batchoff3.Net, Dbo_Mixed_Material_Batchoff3.expires, Dbo_Mixed_Material_Batchoff3.PartNo, Dbo_Mixed_Material_Batchoff3.PONo FROM Dbo_Mixed_Material_Batchoff3 ORDER BY Dbo_Mixed_Material_Batchoff3.BatchNo; SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff4.BatchNo, Dbo_Mixed_Material_Batchoff4.CmpdNo, Dbo_Mixed_Material_Batchoff4.Recipe, Dbo_Mixed_Material_Batchoff4.CustomerID, Dbo_Mixed_Material_Batchoff4.Gross, Dbo_Mixed_Material_Batchoff4.Tare, Dbo_Mixed_Material_Batchoff4.Net, Dbo_Mixed_Material_Batchoff4.expires, Dbo_Mixed_Material_Batchoff4.PartNo, Dbo_Mixed_Material_Batchoff4.PONo FROM Dbo_Mixed_Material_Batchoff4 ORDER BY Dbo_Mixed_Material_Batchoff4.BatchNo;

Anyone have any ideas?

Many thanks in advance to all responders

Bob

View Replies !

---

Hiding Columns Realtime In Subform
Hello!

The problem at hand for me is to be able to hide columns in a subform wherever "#Name?" appears. My VBA experience is minimal to non-existent, but if a not so complex sample code exists out there then I'd appreciate any suggestions you may have.

I have attached a print screen document that shows the result of a query in the subform I just talked about. My anticipated thanks for your help.

View Replies !

---

How To Make Automatic Refresh / Realtime Form Datasheet
fyi : database use SQL Server 2000 ,frond end use Ms.Access 2000 and allready use with multi user

the problem is :
I want to automatic refresh / realtime form datasheet, if the data allready changed, deleted or add new.

I try to solve it with
1. timer event + requery but i thing it's not a good idea because if data not changes, the form will be allways requery.

2.I use winsock so every user change the data, the will be send an event and i use arrived event to refresh form datasheet. And it's not solve the problem again because prosedure save/add data is more slow than event send data with winsock.

so guys , plx help me to solve the problem.


thx
Esugiawan

View Replies !

---

Analoge Clock
can you get an analoge clock on a form?

if so, how??

View Replies !

---

Time Clock App In Access
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 Replies !

---

Sync With Computer Clock
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 Replies !

---

Anolog Clock Needed
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 Replies !

---

Employee Punch Clock
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 !

---

Table Design For A Clock Card System
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 Replies !

---

Adding A Simple Text Clock To A Form
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 Replies !

---

Add Live Time Clock Using Activex, Just Calindar In MS Access
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 Replies !

---

Time Management - Simple Time Clock
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 Replies !

---