Search results

Ok, let me see if I can clarify. Right now when I enter a new time off request for an employee, I input a start date and a end date. Then I call the WorkDays function to calculate how many "working days" that date range accounts for. Problem is, those formulas only count monday-friday non...

So when I made an access 2007 program to track time off at our company, everything worked. Only issue is, I need to account for different employee's schedules. Some employees work mon-fri. Others work mon, wed, fri, sat, etc. So my best thought to add this ability is to add to each employee...

Here's what my form for the loads looks like. Like I said, my code works, it's just not efficient and very slow. I'm thinking it's got to be the DMax, DLookup, etc. Maybe there's a better way like keeping a check box field that marks the comment as the newest. And each time a new comment is...

Here is my comments title. Each comment has a date/time and a load number it is attached to. So what I'm needing is to see for each load, the latest comment.

I have Table of orders, and a table of comments. The comments table has fields that cover date/time entered, name of user that added the comment, the text comment, and of course a field that ties it to a certain order_id. So, I have a continuous form showing a certain range of orders (50ish on...

that didn't seem to work. Still don't see the employee information when all the time off records are filtered out. Is there no way to maybe use a unbound text box to get this info based on my combo box in the form with the employeeid im interested in. It's only 4 to 5 fields i want to see in...

I have two tables in a query. A employee table. And a time-off table with time-off record. I have a combo box to select the employee whose records I'm interested in, and a few other ways to easily filter the time-off records. My issue is that when I filter out all records the bound text...

In my Employees query I added two more calculated fields [Vaca_Year_Start] and [Vaca_Year_End] so I'd have a range for each employee that I could play with. I have never used the "Totals" before. Sooo I'm trying to learn. I got it doing the subtraction correct by using the expression...

I will be attempting getting the calculations working today. Question though, how would I best deal with each person having a different vacation year that depends on their start date? My idea to deal with it is somehow calculate the employees current vacation year in the employees query as...

Ok, so if I understand right, then I am binding only the Employee ID to the "time_off" record. The "Full_Name" will not be stored to the "time_off" record anymore so I can delete this field from my "time_off" table?

I mean, I guess I need the "Employees_with_entitlement" query as well as the "Time_off_with_days_debit" query in a separate new query. I then need to somehow go through the "time_off" query and sum the "days_to_debt" for type "vacation" for each employee. That would need to be subtracted from...

Ok I've got a query that calculates the "entitled days" for the employees correctly now. I've also got a query of my "time off" records that calculates the "days to debit" for each record excluding weekends and holidays. I'm getting closer!!!! Now, where should I head from here? I know I...

I got all this. Thanks guys! Another related question though. I realized I was breaking another rule of design. When I used the "Full_Name" as a key field, That's what I would tie to "Time_Off" records. But I just realized now that I have the "autonumber" as the "key" for the "employees"...

My idea to accomplish the "calculated query" would be a two step process. First write a "public function" of sorts in vba with arguments like for example. Public Sub Vacation_Allowance (start_date, extra days given) - told you i'm bad at vba.... and through calculation have this return the...

Ok, I guess I'll start simple and expand. Galaxiom, how would I go about creating the query that calculates the "entitlements of each LeaveType". Lets say I have Vacation, Sick, and Personal for leave types. Each employees vacation entitlement depends on the years of service from their...

what if we have employees that have been given more vacation time before the normal formula for say average employee would have gotten the bump? it seems really tough. ill keep thinking on it. thanks for the suggestions.

I have a vacation database that is coming along well but I am now to the tough part. I need to come up with a way to track the remaining days a employee has. I am having a tough time grasping the best way to implement a debit system of sorts. I would like it to be as automated as possible but...

ahhh frustrated trying to get the birthday in there. I know it has to do with my formatting and data types. not sure how i have to "delimit" it or whatever. been trying the # instead of quotes but no luck. If DCount("*", "Employees", "[First_Name] = " & Chr(34) & Me.First_Name & Chr(34) & "...

I really appreciate your help bob! I am looking at the dcount function and it makes sense to me except for the first parameter "expr". http://office.microsoft.com/en-us/access-help/dcount-function-HA001228817.aspx explains it as "An expression that identifies the field for which you want to...

nevermind, i was able to do it. made a backup b4 of course. My forms and such will take some rework now but I think I'll be better off in the long run. Another questions though... I still have not implemented a validation to make sure when a "new employee record" is being created, that...