Recent content by JSimoncelli

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...