Tables :: Timesheet Structure - Check In System

Apr 12, 2013

I'm creating a timesheet/check in system (log in when the person starts work so it logs it and when they log out it logs that also for the manager or someone with high power to see.) for a fictitious scenario for an IT major project but I'm not sure where to start!

At the moment I have a few tables that are like this.

Table: Employees
Fields: EmployeeID, First Name, Last Name, DOB

Table: PayRates
Fields: RateID, EmployeeID, HourRate, TotalHours

Table:WorkTimes
Fields: EmployeeID, PayPeriod, WorkDate, StartTime, EndTime, TotalHours

I'm not entirely sure if this is all correctly structured, it just doesn't look/sound right to me.

View Replies


ADVERTISEMENT

Timesheet Table To Create Popup If Timesheet Entries Is Not Entered Day Before

May 24, 2007

hiya, just posted a message today.

Problem, ive got a work database which employees logon to and enter time against certain projects they have been working on. What i need is to somehow create some code that will look at each of the employees names and sum up there total time for the previous day. If this is less than say 6 hours of timesheets or even zero entries have been made, I want a pop up message to pop up as soon as they logon to the datatbase the next day and jsut mention they need to fill in there timesheets.

At the moment each person when they log on to the database has there name they logged in as, placed into a field (called "First Name") within form (called "Employee Startup Screen"). *** maybe use this as a way to identify who is logged on and when to run the code.***

Timesheet table has the following columns:
Employee; Date; ProjectID; Timespent

PLEASE help im a noob at this and have tried using some code on a query that sums up the previous days times filter on a employee. When the "Employee Startup Screen" opens it runs the following code

Dim internal1 As Integer

internal1 = Me.SumOfTimeSpent

If internal1 < 6 Then

MsgBox " Less than 6 hours have been entered " & Chr(13) & " into your timesheet for yesterday. ", vbCritical, Title1

ElseIf DCount("*", Me.SumOfTimeSpent) <> 0 Then

end if

End Sub

----------------------------


BUT it doesnt work if no entries have been made on the timesheet as the query result is blank.

ANY help would be muchly appreciated.

Thanks Keith

View 4 Replies View Related

Tables :: Primary Web Based Inventory System - Update Raw Data From Another System

Mar 13, 2014

I have our primary web based inventory system that I am exporting to Excel and using this as an import to Access for the main raw data for my database. This being inventory it changes daily so I am updating this table every day. When I try to append the table it ads all the records. I am wanting an easy way to add only the new records/take out the ones that are no longer there. Basically update the table with what is currently there.The only have I have found to do this is by running non-matching queries and update queries.

View 2 Replies View Related

Tables :: Timesheet Table AM / PM

May 9, 2013

My boss would like the Time Out field in my table/form to default to a PM time.Right now, when you enter Time In - it defaults to AM (ie: if you type in 9:00 - it enters 9:00AM, which is correct). But when you enter in Time Out field - it still defaults to AM (ie: if you type in 4:00 - it enters 4:00AM, when we want 4:00PM). We still want to be able to enter in AM times if needed. We just want that one field to default to a PM time.

View 14 Replies View Related

Please Can You Check Table Structure/concept

Nov 8, 2005

hi,

i need a db to monitor attendance (I know there are examples that do this but I need to satisfy my own curiosity and haven't seen one exactly like i need). My plan is to set-up the tables as below. I now have one-to-many relationships. There are many students. each student will study many courses.

I would like a form that shows the student info and a subform that shows all the courses they are on and weeks 1 -10. i could then use the yes/no attribute to record an abscence. later i would then need a query to see which students had missed two weeks in a row or more than 3 in total.

I think i need a form bound to tblStudents with a subform control that is displaying a form that is bound to tblStudentCourse. i am then a bit stuck as i need another form that will display the course records for each student. am i off track??? any ideas would be great. thanks.

tblStudent
StudentID (PK, number)
FirstName
LastName

tblCourseID (PK, number)
Week1 (yes/no)
Week2 (yes/no)
etc.

tblStudentCourse
StudentCourseID (PK, autonumber)
StudentID
CourseID

View 3 Replies View Related

Modules & VBA :: Check For Documents With Specific Naming Structure

Apr 30, 2014

I want to hit a button and then it scans for a file on a server and return with a message box saying if it exists or not.

I want it so when I am on a Specific record it will search for certain requirements.

All the file names are pdf files with the same naming structure

SIT yy m(m) dd Last Name Unique Identifier
Example:
SIT 14 5 21 Smith ABCD1234567
SIT 14 10 21 Smith ABCD1234567

So I hit the button it sweeps the file path and looks for documents with this naming structure.

Last Name and Unique Identifier are fields within the db.

Last Name = txtLName

Unique Identifier = txtUniqIden

So far I have the following:

Code:
Dim strDirName As String
Dim strDirPath As String
Dim strDirName As String
Dim strDirPath As String

[Code] ....

So Far it works and I used the actual name of the items an it finds them but I need to up each record.

I have no clue how to begin with the strDirName. How to get it to scan the file name in a specific format.

View 3 Replies View Related

Tables :: Combine Two Tables That Have Identical Structure To One Table?

Jul 8, 2013

I need to combine two tables that have identical structure to one table. Different people have used them to insert data from different parts of our project. I have tried to find information about how to do this but so far with little luck.

View 13 Replies View Related

System Tables

Oct 24, 2006

Hello,

My application I develop should retrieve some meta data from Access system tables. It should find:
- What tables are stored in database.
- What columns have each table in database.
- What relationships are between tables in database.
I opened systems tables of some .mdb file and took interest in such kind of information. But I got some problems by looking for what exactly I need. Please, could someone help me at these points:

1) I found that in system table MSysObjects I can find names and ids of tables created by user (for example by me). But how to determine that these tables are created by user and they are not let’s say a system tables?
2) I didn’t find any meta data about columns of tables! How to determine what columns has each table?

I created application which uses MS SQL Server to retrieve such a kind of meta information and there where no problems. But I stuck using Access.
I was looking for some information in Internet but ineffectively. Please, help me...

View 5 Replies View Related

How Do I Structure My Tables?

Apr 21, 2005

I don’t understand how to structure tables and relationships.

I want to build a form that allows the user to search for a postal service from a group of carriers.

User must be able to input into a form:

Weight in g, Kg or lbs
Insurance level required
Whether signature is required (Yes/No from drop down list)
Collection/drop-off options (tick boxes)

Each service has a different insurance level, some need signature; some services collect, and all have different rates.

I just want to know how to structure the database.

The main part of my question is what would be my main table be and what fields would be contained in it, and what foreign keys would be introduced to pull in info.

Would you have a different table for each service?

View 9 Replies View Related

Linked Tables.... Db Structure Changes

May 8, 2006

If i make minor changes in the backend db structure (eg add a feild, change properties of a feild in a table,). These changes are not reflected in the frontend. how can thses changes be reflected in the frontend usig the simpest method.

View 2 Replies View Related

Suggestions On How To Structure My Tables

Feb 9, 2005

I am creating a database where the user can import data from a number of spreadsheets (one spreadsheet for each company). Currently I have one table for each company with the year being the primary key. Each year when a rolled over spreadsheet needs to be generated for a certain company I have Access import the data to a blank template in excel which will display the prior 4 years of data (for informational purposes) and leave a column blank for the end user to fill in the current year data. When returned the current year data is imported into the database.

My problem is that I cannot see a way to do this without having a seperate table for each company. If I have one table with all company data I cannot use the year as the primary key. Any suggestions on how I can reduce the amount of tables I need. Setting up the rest of the tables wont be a problem, but future users of the database will have to go through the process of creating tables for new companies and creating all the queries and macros associated with that table.

View 2 Replies View Related

Tables :: How To Structure The Table

Dec 24, 2013

I have a table where in 286 different fields have to be updated by the users. ( Nature of project And i have 10 fields which are coming as a input from another table, so i use Append and Update query to add the new datas and update the datas in case of any changes in the input from another table. ( to avoid manual corrections)

Now coming to my real problem, all the 286 fields have to be updated by the user's are check box type, now what is the solution since access will not accept more than 255 fields?

View 4 Replies View Related

General :: How To View System Tables

Jan 31, 2013

Access 2010 Where exactly do I find Import Specifications that I have created? How do you View System tables?

View 1 Replies View Related

Using Queries To Alter The Structure Of Tables

Aug 2, 2005

How can I add an additional field to a table based on the output of a query? For example, I have table A with 2 types of records and table B with only 1 type of record. Based on this, I can determine which records in table A are the same type as those in table B. I would however like to be able to flag within table A, those records in table A that are the same as those in table B.

View 1 Replies View Related

Tables And Table Structure Needed For New DB

Oct 31, 2005

Firstly, I want to admit that my knowledge about data base construction is fairly basic.
I am trying to build a data base for humanitarian projects that do not at all resemple of the usual examples including customers, invoices, suppliers and what have you. My problem in constructing the DB is that most of the projects will address more than one subject and also include more than one target group and even operate in more than one country.
In my first attempt I filled the relevant fields (subjects, target groups and country) with more than one value using a form with multi select lists. The problem was that it was very difficult to query these multi-value fields and kind people in this forum strongly advised my to reconstruct the DB avoiding such fields.
What I need is to be able to view/print various selections based on precise criteria that include a region (or country), a subject and a target group in all kind of combinations.
The problem is to decide on what tables to establish and their interrelation. I guess that when entering a project record (using a form) I will have to store somewhere what subjects (could be more than five) and target groups the project include. It is, of course, not a problem to establish special tables or value lists for the subjects and target groups and countries, but where/how do I store the basic project information for a project and the multi-values that are related to the individual project?
I hope that this is not too confusing and I would appreciate any suggestion for a simple table structure and the interrelation between the tables.
Many thanks in advance.
Niels

View 1 Replies View Related

Changing Structure Of Multiple Tables

Oct 1, 2006

I want to add 3 new fields to the structure of around 80 tables (all with identical structures). Is there a way to automate this process?

Paul.

View 8 Replies View Related

Tables :: Correcting Table Structure

Apr 2, 2015

I have been working on a a table design, but I am failing to create the correct relationships.My main table is the tblIncident with the three remaining tables being linked via a one to many relationship. I am using an auto number as my primary key, then linking that number to a FK in each table.

The end goal is to create one form with a varying sample of combo boxes, check boxes and data entry fields from each table. I did not plan to create a subform for each table, but maybe that is required?

View 3 Replies View Related

Need Help With System Tables And Front-end/back-end Applications

Oct 29, 2007

I currently have a front-end/back-end database, but at some point in time one of the tables has been modified and whenever the front end connects it comes up with a parameter request for a field that no longer exists. I have narrowed it down to MSysQueries, where there is a reference to this field. Is there anyway I can avoid this or change/repair the system table?

Compact and repair doesn't work unfortunatly.

Thanks

View 3 Replies View Related

General :: Extract PID From System Security Tables

Apr 7, 2013

I have inherited a 2003 db with unknown PIDs for the Group & User security.When trying to alter User details, I'm asked for a PID, so I'm trying to find the PID for the existing users.

I've gone to unhide the systems tables to get a dump of the data & hopefully find the PIDs but no luck so far.There is a Parent ID & if I run a query from the Users DB file, it appears as if it something like japanese writing ???

View 1 Replies View Related

Tables :: Table Structure For Training Matrix

Nov 8, 2014

I am starting out creating a training database to track training needs and expiring training etc.I'm just looking for some tips as to how to structure the tables and relationships..I have an employee table, department table and training type table.However im wondering how i can set up requirments and then match these to check if the person is trained up to date on all required skills?

View 2 Replies View Related

Copying The Structure Of Forms And Tables And Their Associations?

Sep 8, 2011

I have a psychology project where we soon use a questionnaire on a daily basis (maybe 80 variables per day per subject). Currently, there is no data in the database.

I've managed to create a table called day1 (with 80 day1 variables) and a form that looks like the questionnaire we want to use (and linked apropriately to the variables in the table for day1).

What is an easy way of duplicating the table and form for successive days? That is, i want the structure of the day1 table copied to another table (call it day2). It has exactly the same variables except they are slightly different to differentiate them from day1. I would like the form for day2 to have exactly the same layout as the form for day1, but link to the variables in table 2.

I know i could just couple the day1 table, change the variable names slightly, and then copy the form for day1 and change the links to point to table2, but there are many assessments (18 days).

View 3 Replies View Related

Tables :: Automatic Numbering System - Identifier Of Task

Jul 30, 2013

I like to have a Auto number field in my table (tbltask) that use below codification

B10000001

Where B = Base code and 000001 = Identifier of the task.

The identifier of the task is a unique 7 digits number

View 5 Replies View Related

Tables :: Database Design Structure For Controllers And Heating

Mar 4, 2014

I haven't been on Access for a while so im still in the process of getting the cogs turning....... i am trying to design a database structure for controllers and heating.

each controller can have many heating units
each heating unit can use many controllers

rather than code everything, how could i set this up?

Example:
Controller01 can be used with Boiler01, Boiler04, Boiler12, Boiler 20
Controller02 can be used with Boiler01, Boiler05, Boiler15
Controller03 can be used with Boiler02, Boiler03, Boiler04, Boiler20

I have a table with a ControllerID and a table with a BoilerID. In the boiler table, i have the ControllerID and a one to many relationship.

How would I set this up?

View 1 Replies View Related

Tables :: Table Structure For Cascading Combo Boxes

Jul 19, 2014

I need a table structure that will allow me to have a repair log data entry form with 3 cascading combo boxes on the repair log data entry form. There can be many repairs for a specific job but most of the time there will be one repair per job and 1% of the time two or more repairs for a specific job.

I am pulling a report based on a query that will show the repaired location, facility type, repaired item, repaired component on that item and other details related to the repair.I uploaded an empty database with the structure.

Cascade levels

I. Facility Type
II. Item by [I]
III. Component by [II]

View 14 Replies View Related

Tables :: Creating Invoice System With Subform Within Main Form?

Nov 24, 2013

I'm trying to create an invoice system with a sub-form within the main form. The issue I'm having is that the data in the sub-form keeps getting overwritten each time a new record is created for the main form. So when I go back to edit an older record, the data in the sub-form is changed to whatever the latest record had in it. Is there a way to lock in the data in the sub-form so that it stays with it's own record?

View 1 Replies View Related

Tables :: Designing Fee Receiving System - Due Field To Show Balance

Nov 25, 2012

I did using below:

One table with Student Basic Records with Course name and Total Fee

Tabel name Student_Rec and Fields are below
ID, StudentName, Course Name, RollNo, Total Fee

then another table name Fee_Details for receiving dues in installments.
ID, RollNo, FeeDue, FeePaid, Comments

Now i want the FeeDue Field should show the Balance feedue of each student

I mean it automatically check total fee due from student_Rec table and also check all previous entries for the same rollnumber in Fee_details Table and show the pending amount as FeeDue.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved