Displaying Records Relating To One Employee At A Time
May 6, 2013
I am currently creating a DB for a Customer Service team so management can keep track of who is skilled in what area, sick days, holidays etc. I have created three tables so far as follows:
EmployeeT with a primary key 'EmployeeID'
SickT with a primary key of 'SickID' and a foreign key of 'EmployeeID' linking to the EmployeeT (Reason behind this is that I may have multiple records for one Employee, meaning I would need a unique identifier)
SkillT with a primary key of 'EmployeeID' linking into the EmployeeT (Only possible to have one skill record linked to one employee)
Set up relationships as follows:
One EmployeeT to one SkillT
One EmployeeT to many SickT
I then created a blank form and used Tab Control.
On the first page I was able to populate the page with all the Employee info.
On the second page I was able to populate with all the skills relevant to the initial employee.
Then I tried populating sick records relating to the employee on a third page, but that's a no go. I was considering putting a subform on this page, but I wouldn't know where to even start with that.
I am trying to create an Access database where I can let the employees enter their time-in and time-out, at the end of their shift. I already created this function working, but running into another issue. Everyday, employees need to enter a break. Sometimes they take a break and sometimes they don't, if they work shorter hours. Thus, the break is not a default 30min and has to be enterd by the employee.
Below is the code I have to calculate the total hour:
txtCalcTime has the below code in control source: =Int([CalcTime]/60) & ":" & Int([CalcTime] Mod 60)
Control source for this form "FrmTimes" property, in which Txtcalctime resides:
QryTimes "QryTimes" query has the code below: SELECT TimeID, TimeIn, TimeOut, Brake, DateID, DateDiff("n",[TimeIn],[TimeOut]) AS CalcTime FROM EmpTimes;
This shows the total number of hours worked. But how can I make it to substract the break time entered by the employee in "txtbreak" on FrmTimes
I need to develope a system that will allow for employees to login and imput their "time card". I found one post on here about something similar, but it didn't give much info. I am very very new to Access so please give info in simple terms or very well explained. I am hoping that I can have a login and password so employees can't access eachothers time card. All it will need to track is Date Type of work Hours Rate Comments I am hoping that this is going to be an easy task, but I need some help. Anyone have any ideas or directions... or even better know where I could just download a template. Thanks, Chrissy
I want to relate two records in one table, a parent child relationship. I can accomplish this task with two tables I realize. I'm wanting to write a database that will map a family tree. Internal to one table I want to be able to establish a series of relationships, parent-child, sibling, et cetra. Can this be done?
I have a combox field on subform C that shows records from a query.How do I get this combo to only show records that relate to an ID on subform B.I have a subform for storing contracts and these are stored against a company name.On subform C I have a field that currently shows all records in a table. I need this combo to only show the records that relate the current record on subform B?
I have a main table which records employee,date,record employee is related to tble employee. i want to be able to delete an employee however keep the referenced records with the name, date, record, is this possible?
I have a series of forms in my shiny new database and I have added the auto time and auto date fields to the form headers. I have added the code to keep the time ticking over and it all works fine.
Unless the is no data. If for any reason there is nothing in the Details part of the Form, the date and time do not display. As soon as any data shows up, so do the date and time.
The VBA code is running in either case so I am a little baffled. Usually Google is my friend but not in this case.
I have a report that shows a datetime field and I would like to show only the time portion of the field on my report. Is there a way for me to do that?
I have 500 Records in my Software Table, and I would like to display only those records that match my criteria that I place in my text box on my form called Software Name. So Once I have entered the software type in my text box, then I would like to display those records at the bottom of the screen as the selected records.... Any ideas??My table is called, Software, which contains Software Type, Software Name, Serial Id, Comments, Inventory Number, Version , Key and Company... I have a text box that is called txtSoftware, Which searches the databse and display the information in a list box called, lstResult, I would like to however, have the option, display in the list box but also display those records on the bottom of my form as it will look like in design view of my table. I have no idea how to ever start the idea ....
This is probably a very basic question, but I'm going to ask it anyway.
I have two tables linked together, in a one to many relationship (a supervisor table, and an employee table). Each supervisor can have many employees that report to them. I then set up a forum to enter new employees as they come into the corporation, and need to referance which supervisor they report to, I have a drop down box that I want to display SupervisorLastName, SupervisorFirstName (for example, Williams, George) but is only displaying the SupervisorID (for example 60).
How can I make the forum display Williams, George instead of 60?
I am attempting to run a query with fields from 6 tables. These tables have been related, but just a simple ID to ID throughout all of the tables. When I select the fields I would like to be in query using the disign wizard it will allow me to create the query, however it will not display and data.
Originally, the query wizard would not allow me to insert all of the different tables fields in the query because "they were not related", so I went back and did the ID to ID relationships. Like I said this now allows me to create the query, but unfortunately no data appears.
Hi all, this is my first post here and im hoping one of you can help me! :).
Basically I have a report which pulls up a number of fields from different tables that basically show a work number and what the value of the materials used in the job cost. It works fine. Now when I go to add the labour table into the query, it instantly cuts out alot of the records. Now im 'assuming' this is due to the fact that not every job could have labour spent on it, that it is simply not showing records that do not have any labour hours associated with it. Therefore I want to be able to call up all the information as I did previously, but be able to show the hours spent on a job (if any). This is not my database and Ive spent a good day or so staring at it and trying multiple things but I cant seem to pull up the information correctly. There is a relationship between the tables, but I am puzzled why the information it pulls up when I add the labour table is so different.
I have a continuous form (frmEmployeeVis) that displays the records in the form's Record Source (SELECT (whatever) FROM dbo_EmployeeData). One of these fields, NotActive, can be edited for each record and affects how that record displays elsewhere in my DB.
I have a query (qCurrentHC) that counts all of the records in dbo_Employee data where NotActive equals False (SELECT Count(*) FROM dbo_Employee Data WHERE (dbo_EmployeeData.NotActive="False")
Right now, I have a List Box that displays the result of the qCurrentHC query, where the row source simply selects the only value
It all works fine. The records display, the query runs, and the list box displays the number. However, if I change any of the NotActive values and hit update (Me.Requery on the frmEmployeeVis), the qCurrentHC query obviously doesn't update since it isn't the form's record source. If I open any of my other forms with qCurrentHC displayed in this manner, or reopen this form it will update since it'll rerun the query then.
How do I get the query to rerun when I update this field on that form?
This is not a very big issue, but a very annoying one. I'm making a weekly display of tasks preformed (One subform for each day). The functionality is almost like a timesheet. You register the hours worked on spesific tasks/projects.
The problem I got now is that the textbox containing the date (In the subform) is not displayed when there is no records in the subform. The date is set by the motherform - Me.Form!frmday1.Form.VarDate = Me.day1
I'm trying to get my query to display only the minimum value within my query results. I have the following fields, CustomerID, OrderID, ProductID, WarehouseID, Freight Cost.
My current query will return results that show me the locations and freight cost of each product to my customers. My intention is for the query to only return records that has the lowest freight cost as there may be several warehouses with identical products but with varying freight costs due to location to customer.
I've tried to apply the MIN function on Freight Cost but it will only sort the records in ascending order instead of only displaying the record with lowest frieght cost.
I'm a little stuck on three of my nine queries. Bascially, three of them display records for a given day, three for a given week and three for a given month. The criteria for days and months was pretty easy; I just got:
[Enter Date] for a single date DatePart("m", [Date]) = [Month] for a given month
However, I'm really stumped on how to work out the criteria needed for working out records for a given week. All I managed to work out was:
<=[Week Ending] And >"Date[Week Ending]-7"
This works when there is no test data, but not when there is. I know it's something to do with the -7 bit, but I can't work out what.
At the moment I have a field 'Author' which is displayed using a subform. The user can cycle through the many authors that are associated with each record in the main form. However, what I'd like to do is to display each record simultaneously in the same control, and with a little bit of playing around in VB get the form to work out how many Authors there are and display the names in a particular format. I.e.,
Bloggs, Jones & Smith Hank & Mason
See what I mean? Does anyone know how I might refernce the records. So logically it would be:
I am curious to see if threre is a way to display the number of records on a form in a text box. I know access has this number on the bottom of the form, but it's a vision issue for me.
If you have a one - many relationship between data, normally in the table it is captured, you would find multiple rows for every 'thing', each row detailing different 'functions' performed on it.
Is there a way that one can display these functions horizontally, instead of vertically, i.e, have one row per 'thing', instead of multiple rows.
I have a form where users can look through different records as well as add a new record through a control button. When a new record is added, all the relevant data should end up in the corresponding back end tables.
The problem I am having is that some of the new records I am adding work perfectly (sync with the tables, etc). Other records, however, are showing up in the tables but not in the actual form. For example, when I attempt to search in the form for the record name, nothing comes up.
The Datasheet View is set to No, so it's definitely not that. I'm not really sure where else to look - the new records appear in tables and the report I have linked to the form, they just don't all show up in the actual form!
I want to run a query to show all my outstanding orders between two dates. I've done all this correctly and it works fine. However I only want the query to show me the records where the checkbox on 'tblOrders' is unchecked. For obvious reasons, I don't need to see these records, just that records that have been checked, therefore are outstanding.
I have two tables, and I made a union query (tbl1 UNION ALL SELECT ...tbl2). Problem is, I have two entries that are identical in both tbl1 and tbl2, but I want to include BOTH of them in the union query. Even though I used the ALL operator, only one set shows up!! I'm pulling out my hair trying to figure this out. Please help, and thanks so much in advance!:(
