Search results

What would be the best way to move an employee to inactive? IE they are fired? And how would this be done? If an employee were to be "fired" how would that be done as far as user forms goes. If this isn't to much to ask. I'm going to try to make a form that will add an employee. How would...

Well I looked at the database and it looks great. It appears to be functional minus any other reports / queries I would want the person entering the data to have access to. One thing is how would I get the days off to display with the employee info? Like below Department, without...

How would I get information about out of a sub form (this sub form is a query). Stores into a variable (really if I can store it into a variable I can do whatever it is that would need to be done with it). The form name is AttendanceEntry: The subform query name is EmpInfo

I did get the append query working. I'm just having a heck of a time understanding how the days off table is doing anything useful. If I zipped everything up do you think you could create a query that would show how many persons per day are scheduled in one department? Based on the tables...

Also do I enter in each employee multiple times into the days off table for each day off? How would I code it so that when the database is opened the employees that are off are added into tblEmployeeAttendance automatically with the entry "OFF"? Is it possible to use a subform on a form to add...

I'm having trouble setting up an append query. Could you help me with an append query to show how it is done. From there I should know how to do it (well that is how I learned VBA in excel, frankinstening code together till I understood. it.) What I mean by this is, I'm having trouble getting...

I tried using excel, the project frustrated me to no end, I was basically building a database in excel and it was confusing as all hell. Therefore I decided why fight it, this needs to be a database so I might as well learn Access too. Will a form with Employee First and Last name...

I have the database setup as you had outlined jzwp22 (thanks btw). No idea how to get this thing to do anything really as my brain wants things to look like excel for input method. Would I make a form that lists the employees along with the days of the current week? I think it would be the...

Will it be alright if the data type for longPoints is double? Or is there a different way to deal with a decimal? Some point values will be .5 which I can't get to show up while the type is set to long. Also I didn't realize but yes I guess some persons will work in more than one department...

i will read over this advice and try to make sense of it. Been using excel for so long it is hard to forget my methods for excel. I will just try starting over from scratch using the model you've suggested.

Using the setup that I've noted above and can't seem to sum the total points. I have a feeling this is due to having a different primary key in the total points table (needed due to the employeeID repeating for each week). How will I be able to create a query that will show the total of all...

Upon thinking of this more and trying to not think of it as an excel spreadsheet. I think I will also need a table that shows an employees days off. I created one titled tblEmpSchedule and this table contains the following fields. EmployeeID, Sunday, Monday, Tuesday, Wednesday, Thursday...

Of coarse my goal is to use access exclusively however right now my vba skills with excel are better than access so I've been using a part of the program through excel. However if excel could be eliminated that would be fine. I currently have the following tables in my database...

The reason why I wanted to use Excel as the entry method is the users know how to excel more than access and may be intimidated with access. I do not posses the knowledge (currently) to create a solution using access that would emulate excel.

A person can have more than one job title simultaneously. A person will not work in more than one department at one time. Simple tracking will take place for such things as vac, sick and what not. Ff a person is sick and it is not backed up by a doctors note then it would counted as Absent...

I've been posting various questions about a database I'm working on and haven't been making much progress and as a result I've come to the conclusion that maybe I'm asking the wrong questions. I'm looking for general help in regards to how to create a database to track employee attendance on...

I have 3 queries that have a column titled TotalPoints which uses the below formula to get the information: Then I want to have a 4th query that uses the column created by the below formula to summarize the 3 queries that contain the below formula. The problem I have is getting the information...

I found this on the interwebs and while it works I wanted something more efficient. With rs Do If rs.Fields("EmployeeID") = EmpID Then rs.Delete rs.Update End If rs.MoveNext Loop Until rs.EOF End With This was on the same...

It should be noted that this delete will occur from excel. This i did forget to mention. I found this which is supposed to find the entry but when I use the below delete command it doesn't do anything (this is from excel remember). Would I be better trying to get this code from an excel...

Thanks for the info regarding parent child relationships. This table will have queries linked to it. Given that how would I delete the entry and ensure everything that was affected by this delete is corrected? Removing an entry will be needed as employees are fired.