Time Tracking System
I have a time tracking system where users can clock in and clock out. I want to have an error message when they clock in and then accidently clock in again. Therefore, they can only clock out after they have clocked in. The data goes into the table called "Timeclock Table". The fields in that table are SSN, Clock-In, Clock-Out, and TimeStamp. the clock in and clock out are check boxes. can you guys help me??????
View Complete Forum Thread with Replies
Related Forum Messages:
Help With Time Tracking System
I have a time tracking system where users can clock in and clock out. I want to have an error message when they clock in and then accidently clock in again. Therefore, they can only clock out after they have clocked in. The data goes into the table called "Timeclock Table". The fields in that table are SSN, Clock-In, Clock-Out, and TimeStamp. The clock in and clock out are check boxes. can you guys help me?????? Im just a beginner.
View Replies !
Help With Time Tracking System
I have a time tracking system where users can clock in and clock out. I want to have an error message when they clock in and then accidently clock in again. Therefore, they can only clock out after they have clocked in. The data goes into the table called "Timeclock Table". The fields in that table are SSN, Clock-In, Clock-Out, and TimeStamp. The clock in and clock out are check boxes. can you guys help me?????? Im just a beginner.
View Replies !
HRIS System - Tracking
I'm new at database and in the process of creating an HRIS system. I have all relevant employee information in an Employee table however, i want to know what is the best way to track employee history, such as increase in salary or dept changed etc? Its this done through forms? Please help and thank you in advance. Activ
View Replies !
Table Stucture Help - Tracking Varying Time Periods
Hello, I'm having a hard time trying to figure out how I should go about designing the table structure for the hours tracking for the database I'm working on. Basically, I have a table with projects (tblProj) that I need to track the number of labor hours worked per month. The problem lies in the fact that each project could have varying time periods, anywhere from less than a year to more than a year and can start and end at any time of the year. I was thinking of creating a second table (tblProjHours) to store the hours for the project but I'm not sure what the most efficient way of doing this would be. My idea was to create a table as follows: tblProjHours ProjHoursID (pk) ProjID (fk) BeginDate EndDate Month1 Month2 Month3, etc.... I would create a large number of fields/columns, something like Month1 to Month36 just to make sure I have enough months to enter in the hours. This is of course inefficient since some projects would be way shorter than the maximum allowed months set by the table structure and there is always the possibility of surpassing the maximum allowed months based on the table structure. I was wondering if someone had any better ideas on how I should pursue the design. Thanks in advance! TheMach
View Replies !
System Date And Time
Hello, I have a form that displays the system date and time for every entry. When the data gets stored in the table, the date and time do not get stored. How can i save the date and time with all the other information. Also, everyday when i open the form, it shows me all the data from the previous day but the date for all that data has changed to taday. I want that everyday when i open the form, it should be blank and all data from the previous day must be stored in the table along with the date and time. Hope someone can help me with this Thanks
View Replies !
Rnd Based Off System Time/date
Hey all, I'm trying to find a solution to a problem. Is there any way using VBA to generate a random number, based off the current system date and time? The theory is that a random number seeded by the system date/time will be truly unique and the possiblity of it ever occuring again will be nearly nil. Or is there a better way to create unique ID's (such as member ID's, or something similiar) based off the system date/time that can be used as a primary key in a relational db.
View Replies !
Employee Time Card System
I need to develope a system that will allow for employees to login and imput their "time card". I found one post on here about something similar, but it didn't give much info. I am very very new to Access so please give info in simple terms or very well explained. I am hoping that I can have a login and password so employees can't access eachothers time card. All it will need to track is Date Type of work Hours Rate Comments I am hoping that this is going to be an easy task, but I need some help. Anyone have any ideas or directions... or even better know where I could just download a template. Thanks, Chrissy
View Replies !
Time & Billing - Project Management System Upgrades
We'll it's been out for a while so now I'm gonna give people who use it or would like to use it the chance to have there say as to what goes into the next version.If you've got any idears for something that you think should be included with "I've Got Time To Bill Ya Now" nows your chance to have your say.Main Topic http://www.access-programmers.co.uk/forums/showthread.php?t=121117
View Replies !
Creating A Timer Event That Checks System Time?
I need a query run that brings up a list of customers that need maintence after 6 months after their last maintence service. As soon as you open the DB, the event/query runs and if there are any customers past due to display them. And if there are none, to not even show the query at all. I have very little experience with timers and if/then statements and don't know how to set this up. Any help would be greatly appreciated. Thanks in advance.
View Replies !
Comparing A Date/Time Field To System Date
Hi, I am trying to compare a value in my databse produced by the date() function, short date format, to one that is exactly 24 hours after the value recorded by the date() function. If the value in the database is 24 hours prior to the current date(), I need to flag a text box a diffrent color to alert the user. I am unsure on the If statement that I will need to produce this result. Any help would be greatly appreciated!!!! Thanks Mikeco555
View Replies !
Time Format - Short Time Displayed As Medium Time
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? Any ideas? This screen shot may help:
View Replies !
Time Format - Short Time Displayed As Medium Time
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 short time but the format is in AM/PM or medium time. Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances? Any ideas?
View Replies !
Project Tracking??
Don't know if this is the correct forum, but.... Does anyone know of a relatively inexpensive (maybe even free???) Project / request tracking system written in either Access or VB? I ;ooked and looked on the forums here, but couldn't find a thing. If anyone will just point me in a hopefully good direction, I would be grateful. Thank you!
View Replies !
Compliance Tracking
Hello. Does anyone know of a good sample database that can assist me with understandig the logic behind building a compliance tracking system? I have a need to keep track of customers who are required to submit certain documents at certain times. I would like the program to maintain an archive of which documents have been submitted late (or not at all) in order to analyze trends.
View Replies !
Trade Tracking
I am very new to using access, so please just bare with me while I try to explain my situation as quickly and clearly as possible. This database I have been working on for about a month now is to keep track of all of these game figures I have. When new sets come out I trade off some of my extras to get ones that I need to complete sets. If you would be so kind as to download my database (http://www.box.net/public/pjonkjmicy) and take a peek this would be much easier to understand. On the main interface that opens there is a "TradeTrack" button to the right. When that opens you see 2 boxes, the one on the left should list all of the figures I have listed as trades in the database. Then I would like to move them over to the right box to be traded to the trader listed in the dropdown above. If anyone knows of a database example or anything that does something like this, Im sure I could make it work. I have done allot of searching and came up empty handed. Thank you for looking! ps Sorry, about the box.net link. The attachment loader on the forum said my file was too big. I hope this isnt a problem.
View Replies !
Training Tracking
Does anyone have a sample training tracking system / database they'd be willing to share? Or, barring that, can someone point me in the direction of where I might find one? Thanks in advance! Looking forward to it!
View Replies !
Tracking Training
Does anyone have a sample training tracking system / database they'd be willing to share? Or, barring that, can someone point me in the direction of where I might find one? Bee replied once, suggesting I look in the Samples Databases section of this forum, but I could not find anything even remotely related there. All replies are gretly appreciated!!
View Replies !
Tracking Training
I have a DB I'm using to track training for assigned people. Right now the training gets put in the DB at the end of the day by going through each persons record and adding the training that they did for the day. As you can see when training 30+ people a day, putting this in the system can take awhile. I'm trying to find a way to do a mass input to cut down time and could use some help with this. My tbls are as such, 1st Table:EMPLOYEEtbl EmployeeID EmployeeName (Other information) 2nd Table:CLASStbl className classID 3rd Table:CompleteClasstbl EmployeeID classID DateTaken What I like to do at the end of the is select the ClassID/DateTaken items once and then type in a just the 30+ list of employeeID's click a button and append it to the my 3rd table. Of course writing it out like this makes me think it should be easy but for some reason I'm lost. Does anybody have any suggestions?
View Replies !
Equipment Tracking Db
I need help finding an existing or making a db. This db does not have much to it, so I am getting frustrated finding/making one. My company has equipment that is stored in one of three places, customers, trucks of employees, and other(like warehouse, or out for repair). The db should be able to give me a report of where everything is on a given day, and a report of what was in a given customers property during the job(this is not for a single day, but for the duration of the job). If someone knows of an existing db like this, I would appreciate a link. If you want to help, it is appreciated. At this point I would not mind paying someone to do this for me, as long as it wont cost too much.
View Replies !
Tracking Synchronization
Is there any way in access 2003 or 07 to track when a database was last synchronized with any one of it's replicas? It would be useful to know and be able to store this in a table.
View Replies !
Bug Tracking Solution
Hi,I'm looking for a bug/issue tracking solution done entirely in MS Access. Does such a thing exist?My requirements are that it must need only Access, and be accessible in a shared environment solely by opening a .mdb file from a shared folder. It must support various issue lifecycle related things, and the stuff those tracking systems do in general.It may or may not be commercial software.If anyone knows of such an available solution, please let me know.(And yes, I've searched on Google, and haven't found anything worthwile, so that's why I'm asking here now.)thx
View Replies !
Need Better Tracking With My Tables
I have a DB thats working fine, but (there always is a but) I now need to do something a little bit different. I need to be able to track my originators and who they have brought into the company. So I will have an originator and many down-line originators, and these people that come in down-line will have people coming in down-line from them and so forth and so on. I have a table that has all originator info and originatorID, but will I need another table or can I just add to the exisisting one. Here is the table structure: Originators: ------------- OriginatorID -autoNumber FirstName - Text LastName- Text OrigSSN- Text Address- Text City- Text State- Text PostalCode- Text HomePhone- Text WorkPhone- Text CellPhone- Text FaxPhone- Text EmailName- Text BirthDate- Date/time Level- Text If more info is needed please let me Know.. Thanks in advance. Scott
View Replies !
Tracking Changes To Database
Is there a way to track changes made by different users to access tables? For instance if several users update or change data in various records is there a way to track when and what was changed (before and after data)?
View Replies !
Tracking Updates
I have read all of the audit trail stuff and searched on my subject but I think my solution could be simpler, All I want to do is copy the values of the current record on my form into a history table with all the same fields. Example Form: [ID], [Machine], [Task], [Task Due], [Task Complete] I want to put a button on the form that reads complete task and when the user pushes the button it copies all of the details for that specific record they are looking at into my History Table that contains all of the same fields. This will give me basic history on when each task was completed for a machine and I can access for reporting
View Replies !
Tracking Database Help
I consider myself an intermediate ACCESS user and can get around it with little trouble with the help of the internet and the help file. I am trying to design a database that is fairly simple in design, it is for tracking the status of documents at our work center. Basically we have personnel reports that are passed around the different people and different dates. I have a main form that has the info on the person along with dates that it is due. Then a sub form that has the date sent and where it went to. My problem lies in that I want to keep track of the whole history of the document but when i print out a report or export the data to excel to put up in powerpoint I need to have just the most recent date sent only item. I have 2 tables one with user info and another with the routing info with its own primary key along with a identifier key to link the primary and sub form. Of course it is easy to create a report with the data to show all the different routing steps but not just the one with the most recent date. Thanks in advance for the help.
View Replies !
Bug Tracking Solution
Hi, I'm looking for a bug/issue tracking solution done entirely in MS Access. Does such a thing exist? My requirements are that it must need only Access, and be accessible in a shared environment solely by opening a .mdb file from a shared folder. It must support various issue lifecycle related things, and the stuff those tracking systems do in general. It may or may not be commercial software. If anyone knows of such an available solution, please let me know. (And yes, I've searched on Google, and haven't found anything worthwile, so that's why I'm asking here now.) thx
View Replies !
Question-Database Tracking
I would like a field on my main switchboard that displays the last time the database was modified. Simple question, and I can not find an answer anywhere. Thanks!
View Replies !
Anyone Try Tracking Org Charts In Access???
I'm trying to set up a database to track a huge group of corporations. There is the parent company, then a bunch of subsidiaries below it. Some subsidiaries have another layer of multiple subsidiaries below it, some have none. Any thoughts as to how to do it???
View Replies !
Tracking Employee Training
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 Replies !
Paper File Tracking DB
Hi there, I知 new here so don稚 shoot me if I知 asking something that is inappropriate. I知 looking to make a DB for paper file tracking simular as you would expect in a law firm. I don稚 want to reinvent the wheel so I知 asking if someone has built something like this before. I知 also looking at barcode ID which I have no experience with at all. Is there someone out there that can put me on the right path? Cheers, Renoir
View Replies !
Issue Tracking Database
Hi team. I've had a bit of a search around the forums and haven't found this anywhere. Does anyone have a sample issue tracking database for an IT department? I don't have too much Access experience so am looking for a little bit of a headstart on this. It seems relatively basic though. The fields I think I will be needing are the following: Log No Status Priority Type Project Raised by Person Raised by Department Description of Issue Status 1 Active 2 On-Going 3 Hold 4 Finished 5 Cancelled Priority 1 High 2 Medium 3 Low Type 1 Bug 2 Enhancement 3 Other Project 1 Lotus Notes 2 File Maker 3 Tumbleweed 4 Windows 5 Microsoft Word 6 Microsoft Excel 7 Microsoft Outlook 8 Adobe Acrobat Raised by Department 1 Research & Development 2 Customer Service 3 Finance 4 Data Solutions 5 Communication Services 6 Production 7 Stores 8 Operations 9 Other
View Replies !
Employee Vacation Tracking
My computer crashed and I lost my employee vacation tracking database. Does anyone have an Excel spreadsheet or other tracking method they could share please? I really don't have time to build a new database. Thank you for your help.
View Replies !
|
TRACKER
