Query To Find Ee's With Training Not Completed

Jan 28, 2008

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

Dec 2, 2006

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 1 Replies View Related

Filtering Completed Orders

Apr 15, 2005

hi

is there away to filter rows when certain values in three different tables are the same. e.g. it is a stock control db - so when goods orded = goods in = goods taken - can this then be filtered automatically to hide rows and avoids congestion on the user interface (form)?

thanks

scott

View 1 Replies View Related

Counting Jobs Completed By A Vendor.

Jul 5, 2006

I would like a textbox in my vendor form to display the number of times that the vender�s name appears in a jobs-completed table during a particular calendar year. I�m not sure where to start. I have tried building a query as follows:

SELECT Count(tblCompletedJobs.Job#) AS CountOfJobs
FROM tblCompletedJobs
HAVING (((tblCompletedJobs.DateOfEngagement)>=#1/1/2006#));

Any suggestions appreciated!

View 2 Replies View Related

Forms :: Exporting Completed Form To PDF VBA

Mar 20, 2013

I have a form that a user fills out and the record is not uploaded to the database until the user hits the submit button. In other words, if the user closes the form without saving, the record is not inserted.

My end goal is to have the user click the button and have 3 things happen:

1) Record inserted into the database
2) A PDF of the record is saved to a per-identified directory
3) An outlook new message window opens with recipients pre-entered and the newly created PDF included as an attachment.

I can achieve steps 1 and 2 no problem. However, the way I get the PDF is by having the VBA simply print and the user selects the Adobe PDF. This does not let the VBA dictate the directory (or file name) and then makes me completely stumped for step 3.

View 3 Replies View Related

Modules & VBA :: Possible To Get File Completed Posting Info?

Jul 25, 2014

I have some code that checks if a file exists, its file size, creation date and date modified. The code works fine..however..

I need to import the file it is checking and that file can sometimes take up to 30 minutes to complete its posting. In fact I used the code to check it the other day and the code showed that it exists, its creation/modifed date and also its file size - however, the file size was what it was at that moment I ran the code. If I immediately re-run the code, the file size changes - obviously due to the fact that the file is still posting (and growing due to the date being posted to it). Also note that the (completed) file size will vary each day the file is posted

So, what I would like to know is, is their a way to check to see if a file has completed posting? Something akin to .filecreated like .filecompleted (yes or no) type thing?

Here is the code:

Public Sub sub_chk_files2()
Dim obj_fs As Object
Dim obj_folder As Object
Dim obj_files As Object
Dim obj_f1 As Object
Dim db As DAO.Database

[Code] ...

View 8 Replies View Related

Queries :: Append Completed Courses To Another Table

Nov 30, 2013

I have created an append query to update completed courses to a previous education table.

INSERT INTO Education ( ID, [Qualification Name], [Level], [Date Achieved] )
SELECT Courses.ID, Courses.CourseName, Courses.CourseLevel, Courses.CertRecvDate
FROM Courses
WHERE (((Courses.CertRecvDate) Is Not Null) AND ((Courses.CourseCompleted)=True));

The theory here is if CourseCompleted checkbox is check and there is a value in CertRecvDate, the qualification has been achieved and therefore should be added to the previous education table (which will be used later for CV's etc)

The problem I face is I only want it to add any particular course once to the previous education table and not every time the query is executed. I am thinking I need to pass the CourseID field aswell to the education table and somehow check to see if that has been already added .

I have attached a screenshot showing the structure of the two tables.

View 1 Replies View Related

Macro To Move Completed Order To Another Form

Aug 24, 2015

I have created an access database to track orders through out production. I have also created a form labeled "orders" with a subform where it has all the orders information, customer info and product info. Along with this there are 3 check boxes for each order they are labeled, "Routed", "Pressed" "Finished". I am looking for a macro for when I click the "finished" check box that order is moved to another form to reduce the amount of clutter on the orders form. Is there anyway to do this?

View 1 Replies View Related

Forms :: Multiple Fields Completed From One Lookup Field

Jan 2, 2014

We have a form, which has a field linked to a "Recipients" table through a lookup. The field is bound to the recipient's name, but the lookup displays additional columns for user to identify the correct recipient in the case of duplicate names.

The "Payment" table's Recipient field only displays the recipient's name. So where duplicates occur, it's impossible to know which recipient is the correct one associated to a payment.

I would like to add an additional field to the "Payment" table called "RecipientIDNo". I need a way to auto-populate this field, based on the already existing Recipient field. Is this possible?

Why I just don't modify the recipient field on our payment form to be bound to the user ID number, there are two reasons.

(1) The field is linked to too many other reports and queries at this point. I believe it could cause an enormous amount of work to modify.
(2) the form likes to display whatever it is bound to. There may be a workaround for this, but I'm not aware of it and don't want the form displaying a number instead of a recipient name.

View 7 Replies View Related

Modules & VBA :: Make Certain Fields Required To Be Completed Before Exiting?

Jun 28, 2013

How do you make certain fields "required" to be completed before exiting?

View 3 Replies View Related

Textbox To Display Percent Of Steps Completed On A Form

Sep 17, 2014

I'm enrolling medical centers in a new multi-center database. There are a number of steps that must be completed before the center is enrolled in the project. I have a form that serves as a checklist. I want the textbox at the bottom of the form to display the percentage of steps completed. I guess you would have to count the number of fields on the form that are filled in, but I don't know how to do it.

View 1 Replies View Related

Forms :: Create Partially Completed Datasheet On-the-fly For Data Entry

Dec 6, 2014

I have a primary school database. I'm trying to create a form that allows a teacher to select their class, then select a subject and then be presented with a data entry form in a table layout that lists only their student's names in one column and an empty column to input results for the selected subject.

To simplify my explanation to just three tables, lets say my tables are:
> Students....which stores student names plus a foreign key for their class
> Classes...which stores the class name
> Results...which stores all the results (fields are: ResultID (key), StudentID, SubjectID, Result, DateofResult)

I have no problems creating reports where the teacher selects their class from a combo box to generate a report based on a crosstab query. But this one has me stumped.

View 2 Replies View Related

Forms :: Update Database Column When Mandatory Fields Are Completed

May 11, 2013

I have a form with lots of combo boxes and text boxes. They are all linked to various MS Access tables and some of the fields are mandatory. I would like do an check to see if all the mandatory fields are not null i.e. are populated with a value and then run an update query for my master table in the database to flag the records as being complete if all the mandatory fields are populated.

If (IsEmpty(tab1.cmb_a)) Then do something

But I am just blank at the moment on how to proceed, especially on how I can do all the checks and then populate the database.

View 3 Replies View Related

Modules & VBA :: Update Record Based On Related Records Completed

Dec 4, 2014

I have 2 tables, one is like a main table, containing all of the main data, such as a Job Number, Customer, Quantity, etc. I have a second, related, table that acts a breakdown of information. There may be several related records to one main record, it entirely depends on the nature of the job.

What I'd like to do is run a function that looks at a main record, checks if all the related records COMPLETED field is ticked and then tick a field in the main record. I only want it to do this for records where all of the related records are COMPLETED.

View 3 Replies View Related

Forms :: Auto-populate Current Date And Time When Other Fields Completed

Feb 24, 2015

I have a table called Neutron2015. I want the current date and time to complete when entries are made in two other fields. So I am looking for this date and time to populate in EXLStart when an entry is made in Processed By, and also the current date and time to appear in EXLEnd when an entry is made in Completed By with the bold word being the field names.

Is this possible, and how difficult is it?

View 2 Replies View Related

Training

Apr 3, 2008

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 1 Replies View Related

Reports :: Generate A Report For Items In Previous Sentence Not Completed To Keep Track Of Workload

Jul 29, 2013

I'm completely new to Microsoft Access. This project was thrown my way. I have an accounting database to track payables, receivables, financials, and deliquencies/collections. Is there a way to generate a report for any of the items in the previous sentence that haven't been completed to keep track of workload.

View 5 Replies View Related

Training Tracking

Sep 1, 2006

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 3 Replies View Related

Tracking Training

Sep 12, 2006

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 5 Replies View Related

Need Training Database

Nov 6, 2006

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 2 Replies View Related

Tracking Training

Jan 4, 2007

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 5 Replies View Related

SQL Training Courses

Dec 17, 2007

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 14 Replies View Related

Best Training Course London

Mar 27, 2008

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 9 Replies View Related

Online Training

Apr 7, 2008

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 1 Replies View Related

Need Training Database

Nov 6, 2006

View 5 Replies View Related

Fitness Training Form

Feb 27, 2006

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 7 Replies View Related