Search results

Hello all, I have been building an employee database, it has gone amazingly, just ran into something I wouldn't know how to sort out. Basically, when we have a new training requirement come out we need to track completion. The way I currently do that is adding it in through the "Add New...

https://www.techrepublic.com/blog/microsoft-office/automatically-fill-in-access-text-boxes-based-on-a-combo-box-selection/ Might be what I am trying to do...

Thanks! I will read up and adjust accordingly. Now just to figure out the code for the autofills....

hello again, I am not familiar with normalization rules. I've attached 3 screenshots of each table. Table 1 = Types (which will never change as things will not be added) Table 2 = The record source for adding training types (typeoftraining reads from table 1's data) Table 3 = the record...

I'm not quite understanding... Basically the table I screenshotted is just the info table, where it gets stored is seperate, the options are just selected from the table I screenshotted. The categories will never be changed as they are what they are, if the policy is a sign off it will never...

Thanks for your reply! No luck with Me.Category = DLookup("tblTrainingSelections", "TypeOfTraining", "ID=" & Me.[Name of Training]) I tried adding it to the after update field on both name, and category

Exactly what I am looking to do! I am going to probably disable it from being clicked and edited, if that doesn't interfere with anything.

Good afternoon/evening all! I am back again, I am moving forward with my project wonderfully! I have run into another area that just makes the user experience easier and allows for more consistency in records. I've attached a screenshot of what I am trying to do. In my form, I have a form that...

I just dont understand how to write a code to say if it is => “10” then display

Any chance you would know a code to work??? Sorry to bother I have searched and can't find what I'm looking for exactly.

Hello! The event would ideally be on load, or on update. The control source for this is ** =CDbl(Nz(Sum([Number of Days E]),0)) ** which reads from the Query that calculates the number of days the employee is absent for. So when I load up my form, one of the tabs is a datasheet and that...

Hello! I am trying to make a code that will open a message box is the "txtEmerg" box is = to or > than "10" to display a message that Emergency Days Have Been Exhausted. I have no experience with VBA Code and would love to learn but start small. Any help you can offer would be greatly...

Number of Days Sick: IIf([TypeofLeave/Exception]="Sick",(DateDiff('d',[Employee Attendance.Start Date],[Employee Attendance.End Date],1)+1)) --- A lovely lady on another forum saved me! This worked!

Yes! This formula does work, and I did add it to the control source but yes we ran into the issue where it was totaling all entries, not just the ones belonging to the employee. This where I need some help, having the number change based on which record (employee) we have open in the employee...

Hello! Thanks for your reply and code! The dropdown is a word, which is Sick, Emergency and so on. So I am just unsure where this code belongs, should it be added as a field in the query design, like Number of Sick Days: WHERE [Type of Leave/Exception] = 'sick' AND other possible conditions...

Hello, I am unsure how to write that into a code as I have tried that as well.

@Cronk @theDBguy @jdraw https://drive.google.com/file/d/1FtK9gtCIApNDBuAif1xsyoHDOS3HdkOK/view?usp=sharing is the database due to it being too large for the site. Above is the access database, have stripped it and removed 204 employees. I am going to take the advice and change names to no...

I have no idea where to begin with that. I am now trying to write the formula right into the query, as my "number of days" function is Number of Days: DateDiff('d',[Employee Attendance.Start Date],[Employee Attendance.End Date],+1) which works great, trying to make it only count if type of...

This still didn't work, I am trying to use the code as the control source when I open the "wizard" which will be the main interface for my Supervisors, I have made a module that works that counts all days that one employee has been absent using "=CDbl(Nz(Sum([Number of Days]),0))", this works...

what does & me.YourComboName & represent? the combo name is sick, so not sure how to format that