Tracking Expired Training
Hi
I have a query that tracks employee training that is incomplete. The query grid includes a yes/no fieldsthat show if it is completed, so I put criteria to say no, so if the course is not done, it will show up, But it also has to show if the training was already completed but expired, So i created an expired field in the query grid which calculated the expiry date. To show if training is expired, I put in an OR condition, training complete =yes, and expiry date <=now. It does show the correct results.
My problem is, if someone completes one of the expired courses, and the data is entered with a new expiry date (calculated) I want the previous courses (the expired one) to be removed from the view of the query. Right now it still shows because of the criteria.
What can I add to the criteria for the expired training to make it dynamic, based on the data entered into the table, or do I have to put a new or condition in.
any help would be appreciated
Marlie
View Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
Training
I've been reading books to learn VBA for Access 2007, but I would like to take some training classes. Can anyone suggest any good online or onsite courses that I could take?
View Replies !
Training Videos
I was looking at purchasing the following set of training cds and noticed there is a 5 user license included. Would anyone else be interested in going in together and buying this? Link (http://www.youlearn.com/products/lk-products/A/access2003dev/access2003dev.html) I thought I might even rent them out after I go through them.. Anyone have any interest or other ideas? If so, pm me. :) I'm guessing that I already know about 60-70% of what is teaches but the other stuff looks interesting plus I'm really needing to train my replacement at some point in the near future...
View Replies !
Need Training Database
I am trying to create a Microsoft Access training database for us at work and I’m not having much success. Can someone look at what I’ve done so far and see if they can make it work or if you know of one out there already that I could download and use that would probably even be better. If there is more to it than just training then that it’s probably better too because I want to expand this as I get time. Thanks, Mike
View Replies !
SQL Training Courses
Morning all I am currently working with IT and am looking for a course/courses to further advance within the IT sector. My employer is willing to fund and/or allow me time from work to obtain the qualification. I am writing to see if anyone could advise on the best courses i should be looking at or are available. I am looking into doing something with SQL and have been looking at the MCITP course with Computreach. Can anyone recommend this course or has anyone any other recommendations?. Regards Nathan
View Replies !
Best Training Course London
Hi, Myself and a few of my colleagues want to petition our boss to be given Microsoft access training. Most of us are fairly experienced excel users but do not write our own macros or anything of that sort. None of us have any prior experience with Access. Ideally we want a course based in London that will take us from ground up to expert users. There seem to be loads of courses out there but we want to know which ones you feel are good and in particular which lecturers within a given company are best. Cheers Baz
View Replies !
Online Training
Have any of you ever used some really good online training? I really need to get good with ASP.NET, VB.NET, ADO.NET and SQL 2007 Server ect. I want to do some self pased online training, anyone used a really good service for this? Thanks you!
View Replies !
Need Training Database
I am trying to create a Microsoft Access training database for us at work and I’m not having much success. Can someone look at what I’ve done so far and see if they can make it work or if you know of one out there already that I could download and use that would probably even be better. If there is more to it than just training then that it’s probably better too because I want to expand this as I get time. Thanks, Mike
View Replies !
Fitness Training Form
I'm trying to set up a training program for my gym database but I'm having alot of problems, I will be in debt to anyone who can help me out! My current "training" tables" ExAttributes ExID - PKEY ExType - (Sets, Reps etc) ExerciseTypes ExerciseID - PKEY TrainingType - (Lookup from TrainingTypes, cardio etc) ExerciseName - (jogging, swimming etc) Training TrainingID - PKEY MembershipNo - FKEY TrainingType - (Lookup from TrainingTypes, cardio etc) ExerciseName - (Lookup from exercisetypes) TrainingTypes TypeID - PKEY TrainingType - (Cardio, Strength etc) --- Hope that makes things abit clearer Just to clarify I have most of the other things done, the membership, payment, measurements and health forms are working great, I can also search for members and run queries as to when membership runs out & who hasnt attended in a set period of days. What I am looking for from this training form is just a form where I can bring up a membership ID, and below that have a series of drop down boxes, one under the heading Cardio and one under the heading Weights. I should be able to select an exercise in one of the many combo boxes (for example jogging) - and then enter the time / distance in text boxes. I should be able to do the same then with the weights but with sets / reps / weight instead. I also want to have Sessions 1,2 and 3 for each member ID, as part of the training plan they will have to do 3 sessions a week, these should be able to be different. Thanks in advance.
View Replies !
Gym Training Form / Table
Hi, I want to create a simple training form which would allow a personal trainer to input a series of exercise types, name, sets / reps for a member which then could be printed out as a "Session" for them. I have completed the rest of the database which deals with members, payment and so on but this part is leaving me stumped, any help greatly appreciated. Jon
View Replies !
Setting Up A Training Database Help!
I have a table with the following fields flddate fldclassname fldemployeename fldstatus I have data entered all current employee training and dates that training was done. I am looking for an explanation on how I can set it up so i can see who of the employees have not recieved the training. I am also looking for code for the query to calculate recurrent training dates (when the next training is due for each employee) Dates of initial training for each employee may be different, as well the training may be required every one year or every two years etc. I am hoping that I am explaining this more clearly in hopes to get some input back from the experts on this site. Thanks in advance.
View Replies !
Linking Job Titles To Training Courses
Hi, I'm new to this forum so forgive me if this thread is in the wrong section. I'm currently creating an OHS&W (Occupational Health Safety & Welfare) database. My boss has just requested if I can possibly have it so that when a Employee has a job title selected for them it automatically lists the courses that are required for that job. Can anyone help me please? Cheers
View Replies !
Database To Record Training Data
Hi All I am trying to setup a database to record details of who and where I trained staff. The ones I have found all include grades and marks which I don't want. Does anyone have a sample database that can help get me started please. Tee.
View Replies !
Query To Find Ee's With Training Not Completed
I am working with a training database. I am a fresh newbie to access (more of an excel user). I need to find employee's who have never completed a certain training (DPW Medication Training), which is mandatory. I have the following tables: Employee data TBL - Contains active ee's names CompletedTrainings - Contains all trainings completed by individual Events - name of all the trainings, including mandatory trainings I have the following queries: DPW Med Training - Lists all who have completed the training DPW-Med-Last - Lists when each employee last had the training Med_01 - Lists those who have had the training, but need it renewed Any thoughts?
View Replies !
Query For Missing Values From Training Database
Hi I have inherited a database that contains details of staff training data and the tables contain the following: Personal Information Table: PersonalID Surname Forename EmploymentStatus (this contains either Staff, Operative, or Supervisor) Training Courses Table: CourseID Course Name Course Description Supervisor (Yes/No) Operative (Yes/No) Staff (Yes/No) Training Courses Attended Table: RecordID PersonalID CourseID Date Each of the courses in the Training Courses Table should be attended by one or more of the groups identified in the EmploymentStatus field (ie. Supervisor, Operative, Staff) and the relevant field in the Training Courses Table is flagged eg. Training Courses Table: CourseID, CourseName, Supervisor, Operative, Staff 100, basic safety, Yes, Yes, Yes 101, safety management, Yes, No, No 102, working with ladders, No, Yes, No 103, VDU, No, Yes, Yes I need to identify which individuals have not attended the courses that they should have been completed (ie. compare courses attended with the list of courses associated with the EmploymentStatus associated with individual staff members, and identify which courses have no attendance dates). How can I structure the query, I can't see how to do this with the existing tables, but I think it should be possible, but my Access expertise is just not good enough to work through this. Any advice would be much appreciated.
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 !
|
TRACKER
