Search results

I thought all was good. However, I see on the same form the totals are very large for staff. The numbers are in high hundreds and thousands. What can I do to fix that so it shows just that staff's total.

TY so much!!! Everything all good again.

Yes I did finally figured that out. I remembered from working with access before. However, know I have a different issue. All credit hours for the 9 categories all have #Name?. OMG! just by adding that 1 thing - I didn't realize it would've cause so much changing. One good thing in all of...

I thought I was doing good however I get the parameter issues. Please see my screen shot. I checked all queries and the one that has the issue qryEmployeeCreditHours.

Everything was going good, but I thought I would number the 9 categories where you add new trainings. So it would be much easier to know the categories for my supervisor to know. When I did this it doesn't show me the hours in the trainings I've entered for staff. I am so sorry, that I cannot...

TY

I've been put in data and I really love it. It's getting used to how things get done. I'm getting it though. Is there a way I can have Trainings dates go in order: Like newest to oldest or visa versa?

I wouldn't ever have gotten by just you telling me what to do. I definitely will let you know if I have any more issues. I hope though once I get trainings all in for all staff and if there is a glitch some where (hopefully not) that you can text me through it to correct it. I don't want to...

That does make sense not changing in the subforms. TY I'm really going to try not to bother you too much. I think I've bothered you enough in the last few weeks. TY so much!!!!

Yes..... I did that anyways. Home site is just the home site. I always clicked the waivered site that was their home site. So we both thought the same on that. TY

TY..... That was dumb of me. COS makes sense it means Course of Study.

OK....Thanks!!! In The SubFrmWaiveredSites - I tried to add HF since it wasn't there. But I got an error msg stating "You cannot add or change a record because a related record is required in T_Employees" In the SubFromEmpCreditHours I changed the order of the 9 OCFS Categories. However, in...

So far so good. I've got all staff in the database. Works nice. However, what is T_Classes_COS used for and SubFrmClasses_COS?

This looks exactly the way I wanted to be able to get my reports. Thank You so much!!! You have put so much time into this and I truly appreciate it. I think it's good now for me to enter all staff's information. If I run into any issues, may I ask you and you can let me know how to do it...

Yes... That's exactly what I needed to know.

I'm not sure how I can change the dates for the licensing periods or add different sites as needed. Can a list be made of all waivered sites in the box and change the review dates as needed.? BR - 9.30.20-9.30.22 / BU - 9.5.20 - 9.4.22 / CN - 10.1.20-9.30.22 / GOW - 9.18.19-9.17.21 are...

I love it!!! this will work for all employee separately for a report? Once I get all information into the database i will be able to see more of what I need. Each tome i open the database the first staff person pops up - I have to exit out of it to click on employee form. Why is that. It's...

What I would like to do is be able to run a query or report to show all who are waivered to a site and show all 9 OCFS categories and the total. Will this be possible?

yes to the first part you stated. If staff is waivered for CN site 10.1.18 - 9.30.20 ALL wiavered staff must have trainings completed within that review period. And if staff is ALSO waivered to another site l(Bush site 9.5.18 - 9.4.20); which is what I'm working on these reviews right now. If...

Thank you so much for the totals. It's exactly where I wanted it to go. Can you make it so the total hours do not include non-credit hours? If fo, I would like it to. If not I can definitely work with it.