Queries :: Creating Employee Database To Record Related Information?
May 9, 2013
i have been trying to create an employee database to record:
1. Name , Address
2. Telephone
3. Date of birth
4. employee ID#
5. Emergency contact -name, address, telephone
6. Photograph
7. Other pertinent information related to employees
So far I have incorporated the contacts database forms into my new database but I am unable to link the forms into one form that will incorporate all the information needed. Is there an existing employee database that I may edit to suit my purposes?
View Replies
ADVERTISEMENT
Oct 16, 2012
I am creating an employee database for a client. The employee table has a performance column for each employee, and my client wants to be able to choose from four performance codes - Excellent, Good, Average, and Poor. They want to choose these descriptions instead of typing them in each time. How can I make this happen?
View 7 Replies
View Related
Mar 28, 2013
I currently have a database that has the following tables:
t_Employees
t_Cost_Centers
t_Changes
The [t_Changes] tracks what cost centers the employee is in with a start date and end date:
Change_ID
Employee_ID
Cost_Center_ID
Start_Date
End_Date
I want to run a query that will show a single line per employee, and different columns for each of the cost centers the employee was in. If the employee was in 3 different cost centers, the query would have 4 columns (1 for the employee, 1 for the first cost center, 1 for the second cost center, 3 for third cost center).
I saw another thread to linked to a concatenate example by Allen Browne, but that places multiple values in a single cell. I want different columns per cost center.
View 2 Replies
View Related
Mar 28, 2006
Hi there,
I have a form with information on it relating to several linked tables. I would like this information to be duplicated in the tables and a new autonumber assigned.
Is there a way that I can do this by clicking one button and the autonumber will automatically generate a new number keeping the rest of the information in the form and updating the tables with a new record?.
Thanks for you help
Belinda
View 2 Replies
View Related
Mar 23, 2008
Hey guys,
OK, your gonna have to bare with me a little bit as its hard to explain and if any VB is given please add a few annotations as I have to explain everything i do in a report (doest have to be too detailed, just to make the code understandable :) ) and if it needs better clarification feel free to ask :), but basically, I have the following relationship set up:
http://img512.imageshack.us/img512/3246/relationnshipswd9.jpg
At the moment, because of the way it is set up, I cannot create a record in the transactions table unless an income record is given for it (because tb_income (one) to tbl_transactions (many)) but the way I want to work is as follows:
If you have a look at the tables tbl_transactions and tbl_income and their link. The way I want the system to work is when a new transaction is made, a new income record in the "tbl_income" table would be made with the date (in tbl_income) being the date at that particular time and all transactions created on the same date would all go in the subdatasheet for that one record created for that date; and if another transaction is made on an alternate date (say 00:00am of the next day) another income record would be created automatically with the date being of that particular day etc.
My other problem im facing is that everytime there is a transaction created, I want the stock level(s) field of products in that particular transaction to be decreased by the quantity purchased of that product but i have no idea how to do so
Any help?
Thanks a lot in advance!
Daniel
View 4 Replies
View Related
Jan 20, 2014
I have a form and a subform.
When I click on the command button to create a New Record and then type the customer details in the Main Form and the Order Details in the Subform, the information is not retained
i.e. when I close the Form and then re-open the Form the orders details are not saved but the customer details are.
When I re-enter the order details the information is retained this time, everything seems work ok second time round!!
View 4 Replies
View Related
Apr 16, 2014
I have a requirement to categorize a field in the employee database.
The requirement is: for any given user designation, if the total number is 10 or more, I need the actual designation itself as the output. However, if a particular designation in the organization is less than 10 in total, the output should be 'Misc - and the grade'.
Also, this will need to be done for each grade as well. For example, though the staff designation 'Software Engineer' count is 15, the designation is present across two grades A and B. So, in the output, for the staff with Grade A will show the actual designation as the count is 11, and for Grade B staff with the desgination 'Software Engineer', since the count is 4, it should display the output as 'Misc - Grade B'.
I would like to achieve this in MS Access 2010.
View 2 Replies
View Related
Aug 23, 2013
I have a simple relational database with the proper linking tables, etc. I am normalized through BCNF. I have a table that will track tasking details, however, more than one person is assigned the tasking. How do i add to my form the ability to add additional people to the tasking?
If I drag and drop the name field then it is a one name for one box deal. I want to create a combo box that uses a query to prepoulate multiple elgible names (already built) and then you can select the person you want. Afterwards I want the task assigner to dynamically add additional people to the task with no true limit as the group can be as small as one and as large as thirty.
I attached a small screenshot of the basic table structure. I need to be able to add multiple SME's to the one tasking...
View 2 Replies
View Related
Aug 11, 2014
I have a split DB that is in its (hopefully) finally stages of development. Using Access 2010. It is being developed both at work and at home on a 64 bit machine. The remainder of the machines are 32 bit.
All of a sudden one of my most basic sets of code doesn't want to work, but only on my machine at work. It works fine on my home computer and on other computers at work. It is the simplest of codes, run from frmNameA:
DoCmd.OpenForm "frmNameB", acNormal, , "[SequenceNumber] = " & Me![SequenceNumber], acFormEdit, acWindowNorm
The desired sequence of events is to open frmNameA, find the active clients and then click on the [SequenceNumber] to bring up the related record on frmNameB.
When I do this on my computer at work, it asks for the query criteria for the [SequenceNumber] and the criteria for another field. On the home computer and others at work, it works just fine.
In a related problem, I have the following code on the OnLoad event for frmNameB. It opens all the related records for active clients that are in frmNameB. But if there are no related records, it is supposed to cancel the event. Again, it works fine on my home computer and others at work, but not my work computer.
Private Sub Form_Open(Cancel As Integer)
'code when opened from frmNameA and no record exists in frmNameB
Dim MyReply
If ClientID = "" Or IsNull(ClientID) Then
MyReply = MsgBox("No record exits in frmNameB, Do You Want to Exit?", vbOKOnly)
If MyReply = vbOK Then
DoCmd.RunCommand acCmdUndo
DoCmd.Close acForm, "frmNameB", acSaveNo
End If
End If
End Sub
What I can't figure out is why this may be happening, where I might look for errors, and what I might do to correct this.
View 9 Replies
View Related
Dec 18, 2013
One to Many tables:
tbl_Doctors - Main Table : PK is doc_ID
tbl_Patients - Related Table : PK is pat_ID and 'related key' is docpat_ID
Dr. John has 3 Patients
Dr. Sam has 7 Patients
Dr. Andrew has "No Patients" IE. NULL
The (totals)Query:
Group by doc_ID (tbl_Doctors)
Count of pat_ID (tbl_Patients)
It works but ofcourse it does not include Dr. Andrew - as it shouldn't, because there is no related record in tbl_Patients.
What must the WHERE statement be to include Dr Andrews' number of Patients and display it as "0" (zero) ?
View 3 Replies
View Related
Mar 4, 2012
I'm trying to create a database whereby employees within a business can select their name, or scan the barcode on their ID badges, to clock in and out of work.
View 2 Replies
View Related
Aug 30, 2006
I have a list of class sessions. To help with maintaining attendance, each session has its own roster. I just need to add a functionality so user can make sure the attendance roster is synchronized with the past sessions and future sessions in events of last minute additions/drop or updating names/contact infos. The sessions are related to themselves as below:
ClassID PreviousClassID
1 Null
2 1
3 2
4 Null
5 4
So therefore to propagate the changes into all sessions how would I instruct the query to look for each related ID then checks if it's also related...
I'm thinking I may have to use VBA to do what, but I hope that can be done with a append query.
Thanks!
View 14 Replies
View Related
Jan 20, 2015
I have a relatively small data base.
There are a number of what I call reference tables. These are fairly static and in the main will not change.
There are a further half a dozen tables all linked together.
The system basically takes an enquiry which may lead to a repair taking place. The repair will have a number of jobs and each job may have parts replaced.
What I want to do is have an identical database which to begin with will have exact copies of all the reference tables. The remaining half a dozen tables initially will be empty but grow with time.
The user wants to be able to copy the completed repairs he selects over to the 2nd database (which is initially empty). As weeks go by he wants to select further completed jobs that have not already been copied over to the 2nd database. The 2nd database will be updated so I can't just copy over all completed repairs each time.
I had envisage him doing this by using a front end to the 2 databases and firstly selecting which of the completed jobs which haven't been copied over. This is a fairly straight forward query that will update a field on the repair table.
Once he has done this I was thinking that I could run a query that would pull all the rows from the 6 tables from database 1 and update the corresponding tables/rows on the 2nd database.
I don't actually know how to approach that. The process needs to be simple for the user. ie 1. select repairs to copy over 2. run something to copy them over.
View 11 Replies
View Related
Feb 5, 2014
i am busy with creating a access storage database and need to calculate the number of days a vehicle is in storage, i have a [date in] field and a [date out] field. i need to calculate if [date out] is empty to use today otherwise [date out] - [date in]
View 5 Replies
View Related
Jul 17, 2006
Hi
I was wondering how to create a form which is using data from three tables, the data in the tables does not have any relationship setup as they are not related to each other.
When I use the wizard and I select the three tables, Access starts complaining about the fact that no relationship has been setup...
Please help,
Thank you,
Gurkie
View 2 Replies
View Related
Sep 22, 2006
I'm trying to create a database in Access to track various employee data for the company I work for. We have about 44 employees. There are about 7 different groups of data our poor secretary now has to keep up with. These include: a list of the employees, with name, address, phone, etc. A handmade form with salary information like current wage, raises and when they were given, etc. A bonus section, how much and when. A list with attendance information including tracking missed days and tardies. A list of temporary employees and when their incremental reviews are due. There are other lists we use and others we are thinking of starting having to do with training, etc. It’s too much to keep up with manually now.
One of my questions is: can there be one table with the basic employee information that other tables can access without having to enter the same names again into other tables? (Why enter all those names more than once)? My other question has to do with linking tables together, I just can’t seem to grasp the concept even after reading two Access training books on the subject. I made a simpler database for another project and gave up on linking tables and the database seems to work just fine.
Any help is appreciated and sorry for the long post.
View 3 Replies
View Related
Feb 24, 2008
Dear Access Expert.
I would like to create a Scheduling database for employees. The database would include:
- list all of the employees
-tabs to look at schedule for this week, 1 week from now, 2weeks from now, 3 weeks from now, long term (1-2 months), etc
-small comment section within each day for the guys to enter some comments...e.g. dentist at 10, holidays, etc
There has to be something like this already out there that I can modify and work with. Is there anything like this already in the NorthWind Database that comes with Access? What about some free examples Access developers made?
What about Outlook? Can I modify Outlook and use VBA somehow to accomplish this? Outlook is basically on an account basis so I don't know if I could tailor it to my 30+ employee database.
Thank you very much for your input.
View 2 Replies
View Related
Aug 3, 2005
Would like to hear from anyone that has designed a database that can be used to track employee compensation on a year to year basis. I am current designing a database to do just that but I'm having a hard time deciding on how to setup the tables. What they use this for is yearly reviews so I need it to be able to pull data from prior years and the current year. I've designed one but don't think its going to work for me. Just interested to see if and how someone has done the same thing.
Thanks,
Chester
View 4 Replies
View Related
Feb 4, 2008
Hi all, I am looking for an employee record template for data including sickness, vacation, skills, CVs etc. I would have thought there would be loads available but alas, I can find none
Can anybody point me in the right direction please.
Thanks in advance
Rob
View 4 Replies
View Related
Aug 11, 2005
Hi all,
I am stuck where to start and wanted some advise. I want to create a database that captures whether employees are late, sick, holidays etc.
So i would have a list of employees, then create a new records in another table to store what type of reason it is, (late, sick, holidays etc.), and then the directors can monitor employee sickness. But what i would to do is to be a bit clever about it though in 2 ways.
Against the employee they would have a number of allocated holidays against them, but i just wanted the user to enter the start and end date, and then get access to work out how many holidays days need to be taken off, i.e. it does not included weekends or bank holidays....
Also in the sickness report, work out how many single days where taken on either a Monday or Friday....
Has anyone done or seen an access database that can do this already.
I know there is a calendar addin, but i've not used it...
View 3 Replies
View Related
Jun 3, 2013
I am trying to create an access db to monitor my expenses for my new Snack house.
I have created a "Main" table which will be holding all the daily expenses entries one the fields is called "Type" in which i formatted as combo box with the following values (vegetables , butchery , bakery).
Another field is called "Item" which should list the items based on the Type selection.
Knowing i have a second table in which i stored all types and their corresponding items , how can i force the filed "item" in table Main to simply display the ones i need based on the "Type" input.
View 1 Replies
View Related
Sep 14, 2013
Trying to modify this calendar database to track employee leave. I need the calendar form (frmCalendar) to show all employee leave on the calendar using the "Show All" command button on click event. This works if I specify a uID (UserID from employee table) in the code, but only for that specific employee. I need all employees at the same time up on the calendar so I can see if there is more than one employee off on any given day.
Events or leave is populated on the form through "Private Sub DisplayEvents" and the mdlCalendar module.
Using Access 2010
View 2 Replies
View Related
Mar 20, 2014
What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
View 1 Replies
View Related
Jan 9, 2013
Is there a way to track the changes made to a record? I have added a timestamp field to my form that indicates when the record was changed but I would also like to know which of my staff has made the change. I found this on line but I'm having no luck with it working:
CODE:
Private Sub Form_BeforeUpdate(Cancel As Integer)
' Log the user details to the table
Me!UpdatedBy = CurrentUser()
Me!TimeStamp = Now()
End Sub
What this gives me in the Updated By control is "Admin" instead of the users name.
View 4 Replies
View Related
Sep 25, 2014
I need to add a persons photo to their employee record and don't know where to start.
View 11 Replies
View Related
Nov 28, 2012
I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?
View 1 Replies
View Related
