Search results

Oh one minor fix, had to add an ) to the end, was missing the closing ).

Wow thanks works great, I believe I was on the right track but lack the proper experience with the syntax. Again thanks very much. John :)

All, The query I am working with is used to track training courses. Some of these courses have a re-occurring requirement for example Fire Extinguisher training may be required ever year (an interval of 356 days). There can be several intervals types 90, 120, 365 days or no re-occurring...

Thank you so much.. Again my apologies to all, if didn't follow you advice. It was due to more not knowing what you were asking than anything ells. Like I said I am a rookie. I didn't know about the Parameters button. I think I can stumble through it from here.. I will make a different post...

@vbaInet Here is a chopped down version, cut over half of the employees. The employee select part on the main page does not work, cut that part out. I do have it set up to break the employee’s up into the four groups by last name. The qryTrainingCourseAnnualReqDate is the query I was...

@vbaInet, I am having issues with uploading the db, I have done this in the past.. May be the size but the error wants me to contact the admin.. I did however get the vba code I posted earlier working... John.

@spikepl, my apologies. You asked for the sql code prior to vbsInet's response. The sql code I sent was without his suggestion. Below in the sql code for the query with vbaInt's suggestion. SELECT tblEmployee.Employee_ID, [LastName] & ", " & [FirstName] AS Employee...

@spikepl Here is the sql code. SELECT tblEmployee.Employee_ID, [LastName] & ", " & [FirstName] AS Employee, tblTrainingCourse.TrainingCourse_ID, tblTrainingCourse.TrainingCourseName, tblTrainingCourse.TrainingCourseType, tblTrainingCourseLink.TrainingCourseCompleted...

Thanks all for your responses, @vBaInet, I tried adding the BETWEEN statement to the query as you suggested, I could not get it to work. Referencing using a separate Form to perform the date range function I found this Tip http://allenbrowne.com/casu-08.html I followed the steps and got...

Hi All, I have an access 2013 database, part of the database is used to track employee training courses. Some courses have an annual requirement. I have created a report that is based on a query that returns the information about a given course. The data the query pulls is employee name...

I want to thank you for your help with this, I am going to take all of this and mull it around and experiment. I will find something that works probably a combination of all that has been discussed. Thanks John

Yes, this works and is pretty straight forward. Do you see a way to do this for more than one at a time to be entered/updated? If I have to do this for 50+ people it going to get old real quick. I can’t without having some kind of intermediate place to hold the data I.E. the table I was using...

Yes, this is exactly (~) how it is set up. The top part of the form has information about the event including TrainingEvent_FK and the bottom is set up as you have suggested. However the devil is in the details, how would you get the Employee_FK and the TrainingEvent_FK into the Linking table...

Sorry, yes. I key in the data/updates.

@plog, First I would like to add I am the designer the user and in some cases the trainer (but I don’t do windows). I created this database for my purposes, with the intent of sharing it to other organization here in central Florida. Once I get the Knicks worked out.. Also if I am not mistaken...

@plog, See attached relationship snap shot, I have made the changes to eliminate the Y/N fields adding the recommended date fields.. Thanks The tblTrainingEvent table are records of individual events that took place at a given time. Over a five year period you could have ten records for...

@Mile-O Thanks for the quick response. I like your idea of the Stare and End and clearance dates for the Employee table this will eliminate the Y/N boxes. The Event Stat and Stop dates will be helpful as well. I also see you may not be a fan of value lists, I can understand it is kind of...

Wow thanks for the quick responses. @plog The tblTrainingEventLink is used to identify who Employee_FK attended what even TrainingEvent_FK, that they completed the event. I needed a way to create a record for each employee in attendance of a given event. This is the tblTrainingEventLink...

First off I apologize for the big “wall of text” and I am no expert and self-taught. I am here not so much with a problem as a question, is the process being done correctly and/or is there a more efficient way of doing it. The process I am using works it just seems clucky. The attached Access...

I have a simple query that feeds a report. This query returns a list of employees that have taken a given training course. The information is Employee Name, date completed ect.. For example I can generate a report for all employees that have completed Safety Training 101. The report will have...